MDA compliant approach for data mart schemas generation

Authors:
Hassene Choura;Jamel Feki
Affiliations:
Miracl Laboratory, University of Sfax, Sfax, Tunisia;Miracl Laboratory, University of Sfax, Sfax, Tunisia
Venue:
MEDI'11 Proceedings of the First international conference on Model and data engineering
Year:
2011

Citing 5
Cited 1

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
Designing data marts for data warehouses

ACM Transactions on Software Engineering and Methodology (TOSEM)
A Logical Approach to Multidimensional Databases

EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Conceptual Design of Data Warehouses from E/R Schema

HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
A UML-based data warehouse design method

Decision Support Systems

A case study on model-driven data warehouse development

DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

Abstract

Decision Support System (DSS) designers face two data models complexities: OLTP (On Line Transaction Processing) database model and multidimensional model. These models relying on different concepts force the designer to have double skills. The objective of this paper is to assist the DSS designer producing rapidly Data Mart (DM) schemas starting from the Data Warehouse (DW) data model. More accurately, we aim to automate the generation of DM schemas from a relational DW schema according to the MDA (Model Driven Architecture) paradigm. To do so, we propose an approach based on a set of transformation rules that we define in ATL language and illustrate with an example.