Dimensional Modeling: Identifying, Classifying & Applying Patterns

Abstract

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.