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:
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:
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