Open AccessProceedings Article10.5220/0004877304720479

Toward evolution models for data warehouses

- 07 Jan 2014

- pp 472-479

TL;DR: A model-driven approach for the evolution of a multidimensional DW is presented, based on two evolution models: a first evolution model for the DS and another for the DW, which concern the data structure aspects as well as the evolution operations.

Abstract: A Data warehouse (DW) is characterized by a complex architecture, designed in order to integrate data derived from operational data sources (DS), hence providing advanced analytical tools of these data. The DW is highly dependent on its DS. Hence, evolutions of the DS schema need to be propagated to the DW schema and content. This paper presents a model-driven approach for the evolution of a multidimensional DW. It is based on two evolution models: a first evolution model for the DS and another for the DW. These two models concern the data structure aspects as well as the evolution operations. The transition between these two models is performed through specific transformation rules defined in QVT (Query\View\Transformation).

AI Agents for this Paper

Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps

Most frequently asked questions

1. What are the contributions in "Toward evolution models for data warehouses" ?

This paper presents a model-driven approach for the evolution of a multidimensional DW.

2. What future works have the authors mentioned in the paper "Toward evolution models for data warehouses" ?

In order to experimentally validate the proposed models and all transformations, the authors are looking to apply them on a real case study.. In the future research, the authors have the intention to extend the DW alteration process to take into account expected evolutions of the ETL ( Extract Transform and Load procedures.

Figure 2: The structure of the evolution models.

Figure 3: Data Source Evolution Meta-model.

Figure 4: Data Warehouse Evolution Meta-Model.

Figure 5: Description of the transformation semTOwem.

Table 1: Comparison of DW evolution approaches.

Figure 6: Description of the relation ColToMeas.

Citations

•Proceedings Article•10.5220/0006209001690181

The power of a model-driven approach to handle evolving Data Warehouse requirements

Saïd Taktak, +3 more

- 19 Feb 2017

TL;DR: This paper proposes a model-driven approach for extending DWE in order to consider a further related evolutionary aspect: The evolution of decision-makers’ needs and deals with the propagation of these evolutions on the DW multidimensional model.

...read moreread less

Journal Article•10.4018/IJDSST.2015070104

An MDA Approach for the Evolution of Data Warehouses

Gilles Zurfluh, +3 more

- 01 Jul 2015

- International Journal of Decision Suppor...

TL;DR: A model-driven based approach is proposed in order to automate the propagation of the evolutions occurred in the source database towards the multidimensional data warehouse, based on two evolution models, along with a set of transformation rules formalized in Query/View/Transformation.

...read moreread less

Modélisation des transformations pour l'évolution de modèles multidimensionnels

Saïd Taktak, +2 more

- 01 Jan 2014

TL;DR: Un prototype logiciel nomme DWE (« Data Warehouse Evolution ») qui supporte cette demarche dirigee par les modeles pour automatiser the propagation of l'evolution du modele de la source de donnees relationnelle vers l'entrepot.

...read moreread less

Book Chapter•10.1007/978-3-319-94764-8_17

Model-Driven Approach to Handle Evolutions of OLAP Requirements and Data Source Model

Saïd Taktak, +3 more

- 19 Feb 2017

TL;DR: This paper presents an MDA-compliant (Model Driven Architecture) approach and a software tool for propagating automatically the evolutions of the data source model and OLAP requirements towards the multidimensional DW model.

...read moreread less

Advances in DataWarehouse: A Survey

Tonáhtiu Arturo Ramírez Romero, +10 more

- 01 Jan 2016

TL;DR: This work presents a brief introduction to data warehouse, followed by the most relevant topics in the last years, including DW quality, Near Real Time – ETL, and QuiDA Architecture.

...read moreread less

References

Journal Article•10.4018/JDWM.2009070101

A Survey of Extract–Transform–Load Technology

Panos Vassiliadis

- 01 Jul 2009

- International Journal of Data Warehousin...

TL;DR: This survey covers the conceptual and logical modeling of ETL processes, along with some design methods, and visits each stage of the E-T-L triplet, and examines problems that fall within each of these stages.

...read moreread less

352

An MDA approach for the development of data warehouses.

Jose-Norberto Mazón, +1 more

- 01 Jan 2009

TL;DR: In this paper, a Model Driven Architecture (MDA) framework is proposed to align the whole DW development process with a MDA framework for the development of the DW repository, which is the cornerstone of any DW system.

...read moreread less

174

Journal Article•10.1016/J.DSS.2005.12.001

A UML-based data warehouse design method

Nicolas Prat, +2 more

- 01 Dec 2006

TL;DR: This paper presents a UML-based data warehouse design method that spans the three design phases (conceptual, logical and physical), and represents all the metamodels using UML, and illustrates the formal specification of the transformations based on OMG's Object Constraint Language (OCL).

...read moreread less

156

A Survey of Extract-Transform-Load Technology.

Panos Vassiliadis

- 01 Jan 2011

...read moreread less

110

Book Chapter•10.1007/978-3-642-12082-4_8

Rule-Based management of schema changes at ETL sources

George Papastefanatos, +4 more

- 07 Sep 2009

TL;DR: This paper presents the system architecture of a tool called Hecataeus that implements the main concepts of the proposed framework, which detects the parts of the graph that are affected by this change and highlights the way they are tuned to respond to it.

...read moreread less

Toward evolution models for data warehouses

Chat with Paper

AI Agents for this Paper

Most frequently asked questions

1. What are the contributions in "Toward evolution models for data warehouses" ?

2. What future works have the authors mentioned in the paper "Toward evolution models for data warehouses" ?

Figures

Citations

The power of a model-driven approach to handle evolving Data Warehouse requirements

An MDA Approach for the Evolution of Data Warehouses

Modélisation des transformations pour l'évolution de modèles multidimensionnels

Model-Driven Approach to Handle Evolutions of OLAP Requirements and Data Source Model

Advances in DataWarehouse: A Survey

References

A Survey of Extract–Transform–Load Technology

An MDA approach for the development of data warehouses.

A UML-based data warehouse design method

A Survey of Extract-Transform-Load Technology.

Rule-Based management of schema changes at ETL sources

Related Papers (5)

Enabling OLAP analyses on the web of data

Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model

The dimensional fact model: a conceptual model for data warehouses

System modeling with mixed object and data models

A Unified Framework for Enterprise Architecture Analysis