Dimensional modeling: identifying, classifying & applying patterns

Software design is a complex activity. A successful designer requires knowledge and training in specific design techniques combined with practical experience. Designing a dimensional model embodies this challenge. This paper presents Dimensional Design Patterns (DDPs) and their applications to the design of dimensional models. We describe a metamodel of the DDPs and show their integration into Kimball's dimensional modeling design process so they can be applied to design problems using a known practice. By providing a metamodel and a method for DDP use, we combine theory and a practical design technique with the goal of increasing the efficiency and effectiveness of the software designer. The initial experimental results regarding the classroom use of DDPs revealed a significant increase in the efficiency of students to design a dimensional model, but more testing is necessary in order to evaluate the effectiveness measure.

[1]  Chris Adamson,et al.  Data Warehouse Design Solutions , 1998 .

[2]  Len Silverston,et al.  The Data Model Resource Book , 1997 .

[3]  Christopher Alexander,et al.  The Timeless Way of Building , 1979 .

[4]  Max Jacobson,et al.  A Pattern Language: Towns, Buildings, Construction , 1981 .

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

[6]  John Vlissides,et al.  Pattern hatching: design patterns applied , 1998 .

[7]  Fred P. Brooks,et al.  The Mythical Man-Month , 1975, Reliable Software.

[8]  B. F. Castro.  Buschmann, Frank; Meunier, Regine; Rohnert, Hans; Sommerlad, Peter; Stal, Michael. Pattern-oriented software architecture: a system of patterns, John Wiley & Sons Ltd, 1996 , 1997 .

[9]  Jr. Frederick P. Brooks,et al.  The Mythical Man-Month: Essays on Softw , 1978 .

[10]  Mark Mayfield,et al.  Object Models: Strategies, Patterns, and Applications , 1995 .

[11]  Paul Evitts,et al.  A UML Pattern Language , 2000 .

[12]  Herbert A. Simon,et al.  The Sciences of the Artificial , 1970 .

[13]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[14]  Robert J. Muller,et al.  Database Design for Smarties: Using UML for Data Modeling , 1999 .

[15]  Peter Sommerlad,et al.  Pattern-Oriented Software Architecture: A System of Patterns: John Wiley & Sons , 1987 .

[16]  H. Simon,et al.  The sciences of the artificial (3rd ed.) , 1996 .

[17]  David C. Hay,et al.  Data Model Patterns: Conventions of Thought , 1965 .

[18]  Ellen Agerbo,et al.  How to preserve the benefits of design patterns , 1998, OOPSLA '98.

[19]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[20]  Martin Fowler,et al.  Analysis patterns - reusable object models , 1996, Addison-Wesley series in object-oriented software engineering.