Caching can be used to avoid sending request each time to retrieve necessary information from DBMS. Foresight Analytics Platform uses data caching system tables' repository objects:
In-Memory data caching. Caching is executed by means of a special storage structure that stores binary data. Data is loaded to the memory on demand. All work with data is executed without addressing the DBMS.. For details see the In-Memory Data Caching section.
Repository Objects Caching. Repository objects can be cached by means of various mechanisms speeding up access to objects and their work. For details see the Repository Objects Caching section.
Metadata Caching. To speed up repository navigation, object metadata is cached. Metadata contains basic information about the object and information about object structure. Basic information includes object name, identifier and key. For details see the Metadata Caching section.
System Tables Caching. System metadata table caching allows for improving system performance and speeding up opening of complex reports that use a number of data sources in the web application by reducing the time of reading system tables from database. Caching is executed during BI server process startup. For details see the System Tables Caching section.
See also:
Navigator Interface | In-Memory Data Caching | Repository Objects Caching Metadata Caching | System Tables Caching