On the Aggregation of Multi-dimensional Data using Data Cube and MDX

  • Ahn, Jeong-Yong (Department of Computer Science and Statistics, Seonam University) ;
  • Kim, Seok-Ki (Department of Computer Science and Statistics, Chonbuk National University)
  • Published : 2003.02.28

Abstract

One of the characteristics of both on-line analytical processing(OLAP) applications and decision support systems is to provide aggregated source data. The purpose of this study is to discuss on the aggregation of multi-dimensional data. In this paper, we (1) examine the SQL aggregate functions and the GROUP BY operator, (2) introduce the Data Cube and MDX, (3) present an example for the practical usage of the Data Cube and MDX using sample data.

Keywords

References

  1. 한국통계학회논문집 v.7 no.2 On-Line Analytical Porcessing and Research Problems for Statisticians 안정용;한경수
  2. ACM SIGMOD Record v.26 no.1 An Overview of Data Warehouses and OLAP Technology Chaudhuri, S.;Dayal, U.
  3. Proceedings of the Information and Knowledge Management Requirement-Based Data Cube Schema Design Cheung, D. W.;Zhou, B.;Kao, B.;Lu, H.;Lam T. W.;Ting, H. F.
  4. Data Mining and Knowledge Discovery v.1 no.1 Data Cube: A Relational Aggregation Operator Generalizing Group-By,Cross-Tab, and Sub-Totals Gray, J.;Chaudhuri, S.;Bosworth, A.;Layman, A.;Reichart, D.;Venkatao, M.
  5. Proceedings of the ACM SIGMOD on Management of Data Implementing Data Cubes Efficiently Harinarayan, V.;Rajaraman, A.;Ullman J. D.
  6. Proceedings of International Conference on Statistical and Scientific Database Management Summarizability in OLAP and Statistical Data Bases Lenz, H. J.;Shoshani, A.
  7. Proceedings of the ACM Symposium on Principles of Database Systems(PODS) OLAP and Statistical Databases: Similarities and Differences Shoshani, A.
  8. OLAP Solutions: building multidimensional information systems Thomsen, E.
  9. Microsoft OLAP Solutions Thomsen, E.;Spofford, G.;Chase, D.