Dimensional modeling; Star schema modeling
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...
- 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.Codd EF. Providing OLAP (On-line Analytical Processing) to user-analysts: an IT mandate. E.F. Codd and Assoc., 1993.Google Scholar
- 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
- 6.Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. New York: Wiley; 2002.Google Scholar
- 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.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.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.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.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.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
- 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.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.The BI Verdict http://barc-research.com/bi-verdict/. Current as of August 21, 2014.
- 17.Thomsen E. OLAP solutions: building multidimensional information systems. New York: Wiley; 1997.Google Scholar
- 18.Vaisman A, Zimányi E. Data warehouse systems – design and implementation. Berlin: Springer; 2014.Google Scholar
- 20.Wikipedia, data vault modeling. Available at http://en.wikipedia.org/wiki/Data_Vault_Modeling. Accessed on 14 Aug 2014.