Abstract:Data warehouse contains vast amount of data to support complex queries of various Decision Support Systems (DSSs). It needs to store materialized views of data, which must be available consistently and instantaneously. Using a frame metadata model, this paper presents an architecture of a universal data warehousing with different data models. The frame metadata model represents the metadata of a data warehouse, which structures an application domain into classes, and integrates schemas of heterogeneous databases by capturing their semantics. A star schema is derived from user requirements based on the integrated schema, catalogued in the metadata, which stores the schema of relational database (RDB) and object-oriented database (OODB). Data materialization between RDB and OODB is achieved by unloading source database into sequential file and reloading into target database, through which an object relational view can be defined so as to allow the users to obtain the same warehouse view in different data models simultaneously. We describe our procedures of building the relational view of star schema by multidimensional SQL query, and the object oriented view of the data warehouse by Online Analytical Processing (OLAP) through method call, derived from the integrated schema. To validate our work, an application prototype system has been developed in a product sales data warehousing domain based on this approach.

Uniform Representation Model for Metadata of Data Warehouse

Metadata Management Technology in Data Warehouse

Metadata-oriented Data Model Supporting Railway Distributed System Integration

Research on the Common Warehouse Metamodel

Research of model driven architecture based on CWM

Universal Data Warehousing Based on a Meta-Data Modeling Approach.

Metadata Management of Heterogeneous Data

Research and Design of Meta Data Integration Architecture Based on Model-driven

Research on Open Information Model

Research and Application of Data Modeling and Integration Based on Metadata

Survey of Metadata Management Technology for Data Warehousing

Research of Distributed Heterogeneous Data integration Based on Metadata

Metadata of Spatial Data Warehouse and Its Realization

Study on a Metadata-driven ETL Approach

Building Metadata in Data Warehousing System

Metadata Management System Based on Bank Data Warehouse

Semantics-Oriented Metadata Model and Its OWL Representation

A unified representation method for interdisciplinary spatial earth data

Management and Maintenance of Data Warehouse Based on GMM

Research on the Metadata Standard of Data Warehousing

Yearbook Data Integration Based on Common Warehouse Model.