research-article

Multidimensional Database Technology

Authors:

Torben Bach Pedersen,

Christian S. JensenAuthors Info & Claims

Computer, Volume 34, Issue 12

Pages 40 - 46

Published: 01 December 2001 Publication History

Publisher Site

Abstract

Multidimensional data-base technology is a key factor in the interactive analysis of large amounts of data for decision-making purposes. In contrast to previous technologies, these databases view data as multidimensional cubes that are particularly well suited for data analysis. Multidimensional models categorize data either as facts with associated numerical measures or as textual dimensions that characterize the facts. Queries aggregate measure values over a range of dimension values to provide results such as total sales per month of a given product. Multidimensional database technology is being applied to distributed data and to new types of data that current technology often cannot adequately analyze. For example, classic techniques such as preaggregation cannot ensure fast query response times when data-such as that obtained from sensors or GPS-equipped moving objects-changes continuously. Multidimensional database technology will increasingly be applied where analysis results are fed directly into other systems, thereby eliminating humans from the loop. When coupled with the need for continuous updates, this context poses stringent performance requirements not met by current technology.

References

[1]

Information Systems, vol. 26, no. 5, 2001, pp. 383-423.

Digital Library

Google Scholar

[2]

Panos Vassiliadis, Timos Sellis, A survey of logical models for OLAP databases, ACM SIGMOD Record, v.28 n.4, p.64-69, Dec.1999

Crossref

Google Scholar

[3]

J. Gray et al., "Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab and Sub-Totals," Data Mining and Knowledge Discovery, vol. 1, no. 1, 1997, pp. 29-54.

Crossref

Google Scholar

[4]

A. Eisenberg and J. Melton,"SQL Standardization: The Next Steps," ACM SIGMOD Record, vol. 29, no. 1, 2000, pp. 63-67.

Digital Library

Google Scholar

[5]

R. Kimball,The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, John Wiley&Sons, New York, 1996.

Crossref

Google Scholar

[6]

E. Thomsen,OLAP Solutions: Building Multidimensional Information Systems, John Wiley&Sons, New York, 1997.

Crossref

Google Scholar

[7]

Proc. 9th Int'l Conf. Scientific and Statistical Database Management, IEEE CS Press, Los Alamitos, Calif., 1997, pp. 39-48.

Google Scholar

[8]

T. Zurek and M. Sinnwell,"Data Warehousing Has More Colours Than Just Black and White," Proc. 25th Int'l Conf. Very Large Databases, Morgan Kaufmann, San Mateo, Calif., 1999, pp. 726-729.

Crossref

Google Scholar

[9]

UK National Health Service, Read Codes Version 3, Sept. 1999,

Google Scholar

[10]

T.B. Pedersen, C.S. Jensen, and C.E. Dyreson,"Extending Practical Pre-Aggregation in On-Line Analytical Processing," Proc. 25th Int'l Conf. Very Large Databases, Morgan Kaufmann, San Mateo, Calif., 1999, pp. 663-674.

Crossref

Google Scholar

[11]

E.F. Codd, S.B. Codd, and C.T. Salley,"Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate,"

Google Scholar

[12]

R. Winter,"Databases: Back in the OLAP Game," Intelligent Enterprise Magazine, vol. 1, no. 4, 1998, pp. 60-64.

Google Scholar

[13]

E. Thomsen, G. Spofford, and D. Chase,Microsoft OLAP Solutions, John Wiley&Sons, New York, 1999.

Crossref

Google Scholar

Cited By

View all

Caruccio LPolese GTortora G(2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
https://dl.acm.org/doi/10.1145/2903726
Sifer MBailey JMoffat AAggarwal Cde Rijke MKumar RMurdock VSellis TYu J(2015)Bottom-up Faceted SearchProceedings of the 24th ACM International on Conference on Information and Knowledge Management10.1145/2806416.2806593(1771-1774)Online publication date: 17-Oct-2015
https://dl.acm.org/doi/10.1145/2806416.2806593
Macedo HOliveira J(2015)A linear algebra approach to OLAPFormal Aspects of Computing10.1007/s00165-014-0316-927:2(283-307)Online publication date: 1-Mar-2015
https://dl.acm.org/doi/10.1007/s00165-014-0316-9
Show More Cited By

Index Terms

Multidimensional Database Technology
1. Human-centered computing
  1. Visualization
    1. Visualization application domains
      1. Geographic visualization
2. Information systems
  1. Data management systems
    1. Database design and models
    2. Database management system engines
      1. Triggers and rules
  2. Information systems applications
    1. Spatial-temporal systems

Recommendations

Multidimensional database design via schema transformation: turning TPC H into the TPC H*d multidimensional benchmark
COMAD '13: Proceedings of the 19th International Conference on Management of Data

Compared to relational databases, multidimensional database systems enhance data presentation and navigation through intuitive spreadsheet like views and increase performance through aggregated data. In this paper, we present a framework for automating ...
Multidimensional models meet the semantic web: defining and reasoning on OWL-DL ontologies for OLAP
DOLAP '12: Proceedings of the fifteenth international workshop on Data warehousing and OLAP

Data warehouses use a multidimensional model. Based on this model, OLAP cubes enable users to analyze data. For correct OLAP analysis, multidimensional models should be checked. In particular, these models should ensure summarizability. Checking ...
Multidimensional data model and query language for informetrics

Multidimensional data analysis or On-line analytical processing (OLAP) offers a single subject-oriented source for analyzing summary data based on various dimensions. We demonstrate that the OLAP approach gives a promising starting point for advanced ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

Computer Volume 34, Issue 12

December 2001

155 pages

ISSN:0018-9162

Issue’s Table of Contents

Publisher

IEEE Computer Society Press

Washington, DC, United States

Publication History

Published: 01 December 2001

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

33
Total Citations
View Citations
0
Total Downloads

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

Reflects downloads up to 26 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Caruccio LPolese GTortora G(2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
https://dl.acm.org/doi/10.1145/2903726
Sifer MBailey JMoffat AAggarwal Cde Rijke MKumar RMurdock VSellis TYu J(2015)Bottom-up Faceted SearchProceedings of the 24th ACM International on Conference on Information and Knowledge Management10.1145/2806416.2806593(1771-1774)Online publication date: 17-Oct-2015
https://dl.acm.org/doi/10.1145/2806416.2806593
Macedo HOliveira J(2015)A linear algebra approach to OLAPFormal Aspects of Computing10.1007/s00165-014-0316-927:2(283-307)Online publication date: 1-Mar-2015
https://dl.acm.org/doi/10.1007/s00165-014-0316-9
Hoang DTjoa APriebe T(2012)Query-by-example approach towards on-demand multidimensional analysisInternational Journal of Business Intelligence and Data Mining10.1504/IJBIDM.2012.0495517:3(137-151)Online publication date: 1-Oct-2012
https://dl.acm.org/doi/10.1504/IJBIDM.2012.049551
Wu LSumbaly RRiccomini CKoo GKim HKreps JShah S(2012)AvataraProceedings of the VLDB Endowment10.14778/2367502.23675255:12(1874-1877)Online publication date: 1-Aug-2012
https://dl.acm.org/doi/10.14778/2367502.2367525
Giordanelli RMastroianni CMeo M(2012)Bio-Inspired P2P SystemsACM Transactions on Autonomous and Adaptive Systems10.1145/2382570.23825717:4(1-28)Online publication date: 1-Dec-2012
https://dl.acm.org/doi/10.1145/2382570.2382571
Hoang DPriebe TTjoa A(2011)Hypergraph-based multidimensional data modeling towards on-demand business analysisProceedings of the 13th International Conference on Information Integration and Web-based Applications and Services10.1145/2095536.2095545(36-43)Online publication date: 5-Dec-2011
https://dl.acm.org/doi/10.1145/2095536.2095545
Islam RHasan KTsuji TQuyet TTran D(2011)EaCRSProceedings of the 2nd Symposium on Information and Communication Technology10.1145/2069216.2069237(92-99)Online publication date: 13-Oct-2011
https://dl.acm.org/doi/10.1145/2069216.2069237
Soroush EBalazinska MWang DSellis TMiller RKementsietsidis AVelegrakis Y(2011)ArrayStoreProceedings of the 2011 ACM SIGMOD International Conference on Management of data10.1145/1989323.1989351(253-264)Online publication date: 12-Jun-2011
https://dl.acm.org/doi/10.1145/1989323.1989351
Soroush EBalazinska M(2011)Hybrid merge/overlap execution technique for parallel array processingProceedings of the EDBT/ICDT 2011 Workshop on Array Databases10.1145/1966895.1966898(20-30)Online publication date: 25-Mar-2011
https://dl.acm.org/doi/10.1145/1966895.1966898
Show More Cited By

Abstract

References

Cited By

Index Terms

Recommendations

Multidimensional database design via schema transformation: turning TPC H into the TPC H*d multidimensional benchmark

Multidimensional models meet the semantic web: defining and reasoning on OWL-DL ontologies for OLAP

Multidimensional data model and query language for informetrics

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Share

Share this Publication link

Share on social media

Affiliations