Empower Snapshot Table Views
In order for EnterWorks to accept record attribute values that may be invalid or exceed database limits, EnterWorks stores them in XML. Accessing or manipulating these attribute values requires parsing the XML, which can be time-consuming. For performance reasons, values that need to be accessed quickly or frequently can be included in the Empower DataMart Snapshot Table Views, (commonly called “snapshot tables”). EnterWorks copies the indicated XML values, parses them, and stores them in the snapshot tables, in appropriately data-typed columns, where they can be searched and accessed quickly and efficiently. Only valid attribute values will be copied to the snapshot tables; invalid values will be stored as NULL.
A repository can have the following types of EnterWorks snapshot table views:
Typically, when the main snapshot table view is referenced, it is called simply “the snapshot table”. The category attribute and multi-language snapshot tables are ancillary tables. If a main snapshot table exists, the category attributes and multi-language snapshot tables can be created to extend the abilities of the main snapshot table.