Conference Paper

Handling Evolutions in Multidimensional Structures.

DOI: 10.1109/ICDE.2003.1260823 Conference: IEEE 19th International Conference on Data Engineering (ICDE), At Bangalore, India
Source: DBLP

ABSTRACT Building multidimensional systems requires gathering data from heterogeneous sources throughout time. Then, data is integrated in multidimensional structures organized around several axes of analysis, or dimensions. But these analysis structures are likely to vary over time and the existing multidimensional models do not (or only partially) take these evolutions into account. Hence, a dilemma appears for the designer of data warehouses: either keeping trace of evolutions therefore limiting the capability of comparison for analysts, or mapping all data in a given version of the structure that entails alteration (or even loss) of data. We propose a novel approach that offers another alternative, allowing to track history but also to compare data, mapped into static structures. We define a conceptual model and provide possible logical adaptations to implement it on current commercial OLAP systems. At last, we present the global architecture that we used for our prototype.

Download full-text


Available from: Yvan Bédard, Jul 01, 2015
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: Current data warehouses include a time dimension that allows one to keep track of the evolution of measures under analysis. Nevertheless, this dimension cannot be used for indicating changes to dimension data. Based on the research in temporal databases, in this chapter we present a conceptual model for designing temporal data warehouses. The model supports different temporality types, i.e., lifespan, valid time, transaction time coming form source systems, and loading time, generated in a data warehouse. This support is used for representing time-varying levels, dimensions, hierarchies, and measures.
    Encyclopedia of Data Warehousing and Mining, 2 edited by J. Wang, 01/2009; IGI Global.
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: Current data warehouse and OLAP models include a time dimension that, like other dimensions, is used for grouping purposes (using the roll-up operation) or in a predicate role (using the slice-and-dice operation). The time dimension also indicates the time frame for measures (for example, in order to know how many units of a product were sold in March 2007). However, the time dimension cannot be used to keep track of changes in other dimensions, for example, when a product changes its ingredients or its packaging. Consequently, the “nonvolatile" and “time-varying" features included in the definition of a data warehouse (Sect. 2.5) apply only to measures, and this situation leaves to applications the responsibility of representing changes in dimensions. Kimball et al. [147] proposed several solutions for this problem in the context of relational databases, the slowly changing dimensions. Nevertheless, these solutions are not satisfactory, since they either do not preserve the entire history of the data or are difficult to implement. Further, they do not take account of all research that has been done in the field of temporal databases.
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: In this paper a data warehouse framework that supports data warehouse evolution is presented. The framework is able to handle not only changes in data sources, but also direct changes in a data warehouse schema. In the framework the data warehouse versions are supported in the development environment as well as in reports in the user environment.
    Proceedings of the SYRCoDIS 2007 Colloquium on Databases and Information Systems, Moscow, Russia, May 31 - June 1, 2007; 01/2007