Domino

Domino Instant Reporting System

Summary	The Domino Instant Reporting System is an ETL engine that automatically utilizes the local DBMS data dictionary to open any transaction data structure from applications for instant reporting.
Infosite	none
Description	Today there is no justification left for expensive and inflexible techniques known as star scheme data mart. For that reason the Domino Instant Reporting System neglects manual/handmade or halfway tool based generation of data marts which has been practiced widely unquestioned in Business Intelligence over the past two decades. The Domino Instant Reporting System exploits information kept in the DMBS used for driving applications. Efficiency of initial implementation is directly dependent from the quality of maintenance of the DBMS' data dictionary. After initial implementation the system permanently performes extraction transformation and loading (ETL) mechanisms providing the user an appropriate data structure for instant and authentic reporting from application data. The following are some special features provided. The time dimension for historization of data is produced automatically. Compound attributes from m:n relations that cannot be normalized are translated into primary keys. Metadata tables are generated and maintained automatically to trace and document the path an application data value has taken from its source to any report produced. Every component of the Domino data structure is time-stamped for status documentation of source data when used in a report.