Installed with Zing

Several types of components are installed with Zing.

Table 1. Tables installed with Zing
Table Description
Text Index [ts_index_name] Stores the tables the system indexes.
Index Stop Word [ts_index_stop] Stores the stop words for a specific table.
Stop Word [ts_stop] Stores the global stop words.
Text Search Groups [ts_group] Stores search groups for global text search.
  • ts_attachment
  • ts_chain_summary
  • ts_chain
  • ts_deleted_doc
  • ts_document
  • ts_index_stats
  • ts_phrase
  • ts_search_stats
  • ts_search_summary
  • ts_word_roots
  • ts_word
System tables that support Zing. Extending or modifying these tables is not recommended.
Table 2. Business rules installed with Zing
Business Rule Description
Text Search Property Change Rationally Ensures that valid values are entered for Zing text search properties.
Text Index Stop Reminder Warns the user of stop word changes that require the index to be rebuilt (table-specific). The warning is issued if record is deleted that had a stop mode "neither index nor query", if record's stop mode is updated to something else and was "neither index nor query", and if record's word is updated to something else and stop mode is "neither index nor query".
Stop Word Reminder Warns the user of stop word changes that require the index to be rebuilt (global). The warning is issued if record is deleted and it was active, if record is inactivated, and if record's word is changed and was active.
Table 3. Scheduled jobs installed with Zing
Scheduled job Description
TS Search Stats Compiles type-ahead suggestions each night. See Update A Type-Ahead Suggestion.
TS Index Stats Collects statistics and performs maintenance for text search and indexing. Runs nightly.
text index events process Collects statistics and performs maintenance for text search and indexing. Runs every 30 seconds.
TS Search Summary Compiles top search statistics each hour. See Update a top search statistic.
TS Chain Summary Compiles search chain statistics each hour.
Table 4. UI action installed with Zing
UI action Description
Regenerate Text Index Displays the Regenerate Text Index link on Text Index forms.
Table 5. Homepage installed with Zing
Homepage Description
Top Searches homepage Displays the most popular searches over the past hour, day, week, or month.