Changes of Dimension Data in Temporal Data Warehouses
Time is one of the dimensions we frequently find in data warehouses allowing comparisons of data in different periods. In current multi-dimensional data warehouse technology changes of dimension data cannot be represented adequately since all dimensions are (implicitly) considered as orthogonal. We propose an extension of the multi-dimensional data model employed in data warehouses allowing to cope correctly with changes in dimension data: a temporal multi-dimensional data model allows the registration of temporal versions of dimension data. Mappings are provided to transfer data between different temporal versions of the instances of dimensions and enable the system to correctly answer queries spanning multiple periods and thus different versions of dimension data.
KeywordsDimension Data Transformation Function Transformation Matrice Structure Version Hierarchical Relation
Unable to display preview. Download preview PDF.
- M. Blaschka. FIESTA: A Framework for Schema Evolution in Multidimensional Information Systems. In Proc. of 6th Doctoral Consortium, Germany, 1999.Google Scholar
- M. Blaschka, C. Sapia, and G. Höfling. On Schema Evolution in Multidimensional Databases. In Proc. of the DaWak99 Conference, Florence, Italy, 1999.Google Scholar
- M. Böhlen. Temporal Database System Implementations. SIGMOD, 24(4), 1995.Google Scholar
- P. Chamoni and S. Stock. Temporal Structures in Data Warehousing. In Data Warehousing and Knowledge Discovery (DaWaK) 1999, p. 353–358, Italy, 1999.Google Scholar
- S.M. Clamen. Schema Evolution and Integration. In Distributed and Parallel Databases: An International Journal, p. 2(1):101–126.Google Scholar
- O. Etzion, S. Jajodia, and S. Sripada, editors. Temporal Databases: Research and Practise. LNCS 1399. Springer-Verlag, 1998.Google Scholar
- Goralwalla, Tansel, and Zsu. Experimenting with Temporal Relational Databases. ACM, CIKM95, 1995.Google Scholar
- Gregersen and Jensen. Temporal Entity-Relationship Models-a Survey. Time-Center, 1997.Google Scholar
- C.S. Jensen and C.E. Dyreson, editors. A consensus Glossary of Temporal Database Concepts-Feb. 1998 Version. Springer-Verlag, 1998. In .Google Scholar
- C. Li and X. Wang. A Data Model for Supporting On-Line Analytical Processing. ACM, CIKM 96, 1996.Google Scholar
- C. Liu, S. Chang, and P. Chrysanthis. Database Schema Evolution using EVER Diagrams. In Proc. of the Workshop on Advanced Visual Interfaces, 1994.Google Scholar
- A. Mendelzon and A. Vaisman. Temporal Queries in OLAP. In Proc. of the 26th VLDB Conference, Egypt, 2000.Google Scholar
- SAP America, Inc. and SAPAG. Data Modelling with BW-ASAP for BW Accelerator. 1998. White Paper: URL: http://www.sap.com.
- P. Vassiliadis and T. Sellis. A Survey of Logical Models for OLAP Databases. In SIGMOD Record 28, 1999.Google Scholar