Creating the Index Definition in the Table Editor

You create an index definition for the collation key index you are creating. This definition controls how the data is stored, what database table column stores the sorted data, the name of the index, and so forth. Once you create this index definition, you assign the index to a search option that displays in staff searching.

To create the index definition in the Table Editor

View: mq_index
Process: Administration\Index Control Menu\Indexes

1 In these fields, do the following:

Field

Action

Mq Index

Enter a code for the index.

This is the code you assign to a specific search option. (For example, if you are creating an index for vernacular titles, you may enter “vntitle.”)

Description

Enter a description for the index.

For example, if you are creating an index for vernacular titles, you may enter “Browse Vernacular Titles”.

Index Table

Enter the name of the index table you created on the database.

This is the table that will store the data. This is the index table you created by running the SQL script. (For more information, see Creating Database Objects for the Index .)

Sort Col.

Enter “sort_weight” as the sort column.

This is the column in the new table that sorts the data.

Base Table

Enter the source table for the raw data (the data you want to index).

Typically, this will be either the bib or auth table depending on the type of MARC information you want to index.

Base Index Col.

Enter “text”.

This is the column in either the auth or bib table where the index finds the raw data.

You use the text column because it is the column in MARC-based tables that contains the text of the MARC tags and subfields.

Key Col.

Do one of these options:

If the MARC information you want to index is in the bib table, enter “bib#”.
If the MARC information you want to index is in the auth table, enter “auth#”.

This column is the link from the index to the source record that is indexed.

marc_map

Do one of these options:

If you created a new MARC map for the index, enter the code of the MARC map. (For instructions, Creating a New MARC Map for the Index )
If you did not create a new MARC map for the index, enter the code for one of the existing MARC maps.

A MARC map “tells” Horizon what subfields to pull from which tags under specific conditions for processing and inserting the data into the index table.

One Tag Only

Do one of these options:

If you are creating a multiple tag index, leave this box unmarked.
If you are creating a single tag index, mark this box.

When you mark this, Horizon extracts and indexes only the result of the first tag in the MARC record.

Ignore Spacer for Indexing

Leave this box unmarked.

Show Author

Mark this option only if you are creating an authority-based index for authors.

Show Subject

Mark this option only if you are creating an authority-based index for subjects.

Show Series

Mark this option only if you are creating an authority-based index for series.

Index Type

Choose the Collation-Key option.

The index type controls what algorithm Horizon uses as it indexes.

Processor

Enter the “UcSrtWt” processor.

Horizon uses this processor for unicode browse indexes.

2 Click Page Down.
3 In these fields, do the following:

Field

Action

Display type

Choose one of these options:

Staff-Only. This displays only records with the Staff Only flag checked.
Public-Only. This displays only records with the Staff Only flag cleared.
Combined. This displays both staff-only and public-only records.

Note: The Staff-Only option is useful only if your library has public-only indexes defined. This is because both staff-only and combined indexes contain staff-only records. Only public only entries filter out the staff-only records.

Queue

Enter a “0” (zero) in this field.

Horizon uses this value in Deferred Indexing. (For more information, see “Understanding Deferred Indexing” in the Cataloging Setup Guide.)

Stop Queue’s Indexer

Leave this box unmarked.

Horizon uses this value in Deferred Indexing.

Sort Width

Enter the number of bytes or characters on the database you want Horizon to sort.

If you used an SQL script to create your index table on the database, you should enter 250. (For more information on the SQL script, see Creating Database Objects for the Index .)

Note: You must enter a value in this field, or the index will not work.

 


© 1998-2017 Sirsi Corporation