Supporting dimension updates in an OLAP server

Authors:
Alejandro A. Vaisman;Alberto O. Mendelzon;Walter Ruaro;Sergio G. Cymerman
Affiliations:
Universidad de Buenos Aires, Beauchef 305 5to piso, Buenos Aires, Argentina;University of Toronto, Canada;Universidad de Buenos Aires, Beauchef 305 5to piso, Buenos Aires, Argentina;Universidad de Buenos Aires, Beauchef 305 5to piso, Buenos Aires, Argentina
Venue:
Information Systems - Special issue: The 14th international conference on advanced information systems engineering (CAiSE*02)
Year:
2004

Citing 9
Cited 4

Implementing data cubes efficiently

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Maintenance of data cubes and summary tables in a warehouse

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Materialized views: techniques, implementations, and applications

Materialized views: techniques, implementations, and applications
Updating OLAP dimensions

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
A Logical Approach to Multidimensional Databases

EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Modeling Multidimensional Databases

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
A Foundation for Multi-dimensional Databases

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
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
Maintaining Data Cubes under Dimension Updates

ICDE '99 Proceedings of the 15th International Conference on Data Engineering

Efficient Incremental Computation of CUBE in Multiple Versions What-If Analysis

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
Incremental Computation for MEDIAN Cubes in What-If Analysis

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
Season queries on a temporal multidimensional model for OLAP

Mathematical and Computer Modelling: An International Journal
ORE: an iterative approach to the design and evolution of multi-dimensional schemas

Proceedings of the fifteenth international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

Commercial on line analytical processing (OLAP) systems usually treat OLAP dimensions as static entities. In practice, dimension updates are often needed to adapt the warehouse to changing requirements. In earlier work, we defined a taxonomy for these dimension updates and a minimal set of operators to perform them. In this paper we present TSOLAP, an OLAP server supporting fully dynamic dimensions. TSOLAP conforms to the OLE DB for OLAP norm, so it can be used by any client application based on this norm, and can use as back-end any conformant relational server. We incorporate dimension update support to MDX, Microsoft's language for OLAP, and introduce TSShow, a visualization tool for dimensions and data cubes. Finally, we present the results of a real-life case study in the application of TSOLAP to a medium-sized medical center.