Files and links (1)
PDFOpen Access (License Unspecified), Open Access
Dissertation
Dimensional modeling: identifying patterns, classifying patterns, and evaluating pattern impact on the design process
Doctor of Philosophy (Ph.D.), Drexel University
2006
DOI:
https://doi.org/10.17918/00008483
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 for a data warehouse embodies this challenge. This research 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 regarding the classroom use of DDPs revealed an increase in the correctness by 25% and the efficiency by 9% of students when designing a dimensional model. The DDPs are an effective method for the teaching and designing of a dimensional model. The next phase of research will apply the DDPs to dimensional models in an industry setting.
Metrics
12 File views/ downloads
7 Record Views
Details
- Title
- Dimensional modeling
- Creators
- Mary Elizabeth Jones
- Contributors
- Il-Yeol Song (Advisor) - Drexel University, Drexel University (1970-)
- Awarding Institution
- Drexel University
- Degree Awarded
- Doctor of Philosophy (Ph.D.)
- Publisher
- Drexel University; Philadelphia, Pennsylvania
- Number of pages
- xii, 152 pages
- Resource Type
- Dissertation
- Language
- English
- Academic Unit
- College of Information Science and Technology (1995-2013); Drexel University
- Other Identifier
- 991021888786204721