Logo image
Back
Dimensional modeling: Identification, classification, and evaluation of patterns
Journal article   Peer reviewed

Dimensional modeling: Identification, classification, and evaluation of patterns

Mary Elizabeth “M.E.” Jones and Il-Yeol Song
Decision Support Systems, v 45(1), pp 59-76
2008
DOI: https://doi.org/10.1016/j.dss.2006.12.004

Abstract

Design Data models Patterns Data warehouse Dimensional modeling Software engineering
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.

Metrics

18 Record Views
7 citations in Web of Science
15 citations in Scopus

Details

InCites Highlights

Data related to this publication, from InCites Benchmarking & Analytics tool:

Collaboration types
Domestic collaboration
Web of Science research areas
Computer Science, Artificial Intelligence
Computer Science, Information Systems
Operations Research & Management Science
Logo image