首页>
外国专利>
AUTOMATED RELATIONAL SCHEMA GENERATION WITHIN A MULTIDIMENTIONAL ENTERPRISE SOFTWARE SYSTEM
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.
展开▼