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.

  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: A dimension in a data warehouse (DW) is a set of elements connected by a hierarchical relationship. The elements are used to view summaries of data at different levels of abstraction. In order to support an efficient processing of such summaries, a dimension is usually required to satisfy different classes of integrity constraints. In scenarios where the constraints properly capture the semantics of the DW data, but they are not satisfied by the dimension, the problem of repairing (correcting) the dimension arises. In this paper, we study the problem of repairing a dimension in the context of two main classes of integrity constraints: strictness and covering constraints. We introduce the notion of minimal repair of a dimension: a new dimension that is consistent with respect to the set of integrity constraints, which is obtained by applying a minimal number of updates to the original dimension. We study the complexity of obtaining minimal repairs, and show how they can be characterized using Datalog programs with weak constraints under the stable model semantics.
    Proceedings of the 4th Alberto Mendelzon International Workshop on Foundations of Data Management, Buenos Aires, Argentina, May 17-20, 2010; 01/2010
  • [Show abstract] [Hide abstract]
    ABSTRACT: Spatial OLAP (SOLAP) integrates spatial data into OLAP and Data warehouse systems to exploit the analysis capabilities associated with geographic information. SOLAP extends OLAP operators to navigate into spatial dimensions and to slice the spatial data cube using spatial predicates. The integration of several heterogeneous spatial data cubes is particularly useful for decision-makers since it enables them to navigate into multiple data sources. In order to exploit the continuous dimension of spatial data, we propose a new operator for merging spatial data cubes without conformed spatial dimensions. Our operator is based on the spatial analysis transformation called “Overlay”. We show its implementation in the Web-based SOLAP System GeWOlap.
    Journal of Decision Systems. 01/2010; 19:261-290.
  • [Show abstract] [Hide abstract]
    ABSTRACT: The focus of this chapter is metadata necessary to support data warehouse evolution. We present the data warehouse framework that is able to track evolution process and adapt data warehouse schemata and data extraction, transformation, and loading (ETL) processes. We discuss the significant part of the framework, the metadata repository that stores information about the data warehouse, logical and physical schemata and their versions. We propose the physical implementation of multiversion data warehouse in a relational DBMS. For each modification of a data warehouse schema, we outline the changes that need to be made to the repository metadata and in the database. KeywordsData warehouse–Schema evolution–Changes–Metadata–Repository
    09/2009: pages 627-635;

Full-text (2 Sources)

Available from
May 20, 2014