.png){kind=icon}
.png){kind=icon}
Return
Dimensional modelin: Identification, classification, and evaluation of patterns
.png){kind=icon}
PRE
AI
DOI：10.1016/j.dss.2006.12.004.png)
.png){kind=icon}
Original request for help.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
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 application 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 experimental results show that the classroom use of DDPs increase the effectiveness by 25% and efficiency by 9% for students in designing dimensional models. This research shows that DDPs could be an effective tool not only for teaching a dimensional model in academia, but also for designing dimensional models in an industry setting. (C) 2006 Elsevier B.V. All rights reserved.
Keywords:
data warehouse
dimensional modeling
data models
design
patterns
software engineering
Journal
IF:
6.8
Papers:
3.8K
Citations:
1.5W
