Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Multidimensional Modeling

  • Torben Bach Pedersen
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_229

Synonyms

Dimensional modeling; Star schema modeling

Definition

Multidimensional modeling is the process of modeling the data in a universe of discourse using the modeling constructs provided by the multidimensional data model. Briefly, the multidimensional data model categorizes data as being either facts with associated numerical measures or as being dimensions that characterize the facts and are mostly textual. For example, in a retail business, products are sold to customers at certain times in certain amounts and at certain prices. A typical fact would be a purchase. Typical measures would be the amount and price of the purchase. Typical dimensions would be the location of the purchase, the type of product being purchased, and the time of the purchase. Queries then aggregate measure values over ranges of dimension values to produce results such as the total sales per month and product type.

More precisely, a number of different formal multidimensional data models have been proposed...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Chan P, Shoshani A. SUBJECT: a directory driven system for organizing and accessing large statistical databases. In: Proceedings of the 9th International Conference on Very Data Bases; 1983. p. 553–63.Google Scholar
  2. 2.
    Codd EF. Providing OLAP (On-line Analytical Processing) to user-analysts: an IT mandate. E.F. Codd and Assoc., 1993.Google Scholar
  3. 3.
    Dyreson CE, Pedersen TB, Jensen CS. Incomplete information in multidimensional databases. In: Rafanelli M, editor. Multidimensional databases: problems and solutions. Hershey: Idea Group Publishing; 2003.Google Scholar
  4. 4.
    Gray J, Chaudhuri S, Bosworth A, Layman A, Venkatrao M, Reichart D, Pellow F, Pirahesh H. Data cube: a relational aggregation operator generalizing group-by, cross-tab and sub-totals. Data Min Knowl Disc. 1997;1(1):29–54.CrossRefGoogle Scholar
  5. 5.
    Jensen CS, Pedersen TB, Thomsen C. Multidimensional databases and data warehousing. Synthesis lectures on data management. San Rafael: Morgan Claypool; 2010.zbMATHGoogle Scholar
  6. 6.
    Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. New York: Wiley; 2002.Google Scholar
  7. 7.
    Kimball R, Ross M, Thornthwaite W, Mundy J, Becker B. The data warehouse lifecycle toolkit. 2nd ed. New York: Wiley; 2008.Google Scholar
  8. 8.
    Lenz H, Shoshani A. Summarizability in OLAP and statistical data bases. In: Proceedings of the 9th International Conference on Scientific and Statistical Database Management; 1997. p. 39–48.Google Scholar
  9. 9.
    Niemi T, Nummenmaa J, Thanisch P. Logical multidimensional database design for ragged and unbalanced aggregation. In: Proceedings of the 3rd International Workshop on Design and Management of Data Warehouses; 2001. Paper 7.Google Scholar
  10. 10.
    Pedersen TB. Warehousing the world: a vision for data warehouse research. New trends in data warehousing and data analysis: 1–17, Springer Annals of Information Systems, 2009.Google Scholar
  11. 11.
    Pedersen T B. Managing complex multidimensional data. In: Aufaure M-A., Zimányi E, editors. Business intelligence – second European Summer School, eBISS 2012, Brussels, Belgium, July 15–21, 2012, Tutorial Lectures. Springer LNBIB, 2013.Google Scholar
  12. 12.
    Pedersen TB, Jensen CS, Dyreson CE. Extending practical pre-aggregation in on-line analytical processing. In: Proceedings of the 25th International Conference on Very Large Data Bases; 1999. p. 663–74.Google Scholar
  13. 13.
    Pedersen TB, Jensen CS, Dyreson CE. A foundation for capturing and querying complex multidimensional data. Inf Syst. 2001;26(5):383–423.zbMATHCrossRefGoogle Scholar
  14. 14.
    Rizzi S, Abello A, Lechtenbörger J, and Trujillo J. Research in data warehouse modeling and design: dead or alive? In: Proceedings of the ACM 9th International Workshop on Data Warehousing and OLAP; 2006. p. 3–10.Google Scholar
  15. 15.
    Shoshani A. OLAP and statistical databases: similarities and differences. In: Proceedings of the 16th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems; 1997. p. 185–96.Google Scholar
  16. 16.
    The BI Verdict http://barc-research.com/bi-verdict/. Current as of August 21, 2014.
  17. 17.
    Thomsen E. OLAP solutions: building multidimensional information systems. New York: Wiley; 1997.Google Scholar
  18. 18.
    Vaisman A, Zimányi E. Data warehouse systems – design and implementation. Berlin: Springer; 2014.Google Scholar
  19. 19.
    Vassiliadis P, Sellis TK. A survey of logical models for OLAP databases. ACM SIGMOD Rec. 1999;28(4):64–9.CrossRefGoogle Scholar
  20. 20.
    Wikipedia, data vault modeling. Available at http://en.wikipedia.org/wiki/Data_Vault_Modeling. Accessed on 14 Aug 2014.

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark

Section editors and affiliations

  • Torben Bach Pedersen
    • 1
  • Stefano Rizzi
    • 2
  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.DISIUniv. of BolognaBolognaItaly