By Topic

An automatic method of data warehouses multi-dimension modeling for distributed information systems

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

4 Author(s)
Lihong Jiang ; School of Software, Shanghai JiaoTong University, China ; Junliang Xu ; Boyi Xu ; Hongming Cai

Nowadays many companies built enterprise level data warehouses (DW) for decision making support. However explosive data accumulated in distributed databases in company or across companies with the widely use of Computer Supported Cooperative Work in Design (CSCWD) technologies. Therefore it becomes a time costing task for engineers to construct the multidimensional model of data warehouse. This research presents an ontology approach to eliminate data source heterogeneity aiming to design the conceptual structure of data warehouse automatically. The proposed approach includes a domain ontology mete-data model, which consists of data, concept, ontology and resource repositories, to describe the semantic meaning of the data sources. The supply-driven and demand-driven methodologies are combined together to construct the concept model of DW. By supply-driven method, domain ontology system is extracted bottom-up from data sources; on the other hand, by demand-driven method, relationships of the concepts in the ontology system are extended top-down according to the business process. Furthermore, candidate of the data warehouse concept model is derived according to the relationships of the concepts in the ontology system. After discussing the process of data warehouse designing, a case study is given to show how our method is used in clinic domain. The result shows that ontology method could help users designing data warehouse more easily.

Published in:

Computer Supported Cooperative Work in Design (CSCWD), 2011 15th International Conference on

Date of Conference:

8-10 June 2011