From ER Models to Dimensional Models: Bridging the Gap between OLTP and OLAP Design, Part I

Dimensional modeling is a database design technique developed specifically for designing data warehouses. Its objectives are to create database structures that end users can easily understand and write queries against, and to optimize query performance. It has become the predominant approach to designing data warehouses in practice and has proven to be a major breakthrough in developing databases that can be used directly by end users. Dimensional modeling is not based on any theory, but has clearly been very successful in practice. This article, the first in a two-part series, examines the nature of dimensional modeling and proposes a possible explanation for why it has been so successful.

[1]  Herbert A. Simon,et al.  The Sciences of the Artificial - 3rd Edition , 1981 .

[2]  G. A. Miller.  THE PSYCHOLOGICAL REVIEW THE MAGICAL NUMBER SEVEN, PLUS OR MINUS TWO: SOME LIMITS ON OUR CAPACITY FOR PROCESSING INFORMATION 1 , 1956 .

[3]  T. Kuhn,et al.  The Structure of Scientific Revolutions. , 1964 .

[4]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[5]  Robert Winter,et al.  Demand-driven Information Requirements Analysis in Data Warehousing , 2003 .

[6]  Katherine Glassey.  Seducing the end user , 1998, CACM.

[7]  Daniel L. Moody,et al.  Complexity effects on end user understanding of data models : An experimental comparison of large data model representation methods , 2002, ECIS.

[8]  Ewart R. Carson,et al.  Dealing with Complexity , 1988, Springer US.

[9]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[10]  L UHR,et al.  Pattern recognition over distortions, by human subjects and by a computer simulation of a model for human form perception. , 1962, Journal of experimental psychology.

[11]  A. Baddeley.  The magical number seven: still magic after all these years? , 1994, Psychological review.

[12]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[13]  Ewart R. Carson,et al.  Dealing with complexity: an introduction to the theory & applications of systemsscience , 1988 .

[14]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[15]  Allen Newell,et al.  Human Problem Solving. , 1973 .

[16]  Ron Weber,et al.  Are Attributes Entities? A Study of Database Designers' Memory Structures , 1996, Inf. Syst. Res..

[17]  A. Baddeley.  Essentials of Human Memory , 1999 .

[18]  Ronald Maier,et al.  Benefits and Quality of Data Modelling - Results of an Empirical Analysis , 1996, ER.

[19]  William Kent,et al.  ASlMPLE GUIDE TO FIVE NORMAL FORMS IN RELATIONAL DATABASE THEORY , 2000 .

[20]  George J. Klir,et al.  Architecture of Systems Problem Solving , 1985, Springer US.

[21]  Z. J. Lipowski,et al.  Sensory and information inputs overload: behavioral effects. , 1975, Comprehensive psychiatry.

[22]  Mahesh S. Raisinghani.  Adapting Data Modeling Techniques for Data Warehouse Design , 2000 .