Creating an Index Definition for the Index

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

There are many types of keyword indexes you can create on your Horizon system. This section contains only an example of an index definition setup for a title keyword index. Depending on what type of keyword index you are creating, your index definition setup may be different.

To create an index definition for the index

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 a Title Keyword index, you may enter “titlKW”.)

Description

Enter a description for the index.

For example, if you are creating a Title Keyword index, you would enter “Title Keyword”.

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 in a previous task. (For more information, see Creating an Index Table .)

Sort Col.

Enter “word#” if you are creating a keyword index.

This is the name of the column in the new index table that sorts the data.

Base Table

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

For a Title Keyword index, this is the bib table.

Base Index Col.

Enter the column in either the auth or bib table where the index finds the raw data (the text of the MARC subfields and tags).

For a Title Keyword index, this is the “text” column.

Key Col.

Do one of these options:

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

For a Title Keyword index, you would enter “bib#”.

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

N_Keys Col.

Enter the name of the column (new entry) you added to the word table in a previous step. (For more information, see Adding a Word Table Entry for the Index .)

For example, enter “n_titlkws”.

This column records how many times the word exists in the index you are creating.

Word Table

Leave this field blank.

marc_map

Enter or choose the code for the MARC map this index will use to extract MARC tags and subfields.

For a Title Keyword index, you can use the MARC map you created in a previous step. (For more information, Creating a MARC Map for the Keyword Index )

One Tag Only

Do one of these options:

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

For a Title Keyword index, you would clear the mark from this box.

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 as specified in this MARC record.

Ignore Spacer For Indexing

Leave this box unmarked.

Show Author

Leave this box unmarked.

Show Subject

Leave this box unmarked.

Show Series

Leave this box unmarked.

Index Type

Choose the Keyword option.

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

Processor

Enter the type of processor Horizon uses for the index type.

For a Title Keyword index, you would enter the “keyword” processor.

2 In these fields, do the following:

Field

Action

Display type

Choose one of these options:

Staff-only. This contains only records with the Staff Only flag checked.
Public-only. This contains only records with the Staff Only flag cleared.
Combined. This contains 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” in this field.

Horizon uses this value in Deferred Indexing.

Add Alternate ISBN

Horizon can handle 13-digit ISBNs in its processes, if you set it up to do so. (For example, you can search on 10 or 13-digit ISBNs to retrieve the correct item. Or, ISBNs on BISAC orders and in a Vendor Integration Protocol request truncate the ISBN to ten digits when necessary.)

Marking this box guarantees that both a 13-digit ISBN and a 10-digit ISBN are in your index. (For example, if an ISBN is entered as a 10-digit ISBN, then Horizon generates the 13-digit version, and vice versa.) However, marking this box does not add the alternate ISBN to the MARC record.

Note: This field was added in Horizon 7.4. After upgrading to Horizon 7.4 or later, you can implement use of 13-digit ISBNs. (For more information, see Setting Up Horizon to Use 13-Digit ISBNs.

Sort Width

For a title keyword index, leave this field blank.

 


© 1998-2017 Sirsi Corporation