Skip to main content
SpringerLink
Log in
Book cover

Progress in Advanced Computing and Intelligent Engineering pp 295–304Cite as

Maintaining Bi-temporal Schema Versions in Temporal Data Warehouses

  • Conference paper
  • First Online:

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 564))

Abstract

The temporal data warehouses (TDWs) have been proposed to correctly represent the revisions in dimension data. TDWs manage the evolution of schema and data with time through their versioning by time-stamping the data with valid time. Bi-temporal schema versioning in temporal data warehouses has also been discussed that not only allows retroactive and proactive schema revisions but also keeps track of them. The support for bi-temporal schema versioning raises an important issue for managing and storing the different versions of schema along with their data. The paper proposes an approach for managing bi-temporal schema versions in TDWs to allow for an effective management of several versions of schema along with their data.

This is a preview of subscription content, log in via an institution.

References

  1. Agrawal, R., Gupta, A., Sarawagi, S.: Modeling multidimensional databases. IBM Research Report, IBM Almaden Research Center (1995)

    Google Scholar 

  2. Bębel, B., Eder, J., Konicilia, C., Morzy, T., Wrembel, R.: Creation and management of versions in multiversion data warehouse. In: Proceedings of ACM Symposium on Applied Computing (SAC), pp. 717–723 (2004)

    Google Scholar 

  3. Bębel, B., Królikowski, Z., Wrembel, R.: Managing multiple real and simulation business scenarios by means of a multiversion data warehouse. In: Proceedings of International Conference on Business Information Systems (BIS). Lecture Notes in Informatics, pp. 102–113 (2006)

    Google Scholar 

  4. Bębel, B., Wrembel, R., Czejdo, B.: Storage structures for sharing data in multi-version data warehouse. In: Proceedings of Baltic Conference on Databases and Information Systems, pp. 218–231 (2004)

    Google Scholar 

  5. Benítez-Guerrero, E., Collet, C., Adiba, M.: The WHES approach to data warehouse evolution. Digit. J. e-Gnosis (2003). http://www.e-gnosis.udg.mx, ISSN No. 1665–5745

  6. Blaschka, M., Sapia, C., Hofling, G.: On schema evolution in multidimensional databases. In: Proceedings of International Conference on Data Warehousing and Knowledge Discovery (DaWaK). Lecture Notes in Computer Science, vol. 1676, pp. 153–164 (1999)

    Google Scholar 

  7. Blaschka, M.: FIESTA: A framework for schema evolution in multidimensional information systems. In: 6th CAiSE Doctoral Consortium. Heidelberg (1999)

    Google Scholar 

  8. Body, M., Miquel, M., Bédard, Y., Tchounikine, A.: A multidimensional and multiversion structure for OLAP applications. In: Proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP), pp. 1–6 (2002)

    Google Scholar 

  9. Body, M., Miquel, M., Bédard, Y., Tchounikine, A.: Handling evolutions in multidimensional structures. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 581 (2003)

    Google Scholar 

  10. De Castro, C., Grandi, F., Scalas, M., R.: On Schema Versioning in Temporal Databases. In: Clifford, S., Tuzhilin, A. (eds.) Recent Advances in Temporal Databases, pp. 272–294. Springer, Zurich Switzerland (1995)

    Google Scholar 

  11. Chamoni, P., Stock, S.: Temporal structures in data warehousing. In: Proceedings of International Conference on Data Warehousing and Knowledge Discovery (DaWaK). Lecture Notes in Computer Science, vol. 1676, pp. 353–358 (1997)

    Google Scholar 

  12. Eder, J.: Evolution of dimension data in temporal data warehouses. Technical Report 11, Univ. of Klagenfurt, Dep. of Informatics-Systems (2000)

    Google Scholar 

  13. Eder, J., Koncilia, C.: Changes of dimension data in temporal data warehouses. In: Proceedings of International Conference on Data Warehousing and Knowledge Discovery (DaWaK). Lecture Notes in Computer Science, vol. 2114, pp. 284–293 (2001)

    Google Scholar 

  14. Eder, J., Koncilia, C., Morzy, T.: A model for a temporal data warehouse. In: Proceedings of the International OESSEO Conference. Rome Italy (2001)

    Google Scholar 

  15. Eder, J., Koncilia, C., Morzy, T.: The COMET metamodel for temporal data warehouses. In: Proceedings of Conference on Advanced Information Systems Engineering (CAiSE). Lecture Notes in Computer Science, vol. 2348, pp. 83–99 (2002)

    Google Scholar 

  16. Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G.: Schema versioning in data warehouses. In: Proceedings of ER Workshops. Lecture Notes in Computer Science, vol. 3289, pp. 415–428 (2004)

    Google Scholar 

  17. Gosain, A., Saroha, K.: Storage structure for handling schema versions in temporal data warehouses. In: Accepted in 4th International Conference on Advanced Computing, Networking, and Informatics (ICACNI) (2016)

    Google Scholar 

  18. Gosain, A., Saroha, K.: Bi-temporal schema versioning in temporal data warehouses. In: Communicated in International Conference on Frontiers of Intelligent Computing: Theory and applications (FICTA) (2016)

    Google Scholar 

  19. Grandi, F., Mandreoli, F., Scalas, M.: A generalized modeling framework for schema versioning support. In: Australasian Database Conference, pp. 33–40 (2000)

    Google Scholar 

  20. Grandi, F., Mandreoli, F., Scalas, M.: A formal model for temporal schema versioning in object oriented databases. Technical report CSITE-014–98, CSITE-CNR (1998)

    Google Scholar 

  21. Hurtado, C.A., Mendelzon, A.O., Vaisman, A.A.: Maintaining data cubes under dimension updates. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 346–355 (1999)

    Google Scholar 

  22. Hurtado, C.A., Mendelzon, A.O., Vaisman, A.A.: Updating OLAP dimensions. In: Proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP), pp. 60–66 (1999)

    Google Scholar 

  23. Inmon, W.H.: Building the Data Warehouse. Wiley (1996)

    Google Scholar 

  24. Kaas, C.K., Pedersen, T.B., Rasmussen, B.D.: Schema evolution for stars and snowflakes. In: Proceedings of International Conference on Enterprise Information Systems (ICEIS), pp. 425–433 (2004)

    Google Scholar 

  25. Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley (2002)

    Google Scholar 

  26. Letz, C., Henn, E.T., Vossen, G.: Consistency in data warehouse dimensions. In: Proceedings of International Database Engineering and Applications Symposium (IDEAS), pp. 224–232 (2002)

    Google Scholar 

  27. Malinowski, E., Zimanyi, E.: A conceptual solution for representing time in data warehouse dimensions. In: 3rd Asia-Pacific Conference on Conceptual Modelling, Hobart Australia, pp. 45–54 (2006)

    Google Scholar 

  28. Mendelzon, A.O., Vaisman, A.A.: Temporal queries in OLAP. In: Proceedings of International Conference on Very Large Data Bases (VLDB), pp. 242–253 (2000)

    Google Scholar 

  29. Schlesinger, L., Bauer, A., Lehner, W., Ediberidze, G., Gutzman, M.: Efficiently synchronizing multidimensional schema data. In: Proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP), pp. 69–76 (2001)

    Google Scholar 

  30. Serna-Encinas, M.-T., Adiba, M.: Exploiting bitemporal schema versions for managing an historical medical data warehouse: a case study. In: Proceedings of the 6th Mexican International Conference on Computer Science (ENC’05), pp. 88–95. IEEE Computer Society (2005)

    Google Scholar 

  31. Vaisman, A., Mendelzon, A.: A temporal query language for OLAP: implementation and case study. In: Proceedings of Workshop on Data Bases and Programming Languages (DBPL). Lecture Notes in Computer Science, vol. 2397, pp. 78–96. Springer (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. USICT, GGSIPU, Dwarka, India

    Anjana Gosain

  2. SOIT, CDAC, Noida, India

    Kriti Saroha

Authors
  1. Anjana Gosain
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kriti Saroha
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Anjana Gosain .

Editor information

Editors and Affiliations

  1. Faculty of Computer Science, Bialystok University of Technology, Białystok, Poland

    Khalid Saeed

  2. Dept. of Computer Science & Engg., University of Calcutta Dept. of Computer Science & Engg., Kolkata, West Bengal, India

    Nabendu Chaki

  3. C. V. Raman College of Engineering, Bhubaneswar, Odisha, India

    Bibudhendu Pati

  4. Department of Computer Science and Engineering, National Institute of Technology, Rourkela, Rourkela, Odisha, India

    Sambit Bakshi

  5. Department of Computer Science and Engineering, National Institute of Technology, Rourkela, Rourkela, Odisha, India

    Durga Prasad Mohapatra

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Gosain, A., Saroha, K. (2018). Maintaining Bi-temporal Schema Versions in Temporal Data Warehouses. In: Saeed, K., Chaki, N., Pati, B., Bakshi, S., Mohapatra, D. (eds) Progress in Advanced Computing and Intelligent Engineering. Advances in Intelligent Systems and Computing, vol 564. Springer, Singapore. https://doi.org/10.1007/978-981-10-6875-1_29

Download citation

  • DOI: https://doi.org/10.1007/978-981-10-6875-1_29

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-10-6874-4

  • Online ISBN: 978-981-10-6875-1

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation