AUTOMATED RELATIONAL SCHEMA GENERATION WITHIN A MULTIDIMENTIONAL ENTERPRISE SOFTWARE SYSTEM
摘要
Techniques are described for publishing multidimensional data from an enterprise software system. A relational database schema is automatically created for storing the multidimensional data. The database schema may be a relational star schema as described herein. The techniques may include processes for automatically producing the database schema based on the organization of the multidimensional data cube, and for populating the database schema with data from the data cube. The database schema may be used for reporting the multidimensional enterprise data, or may serve as a staging area to move the enterprise data toward a data warehouse within an enterprise software system. The reporting schema may support heterogeneous data types and heterogeneous formats. The reporting schema may also contain metadata that describes the schema, allowing for enhanced interpretation of the database schema. Also described is a process for automatically generating a reporting model from the database schema.
申请公布号
WO2006064383(A2)
申请公布日期
2006.06.22
申请号
WO2005IB04139
申请日期
2005.11.16
申请人
COGNOS INCORPORATED;LEGAULT, THOMAS;ROY, DOMINIQUE;ANTROBUS, MARK