Multidimensional Data Modeling for Data Warehouses
Affiliation:

  • Article
  • | |
  • Metrics
  • |
  • Reference [10]
  • |
  • Related [20]
  • |
  • Cited by [54]
  • | |
  • 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
    [1]Coliat G. OLAP, relational, and multidimensional database system. SIGMOD Record, 1996,25(3):64~69
    [2]Codd E F. Providing OLAP (on-line analytical processing) to user-analysts: an IT mandate. Technical Report, TR-9300011, E.F. Codd and Associates, 1993
    [3]Agrawal R, Gupta A, Sarawagi S. Modeling mulidimensional databases. In:Jackson M, Pu C eds. Proceedings of the 13th International Conference on Data Engineering. Los Alamitos, CA: IEEE Society Press, 1997. 105~116
    [4]Rafanelli M, Shoshani A. STORM: a statistical object representation model. Data Engineering Bulletion, 1990,13(3):12~18
    [5]Gyssens M, Lakshmanan L V S. A foundation for multi-dimensional databases. In: Dayal U, Gray P M D, Nishio S eds. Proceedings of the the 23rd Conference on very large data bases. San Francisco, CA: Morgan Kaufmann Publishers, Inc., 1997. 106~115
    [6]Li C, Wang X S. A data model for supporting on-line analytical processing. In: Barker K, Manitoba U eds. Proceedings of the 5th International Conference on Information and Knowledge Management. New York: Springer-Verlag, 1996. 81~88
    [7]Lehner W. Modeling large scale OLAP scenarios. In: Jorg H, Ramos I eds. Proceedings of the 6th International Conference on Extending Database Technology. New York: Springer-Verlag, 1998. 153~167
    [8]Datta A, Thomas H. A conceptual model and algebra for on-line analytical processing in decision support databases. In: Thomas H eds. Proceedings of the 7th Annual Workshop on Information Technologies and Systems. San Mateo, CA: Morgan Kaufman Publishers, Inc., 1997. 91~100
    [9]Pedersen T B, Jensen C S. Multidimensional data modeling for complex data. In: Kitsuregawa M, Maciaszek L, Papazoglou M et al eds. Proceedings of the 15th International Conference on Data Engineering. Los Alamitos, CA: IEEE Society Press, 1999. 336~345
    [10]Gray J, Bosworth A, Layman A et al. Data cube: a relational aggregation operator generalizing group-by, cross-tab and sub-totals. Data Mining and Knowledge Discovery, 1997,1(1):29~54
    Comments
    Comments
    分享到微博
    Submit
Get Citation

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

Copy
Share
Article Metrics
  • Abstract:4305
  • PDF: 5866
  • HTML: 0
  • Cited by: 0
History
  • Received:November 24,1999
  • Revised:April 14,2000
You are the first2045016Visitors
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