Article

Multidimensional models: constructing data CUBE

Authors:

Antoaneta Ivanova,

Boris RachevAuthors Info & Claims

CompSysTech '04: Proceedings of the 5th international conference on Computer systems and technologies

Pages 1 - 7

https://doi.org/10.1145/1050330.1050444

Published: 17 June 2004 Publication History

Abstract

The goal of this article is to depict algorithms and new approach of creating data cube efficiently and to set tasks for future work. In short, the paper has described it as a data abstraction that allows one to view aggregated data from a number of perspectives: 1) Conceptually, the cube consists of a base cuboid, surrounded by a collection of sub-cubes that represent the aggregation of the base cuboid along one or more dimensions; 2) The basic methods for computing a group-by: sort-based and hash-based. 3) Dynamic Data Cube, which provide efficient performance and allows for the data cube expansion in any direction. 4) OO Conceptual Model Data Cube - class definition of data cube.

References

[1]

Agarwal S., R. Agrawal, P. Deshpande. On the Computation of Multidimensional Aggregates In Proceedings of the 22nd international Conference on Very Large Databases, 506--521, Mumbai (Bombay), 1996.

Digital Library

Google Scholar

[2]

Chaudhuri S., U. Dayal. An overview of datawarehousing and OLAP technology, ACM SIGMOD Record 1997, 26(1):65--74.

Digital Library

Google Scholar

[3]

Geffner S., D. Agrawal, A. EI Abbadi, T. Smith. Relative Prefix Sums: An Efficient Approach for Querying Dynamic OLAP Data Cubes, In Proc. of the 15th International Conference on Data Engineering. Sydney, Australia, March 1999.

Digital Library

Google Scholar

[4]

Gray J., A. Bosworth, A. Layman, H. Pirahesh. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-total, In Proceedings of the 12Th. IEEE International Conference on Data Engineering, 152--159, New Orleans, LA, February - March 1996.

Digital Library

Google Scholar

[5]

Kotidis Y., N. Roussopoulos, An alternative storage organization for ROLAP aggregate views based on cubetrees, ACM SIGMOD Record 1998, 27(2): 248--258.

Digital Library

Google Scholar

[6]

Lewis P., Database and Transaction Processing: An Application - Oriented Approach, Addison Wesley, New York, 2003.

Google Scholar

[7]

Molina.H, J. Ullman, J. Windom, DataBase Systems: The Complete Book, Prentice Hall, 2002, 1119p.

Digital Library

Google Scholar

[8]

Mumick S., D. Quass, B. Mumick, Maintenance of Data Cubes and Summary Tables in a Warehouse, In Proceedings of the ACM SIGMOD International Conference on Management of Data, 100-111, Tucson, Arizona, May 1997.

Digital Library

Google Scholar

[9]

Palpanas T., Knowledge discovery in data warehouses, ACM SIGMOD Record, September 2000, 29(3).

Digital Library

Google Scholar

[10]

Trujillo J., M. Palomar, J. Gomez, Y. Song. Designing Data Warehouses with OO Conceptual Models, Computer, 66-75, December 2001, IEEE

Digital Library

Google Scholar

[11]

Ullman J., Efficient Implementation of Data Cube Via Materialized Views, http://db.stanfort.edu/~ullman

Google Scholar

[12]

Vassiliadis P., A Survey of Logical Models for OLAP Databases. ACM SIGMOD Record, December 1999, 28(4).

Digital Library

Google Scholar

[13]

Widom J., Research Problems in Data Warehousing, Proc.4th Intl. CIKM Conference., 1995.

Digital Library

Google Scholar

[14]

Zhao Y., P. Deshpande, J. Naughton. An Array-Based Algorithm for Simultaneous Multidimensional Aggregates, In ACM SIGMOD International Conference, 159--170, Tuscon, AZ, USA, June 1997.

Digital Library

Google Scholar

Cited By

View all

Ivanova A(2020)Approaches for efficient data extraction from data cube structure2020 International Conference Automatics and Informatics (ICAI)10.1109/ICAI50593.2020.9311335(1-5)Online publication date: 1-Oct-2020
https://doi.org/10.1109/ICAI50593.2020.9311335
Mann SPhogat A(2020)Dynamic construction of lattice of cuboids in data warehouseJournal of Statistics and Management Systems10.1080/09720510.2020.179949823:6(971-982)Online publication date: 29-Jul-2020
https://doi.org/10.1080/09720510.2020.1799498
Prashant RSuman MEashwaran R(2020)Efficient Data Cube MaterializationAdvances in Communication and Computational Technology10.1007/978-981-15-5341-7_16(199-210)Online publication date: 14-Aug-2020
https://doi.org/10.1007/978-981-15-5341-7_16
Show More Cited By

Multidimensional models: constructing data CUBE
1. Information systems
  1. Data management systems

Recommendations

An efficient method for maintaining data cubes incrementally

The data cube operator computes group-bys for all possible combinations of a set of dimension attributes. Since computing a data cube typically incurs a considerable cost, the data cube is often precomputed and stored as materialized views in data ...
Graph cube: on warehousing and OLAP multidimensional networks
SIGMOD '11: Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

We consider extending decision support facilities toward large sophisticated networks, upon which multidimensional attributes are associated with network entities, thereby forming the so-called multidimensional networks. Data warehouses and OLAP (Online ...
ROLAP implementations of the data cube

Implementation of the data cube is an important and scientifically interesting issue in On-Line Analytical Processing (OLAP) and has been the subject of a plethora of related publications. Naive implementation methods that compute each node separately ...

Comments

Information & Contributors

Information

Published In

CompSysTech '04: Proceedings of the 5th international conference on Computer systems and technologies

June 2004

661 pages

ISBN:9549641384

DOI:10.1145/1050330

Conference Chair:
Kiril Boyanov
Bulgaria

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 17 June 2004

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Acceptance Rates

Overall Acceptance Rate 241 of 492 submissions, 49%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 05 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Ivanova A(2020)Approaches for efficient data extraction from data cube structure2020 International Conference Automatics and Informatics (ICAI)10.1109/ICAI50593.2020.9311335(1-5)Online publication date: 1-Oct-2020
https://doi.org/10.1109/ICAI50593.2020.9311335
Mann SPhogat A(2020)Dynamic construction of lattice of cuboids in data warehouseJournal of Statistics and Management Systems10.1080/09720510.2020.179949823:6(971-982)Online publication date: 29-Jul-2020
https://doi.org/10.1080/09720510.2020.1799498
Prashant RSuman MEashwaran R(2020)Efficient Data Cube MaterializationAdvances in Communication and Computational Technology10.1007/978-981-15-5341-7_16(199-210)Online publication date: 14-Aug-2020
https://doi.org/10.1007/978-981-15-5341-7_16
Abuelyaman EElgimari A(2014)A Prototype for a Data Mining Based Pathfinder to Sudanese UniversitiesProceedings of the 2014 UKSim-AMSS 16th International Conference on Computer Modelling and Simulation10.1109/UKSim.2014.65(119-124)Online publication date: 26-Mar-2014
https://dl.acm.org/doi/10.1109/UKSim.2014.65
Gosain AKhatri SMann S(2014)Multidimensional modeling for data warehouse using object oriented approachProceedings of 3rd International Conference on Reliability, Infocom Technologies and Optimization10.1109/ICRITO.2014.7014707(1-6)Online publication date: Oct-2014
https://doi.org/10.1109/ICRITO.2014.7014707
Teng MWidagdo T(2014)Application program interface to build executive information system using data warehouse2014 International Conference on Data and Software Engineering (ICODSE)10.1109/ICODSE.2014.7062489(1-5)Online publication date: Nov-2014
https://doi.org/10.1109/ICODSE.2014.7062489
Kumar ASingh DSharma V(2014)Achieving query optimization using sparsity management in OLAP system2014 International Conference on Issues and Challenges in Intelligent Computing Techniques (ICICT)10.1109/ICICICT.2014.6781382(797-801)Online publication date: Feb-2014
https://doi.org/10.1109/ICICICT.2014.6781382

Abstract

References

Cited By

Recommendations

An efficient method for maintaining data cubes incrementally

Graph cube: on warehousing and OLAP multidimensional networks

ROLAP implementations of the data cube

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations