Creating a Collation Key Index

A collation key index is a type of browse index. (A browse index lets you search for words at the beginning of any string in a MARC record.) Horizon provides two ways to create a browse index. You can create an alpha browse index, or you can create a collation key index. An alpha browse index lets you use the codepage of your database to handle the characters that the index needs to sort and display. (The Horizon database codepage is limited to 256 characters.) A collation key index, however, is not limited to use the codepage of the database—it lets you use Unicode to sort and display characters. (Unicode lets you sort and display over 40,000 characters.) In addition, a collation key index lets you sort and display titles in languages that are not supported by MARC, such as Tibetan.

This table lists some of the different languages that each type of browse index can handle:

Index

Languages

Alpha Browse index

This index sorts, displays, and indexes titles from western European languages:

English
French
German
Italian
Spanish, and so forth

Collation Key index

This index sorts, displays, and indexes titles from these and other languages:

Arabic
Bengali
Cyrillic
English
French
German
Greek
Italian (and all other Western European languages)
Japanese
Korean
Tibetan
Gujarati

You can create collation key indexes to index bib or authority information. In addition, you can create a single or multiple tag collation key index. A single tag index retrieves and indexes data from only one tag in a MARC record. For this type of index, Horizon uses the first tag in a hierarchy of tags in the MARC map to know the tag to retrieve and display. A multiple tag index retrieves and indexes data from all specified tags in a MARC record. You can make any browse index that you create a collation key index.

As you do steps in this section, you use information or codes (such table names and MARC map codes) that you create in one task for subsequent tasks. Because of this, you may want to write down codes as you create them. You do some of the tasks in this section in your SQL query tool. Other tasks you do in the Horizon Table Editor.

You should create a collation key index from scratch only if you are completely comfortable creating and running SQL scripts to create data structures. If you are unsure about any of the steps in this section, Customer Support can create the index for you for an add-on service fee. To have a new index created for you, contact your Customer Sales Representative for a price quote.

 

Do not delete the existing Horizon “title” index. Your collation key indexes cannot work without this Horizon index.

You create a collation key index by completing these tasks in this order:

1. Create database objects for the index. (For details, see Creating Database Objects for the Index .)
2. Create a MARC map to use with the index. (Creating a New MARC Map for the Index .)
3. Create an index definition in the Table Editor. (Creating the Index Definition in the Table Editor ).
4. Set up browse scoping support, if desired. (Setting Up Browse Scoping Support for HIP 4.X.)
5. Create a view definition for the index. (Creating a View Definition for the Index .)
6. Add the new index definition to your search options. (Adding the New Index Definition to Your Search Options .)
7. Populate the new index. (Populating Your New Index Using ReIndex.)

Note: This section explains how to create only a collation key index. If you want to create an alpha browse index, see Creating a Single Alphabetical or Single Keyword Search Option

 


© 1998-2017 Sirsi Corporation