Critical success factors in implementing MRP and government assistance: a Singapore context
Information and Management
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Constructing OLAP cubes based on queries
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
On relationships offering new drill-across possibilities
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Database Architecture for Data Warehousing: An Evolutionary Approach
DEXA '98 Proceedings of the 9th International Conference on Database and Expert Systems Applications
On the Integration of Autonomous Data Marts
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
A comparison of data warehousing methodologies
Communications of the ACM - The disappearing computer
Building the Data Warehouse
YAM2: a multidimensional conceptual model extending UML
Information Systems
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Metrics for data warehouse conceptual models understandability
Information and Software Technology
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
An approach to engineering the requirements of data warehouses
Requirements Engineering
GRAnD: A goal-oriented approach to requirement analysis in data warehouses
Decision Support Systems
An MDA approach for the development of data warehouses
Decision Support Systems
Dimensional modeling: Identification, classification, and evaluation of patterns
Decision Support Systems
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
ER'07 Proceedings of the 26th international conference on Conceptual modeling
A model-driven goal-oriented requirement engineering approach for data warehouses
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
Applying transformations to model driven data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Model driven engineering: an emerging technical space
GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering
| Hi-index | 0.00 |
To customize a data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, the integrated development of these data marts is an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. In this article, the authors present a design approach that employs user requirements to build both corporate data warehouses and data marts in an integrated manner. The approach links information requirements to specific data marts elicited by using goal-oriented requirement engineering, which are automatically translated into the implementation of corresponding data repositories by means of model-driven engineering techniques. The authors provide two UML profiles that integrate the design of both data warehouses and data marts and a set of QVT transformations with which to automate this process. The advantage of this approach is that user requirements are captured from the early development stages of a data-warehousing project to automatically translate them into the entire data-warehousing platform, considering the different data marts. Finally, the authors provide screenshots of the CASE tools that support the approach, and a case study to show its benefits.