Multidimensional Data Modeling for Data Warehouses
DOI:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    Data model is a basic aspect in the research field of data warehouses. It has been argued that traditional data models, such as the ER model and the relational model, are in principle not powerful enough for modeling the data structure and semantics of data warehouse and supporting OLAP (on-line analysis processing). As a result, several multidimensional models based on multidimensional view of data have emerged. However, these multidimensional data models still fall short of ability to model complex data in some real-world application domains and to support complete OLAP operations. In this paper, the authors propose a new multidimensional data model based on the concepts of partial order and mapping. This model addresses supporting for complex data structure and semantics of data warehouses, especially complex hierarchies in dimensions. Along with the model, they also present an associated algebra that includes a complete set of OLAP operations and supports complex aggregation, roll-up and drill-down along hierarchies in dimensions. A new concept of aggregation function constraint is also presented in this paper, and the mechanism for expressing and checking the aggregation function constraint is included in the model.

    Reference
    Related
    Cited by
Get Citation

李建中,高宏.一种数据仓库的多维数据模型.软件学报,2000,11(7):908-917

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:November 24,1999
  • Revised:April 14,2000
  • Adopted:
  • Online:
  • Published:
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-4
Address:4# South Fourth Street, Zhong Guan Cun, Beijing 100190,Postal Code:100190
Phone:010-62562563 Fax:010-62562533 Email:jos@iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063