Welcome to the InfoSci Platform
Schema Evolution Models and Languages for Multidimensional Data Warehouses

Schema Evolution Models and Languages for Multidimensional Data Warehouses

Edgard Benítez-Guerrero, Ericka-Janet Rechy-Ramírez
Copyright: © 2009 |Pages: 10
ISBN13: 9781605662428|ISBN10: 1605662429|EISBN13: 9781605662435
DOI: 10.4018/978-1-60566-242-8.ch014
Cite Chapter Cite Chapter

MLA

Benítez-Guerrero, Edgard, and Ericka-Janet Rechy-Ramírez. "Schema Evolution Models and Languages for Multidimensional Data Warehouses." Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, edited by Viviana E. Ferraggine, et al., IGI Global, 2009, pp. 119-128. https://doi.org/10.4018/978-1-60566-242-8.ch014

APA

Benítez-Guerrero, E. & Rechy-Ramírez, E. (2009). Schema Evolution Models and Languages for Multidimensional Data Warehouses. In V. Ferraggine, J. Doorn, & L. Rivero (Eds.), Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends (pp. 119-128). IGI Global. https://doi.org/10.4018/978-1-60566-242-8.ch014

Chicago

Benítez-Guerrero, Edgard, and Ericka-Janet Rechy-Ramírez. "Schema Evolution Models and Languages for Multidimensional Data Warehouses." In Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, edited by Viviana E. Ferraggine, Jorge Horacio Doorn, and Laura C. Rivero, 119-128. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-242-8.ch014

Export Reference

Mendeley
Favorite

Abstract

A Data Warehouse (DW) is a collection of historical data, built by gathering and integrating data from several sources, which supports decisionmaking processes (Inmon, 1992). On-Line Analytical Processing (OLAP) applications provide users with a multidimensional view of the DW and the tools to manipulate it (Codd, 1993). In this view, a DW is seen as a set of dimensions and cubes (Torlone, 2003). A dimension represents a business perspective under which data analysis is performed and organized in a hierarchy of levels that correspond to different ways to group its elements (e.g., the Time dimension is organized as a hierarchy involving days at the lower level and months and years at higher levels). A cube represents factual data on which the analysis is focused and associates measures (e.g., in a store chain, a measure is the quantity of products sold) with coordinates defined over a set of dimension levels (e.g., product, store, and day of sale). Interrogation is then aimed at aggregating measures at various levels. DWs are often implemented using multidimensional or relational DBMSs. Multidimensional systems directly support the multidimensional data model, while a relational implementation typically employs star schemas(or variations thereof), where a fact table containing the measures references a set of dimension tables.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.