Dimensional modeling

Mary Elizabeth Jones, Il-Yeol Song
2005 Proceedings of the 8th ACM international workshop on Data warehousing and OLAP - DOLAP  
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
more » ... ractice. 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.
doi:10.1145/1097002.1097008 dblp:conf/dolap/JonesS05 fatcat:gkpy27kjkrgvjmqgjkt3y3lvoa