A model driven modernization approach for automatically deriving multidimensional models in data warehouses

Authors:
Jose-Norberto Mazón;Juan Trujillo
Affiliations:
Dept. of Software and Computing Systems, University of Alicante, Spain;Dept. of Software and Computing Systems, University of Alicante, Spain
Venue:
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Year:
2007

Citing 15
Cited 10

Relational database reverse engineering: algorithms to extract cardinality constraints

Data & Knowledge Engineering
Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Building the Data Warehouse,3rd Edition

Building the Data Warehouse,3rd Edition
Modernizing Legacy Systems: Software Technologies, Engineering Process and Business Practices

Modernizing Legacy Systems: Software Technologies, Engineering Process and Business Practices
Extracting the extended entity-relationship model from a legacy relational database

Information Systems
Goal-oriented requirement analysis for data warehouse design

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Applying MDA to the development of data warehouses

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Research in data warehouse modeling and design: dead or alive?

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
A UML profile for multidimensional modeling in data warehouses

Data & Knowledge Engineering - Special issue: ER 2003
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms

Data & Knowledge Engineering
An MDA approach for the development of data warehouses

Decision Support Systems
The Data Warehouse Lifecycle Toolkit

The Data Warehouse Lifecycle Toolkit
Applying transformations to model driven data warehouses

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Conceptual schema-centric development: a grand challenge for information systems research

CAiSE'05 Proceedings of the 17th international conference on Advanced Information Systems Engineering
A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms

ER'06 Proceedings of the 25th international conference on Conceptual Modeling

Editorial: Model-Driven Development for secure information systems

Information and Software Technology
Building data warehouses with semantic data

Proceedings of the 2010 EDBT/ICDT Workshops
A hybrid model driven development framework for the multidimensional modeling of data warehouses!

ACM SIGMOD Record
A model-driven heuristic approach for detecting multidimensional facts in relational data sources

DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Model-driven development of multidimensional models from web log files

ER'10 Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges
A trace metamodel proposal based on the model driven architecture framework for the traceability of user requirements in data warehouses

CAiSE'11 Proceedings of the 23rd international conference on Advanced information systems engineering
Extending the dimensional templates approach to integrate complex multidimensional design concepts

DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
A modularization proposal for goal-oriented analysis of data warehouses using i-star

ER'11 Proceedings of the 30th international conference on Conceptual modeling
Incorporating traceability in conceptual models for data warehouses by using MDA

ER'11 Proceedings of the 30th international conference on Conceptual modeling
An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

Journal of Database Management

Quantified Score

Hi-index	0.00

Visualization

Abstract

Data warehouses integrate several operational sources to provide a multidimensional (MD) analysis of data. Therefore, the development of a data warehouse claims for an in-depth analysis of these data sources. Several approaches have been presented to obtain multidimensional structures from data sources in order to guide this development. However, these approaches assume that a wide documentation of the data sources is available and only provide informal guidelines to support the discovery of MD elements. Therefore, this task may become highly difficult for complex and large data sources (e.g. legacy systems). To overcome these problems, we consider the development of the data warehouse as a modernization scenario that addresses the analysis of the available data sources, thus discovering MD structures to either derive a data-driven conceptual MD model or reconcile a requirement-driven conceptual MD model with data sources. Specifically, we use concepts from Architecture Driven Modernization (ADM) in order to automatically perform the following tasks: (i) obtain a logical representation of data sources (ii) mark this logical representation with MD concepts, and (iii) derive a conceptual MD model from the marked model. Finally, we have provided a case study based on a real world project in order to exemplify the application of our approach.