Conference proceeding
Dimensional modeling: identifying, classifying & applying patterns
Proceedings of the 8th ACM international workshop on data warehousing and olap
04 Nov 2005
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.
Metrics
4 Record Views
15 citations in Scopus
Details
- Title
- Dimensional modeling
- Creators
- Mary JonesIl-Yeol Song
- Publication Details
- Proceedings of the 8th ACM international workshop on data warehousing and olap
- Conference
- 8th ACM international workshop on data warehousing and olap, 8th
- Series
- DOLAP '05
- Publisher
- Association for Computing Machinery (ACM)
- Resource Type
- Conference proceeding
- Language
- English
- Academic Unit
- Information Science
- Scopus ID
- 2-s2.0-84958764430
- Other Identifier
- 991014877962304721