You can create multiple-source collation key indexes in Horizon. Multi-source indexes combine entries that are MARC-mapped from bib and authority records in a single browse list. This lets you search a single, sorted list containing both authors and titles.
Multi-source indexes work by defining two index definitions in Horizon. Both index definitions specify the same index table as their “output” destination, but one index uses the auth table as the “input” source, and the other index uses the bib table as the “input” source.
A multiple-source index is set up as a “union” or combination of a title-type index and an author-type index. It contains an auth# and cross-reference column like an authority index table, and a bib# and n_titles column like a title index table. It also contains a single instance of columns common to both types of index, such as the id#, backlink, and processed columns. Most likely, a uniform title index is a multi-source collation key index.
By creating two index definitions, Horizon considers these two indexes as one overlapping index and displays the search results in one window.
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 multi-source 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 two MARC maps to use with the index. (For details, see Creating New MARC Maps for the Multiple-Source Index .) |
3. | Create two index definitions in the Table Editor. (For details, see Creating Two Index Definitions in the Table Editor .) |
4. | Create a view definition for the index. (For details, see Creating a View Definition for the Index .) |
5. | Add the new index definition to your search options. (For details, see Adding the New Index Definition to Your Search Options .) |
6. | Populate the new index. (For details, see Populating Your New Multiple Source Index Using ReIndex .) |
© 1998-2017 Sirsi Corporation