NOTE: The Help system does not describe how to perform normal database administration tasks. Rather, it describes only what these tasks are. It is assumed that the users reading these topics are database administrators who already possess database administration skills.
There are several aspects to the database administration that should be implemented by the maintainers of the Questra IDM Application Suite databases. Before the specific administration tasks are discussed, it is important to understand the data flow in the system.
All data from users and devices are initially stored
in the Enterprise database. This data is periodically copied to the Analytics
database via a process called the Analytics
Load. This makes the data available to the Analytics application
(used for generating reports) and various historical data displays in
the web application..
Data does not stay resident in the Enterprise database forever. The process that deletes this data is called the Enterprise Cleanup. Data is deleted from the Enterprise database based on the age of the data, and the desired data retention. This process validates that data is never deleted that has not been previously copied to the Analytics database.
Data cannot stay resident in the Analytics database forever either. The process that moves the data to offline storage is called the Analytics Archive. There are two operations for in this process: export and restore. The export operation copies the data from the Analytics database to a directory structure on the file system and removes it from the Analytics database. The restore operation takes a previously exported data set and imports this back into the Analytics database. The Analytics Archive process operates on specific categories of data for a specific time period.
See also