Abstract
Commercial 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 backend 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.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
L. Cabibbo and R. Torlone. A logical approach to multidimensional databases. In EDBT’98: 6th International Conference on Extending Database Technology, pages 253–269, Valencia, Spain, 1998.
A. Golfarelli, D. Maio, and S. Rizzi. Conceptual design of data warehouses from E/R schemes. In Proceedings of the Hawaii International Conference on System Sciences, Kona, Hawai, 1998.
A. Gupta and I. H. Mumick. Materialized Views: Techniques, Implementations and Applications. MIT Press, 1999.
M. Gyssens and L. Lakshmanan. A foundation for multi-dimensional databases. In Proceedings of the 22nd VLDB Conference, pages 106–115, Bombay, India, 1996.
V. Harinarayan, A. Rajaraman, and J. Ullman. Implementing data cubes efficiently. In Proceedings of the ACM-SIGMOD Conference, pages 205–216, Montreal, Canada, 1996.
C. Hurtado, A. O. Mendelzon, and A. Vaisman. Maintaining data cubes under dimension updates. Proceedings of IEEE/ICDE’99, 1999.
C. Hurtado, A. O. Mendelzon, and A. Vaisman. Updating OLAP dimensions. Proceedings of ACM DOLAP’99, 1999.
R. Kimball. The Data Warehouse Toolkit. J.Wiley and Sons, Inc, 1996.
Microsoft Corporation. Data Warehouse Alliance (DWA2000) (Internet Document http://www.microsoft.com/BUSINESS/bi/dwa/dwa.asp ), 2000.
Microsoft Corporation. OLEDB for OLAP Specification (Internet Document (http://www.microsoft.com/data/oledb/olap), 2000.
I. Mumick, D. Quass, and B. Mumick. Maintenance of data cubes and summary tables in a warehouse. In Proceedings of the ACM-SIGMOD Conference, Tucson, Arizona, 1997.
Sun Microsystems. JOLAP: Java OLAP Interface (Internet Document http://jcp.org/jsr/detail/069.jsp), 2001.
A. Vaisman. Updates, view maintenance and time management in multidimensional databases. Phd Thesis, http://www.cs.toronto.edu/avaisman/publications , 2001.
A. Vaisman, A. O. Mendelzon, W. Ruaro, and S. Cymerman. Supporting dimension updates in a ROLAP server(full paper). In Internet Document http://www.cs.toronto.edu/avaisman/publications , 2002.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vaisman, A.A., Mendelzon, A.O., Ruaro, W., Cymerman, S.G. (2002). Supporting Dimension Updates in an OLAP Server. In: Pidduck, A.B., Ozsu, M.T., Mylopoulos, J., Woo, C.C. (eds) Advanced Information Systems Engineering. CAiSE 2002. Lecture Notes in Computer Science, vol 2348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-47961-9_8
Download citation
DOI: https://doi.org/10.1007/3-540-47961-9_8
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-43738-3
Online ISBN: 978-3-540-47961-1
eBook Packages: Springer Book Archive