Design patterns: elements of reusable object-oriented software
Design patterns: elements of reusable object-oriented software
The mythical man-month (anniversary ed.)
The mythical man-month (anniversary ed.)
Object models: strategies, patterns, applications
Object models: strategies, patterns, applications
The sciences of the artificial (3rd ed.)
The sciences of the artificial (3rd ed.)
Pattern-oriented software architecture: a system of patterns
Pattern-oriented software architecture: a system of patterns
Analysis patterns: reusable objects models
Analysis patterns: reusable objects models
Pattern hatching: design patterns applied
Pattern hatching: design patterns applied
Data warehouse design solutions
Data warehouse design solutions
How to preserve the benefits of design patterns
Proceedings of the 13th ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications
Database design for smarties: using UML for data modeling
Database design for smarties: using UML for data modeling
Oracle8i data warehousing
Data Model Patterns: Conventions of Thought
Data Model Patterns: Conventions of Thought
A UML Pattern Language
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Journal of Database Management
Hi-index | 0.00 |
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.