Insight contains five main data table types
- Server Settings – contain settings for the server instance as opposed to the collection, like Media File Locations (SPS).
- Catalog Template Settings – contain definitions for each of the catalog templates, including schema, field, and table properties.
- Collection Settings – contain specific settings for collections such as background images, names, descriptions, etc.
- Data Tables – contain the data for each collection once imported/indexed into Insight.
- Indexer Tables – (optional) if used, data is drawn from the source tables using the indexer, and restructured for storage in the Insight Data Tables.
...
In pre-5.x versions of Insight, there was a dependency on a set of source data tables to provide content for Insight. These source data tables, in the form of a relational database schema, were mapped and defined as a Catalo Catalog Template using Fields, Record Types, Record Relationships and Joins. The joins represent the relationships between the source data tables and enable the import of data into the Insight Data Tables via the Insight Indexer. The Record Types, Record Relationships, and Fields defined the data schema within Insight.
The basic indexing process was as follows:
...