Data Mart
Use data marts to extract data for subsequent use. Use datamarts for more efficient storage of frequently accessed data; for data that you want to preserve after its purge time; for exporting data from Guardium; and for creating distributed reports.
The Data Mart extraction program runs in a batch according to the specified schedule. It summarizes the data to hours, days, weeks, or months according to the granularity requested and then it saves the results in the Guardium Datamart database. The data is accessible to the users via the standard Reports and Audit Process utilities, like any other domain/entity. The Data Mart extraction data is available under the DM domain. The Entity name is set according to the new table name specified for the data mart data. Using the standard Query-Report Builder, you can clone the query and edit the Query-Report.
The summarization of data shrinks the data volume significantly. It eliminates joins of many tables by storing the data analysis in un-normalized and pre-calculated tables.
- Extract data to table (in Guardium).
- Extract data to file, for exporting to an external system.
- Central Management and Data Mart
- In a Central Management environment, the configuration is distributed automatically to the managed units. The extraction schedule is defined locally on each unit. In case of multiple Central Managers, the Data Mart definition can be cloned by using the Export/Import capability.