Data warehouse enhancement: A semantic cube model approach

  • Authors:

  • Shi-Ming Huang;Tung-Hsiang Chou;Jia-Lang Seng

  • Affiliations:

  • Department of Accounting and Information Technology, National Chung-Cheng University, Chia-Yi, Taiwan;Department of Management Information Systems, National Cheng-Chi University, No. 64, Sec. 2, ZhiNan Rd., Wenshan District, Taipei City 11605, Taipei, Taiwan;Visiting Fulbright Senior Scholar, Stanford University, and Professor of Information Systems, Graduate School of Accountancy, College of Commerce, National Chengchi University, Wenshan District 11 ...

  • Venue:
  • Information Sciences: an International Journal
  • Year:
  • 2007

Quantified Score

Hi-index 0.07

Visualization

Abstract

Many data warehouse systems have been developed recently, yet data warehouse practice is not sufficiently sophisticated for practical usage. Most data warehouse systems have some limitations in terms of flexibility, efficiency, and scalability. In particular, the sizes of these data warehouses are forever growing and becoming overloaded with data, a scenario that leads to difficulties in data maintenance and data analysis. This research focuses on data-information integration between data cubes. This research might contribute to the resolution of two concerns: the problem of redundancy and the problem of data cubes' independent information. This work presents a semantic cube model, which extends object-oriented technology to data warehouses and which enables users to design the generalization relationship between different cubes. In this regard, this work's objectives are to improve the performance of query integrity and to reduce data duplication in data warehouse. To deal with the handling of increasing data volume in data warehouses, we discovered important inter-relationships that hold among data cubes, that facilitate information integration, and that prevent the loss of data semantics.