Skip to main content
SpringerLink
Log in

Managing the History of Metadata in Support for DB Archiving and Schema Evolution

  • Conference paper
Advances in Conceptual Modeling – Challenges and Opportunities (ER 2008)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5232))

Included in the following conference series:

Abstract

Modern information systems, and web information systems in particular, are faced with frequent database schema changes, which generate the necessity to manage them and preserve the schema evolution history. In this paper, we describe the Panta Rhei Framework designed to provide powerful tools that: (i) facilitate schema evolution and guide the Database Administrator in planning and evaluating changes, (ii) support automatic rewriting of legacy queries against the current schema version, (iii) enable efficient archiving of the histories of data and metadata, and (iv) support complex temporal queries over such histories. We then introduce the Historical Metadata Manager (HMM), a tool designed to facilitate the process of documenting and querying the schema evolution itself. We use the schema history of the Wikipedia database as a telling example of the many uses and benefits of HMM.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Snodgrass, R.T.: The TSQL2 Temporal Query Language. Kluwer, Dordrecht (1995)

    Book  MATH  Google Scholar 

  2. Almeida, R.B., Mozafari, B., Cho, J.: On the evolution of wikipedia. In: Int. Conf. on Weblogs and Social Media (March 2007)

    Google Scholar 

  3. Curino, C.A., Moon, H.J., Tanca, L., Zaniolo, C.: Schema Evolution in Wikipedia: toward a Web Information System Benchmark. In: ICEIS (2008)

    Google Scholar 

  4. Sjoberg, D.I.: Quantifying schema evolution. Information and Software Technology 35(1), 35–44 (1993)

    Article  Google Scholar 

  5. Marche, S.: Measuring the stability of data models. European Journal of Information Systems 2(1), 37–47 (1993)

    Article  Google Scholar 

  6. Moon, H.J., Curino, C.A., Deutsch, A., Hou, C.Y., Zaniolo, C.: Managing and querying transaction-time databases under schema evolution. In: VLDB (2008)

    Google Scholar 

  7. Curino, C.A., Moon, H.J., Ham, M., Zaniolo, C.: Architecture and optimization for transaction-time dbs with evolving schemas. Demo proposal submitted for publication (2009)

    Google Scholar 

  8. Wang, F., Zaniolo, C.: An XML-Based Approach to Publishing and Querying the History of Databases. World Wide Web: Web Information Systems Engineering 8(3), 233–259 (2005)

    Article  Google Scholar 

  9. Wang, F., Zaniolo, C., Zhou, X.: Archis: An xml-based approach to transaction-time temporal database systems. The International Journal of Very Large Databases (2008)

    Google Scholar 

  10. Curino, C.A., Moon, H.J., Zaniolo, C.: Graceful database schema evolution: the prism workbench. In: VLDB (2008)

    Google Scholar 

  11. Moon, H.J., Curino, C.A., Zaniolo, C.: Architecture and optimization for transaction-time dbs with evolving schemas (submitted for publication, 2009)

    Google Scholar 

  12. Deutsch, A., Tannen, V.: Mars: A system for publishing XML from mixed and redundant storage. In: VLDB (2003)

    Google Scholar 

  13. Clifford, J., Croker, A., Grandi, F., Tuzhilin, A.: On Temporal Grouping. In: Recent Advances in Temporal Databases, pp. 194–213. Springer, Heidelberg (1995)

    Chapter  Google Scholar 

  14. Roddick, J.: A Survey of Schema Versioning Issues for Database Systems. Information and Software Technology 37(7), 383–393 (1995)

    Article  Google Scholar 

  15. Castro, C.D., Grandi, F., Scalas, M.R.: Schema versioning for multitemporal relational databases. Information Systems 22(5), 249–290 (1997)

    Article  MATH  Google Scholar 

  16. Ram, S., Shankaranarayanan, G.: Research issues in database schema evolution: the road not taken. Boston University School of Management, Paper No: 2003-15 (2003)

    Google Scholar 

  17. Dyreson, C., Snodgrass, R.T., Currim, F., Currim, S., Joshi, S.: Validating quicksand: Schema versioning in auxschema. icdew 0, 82 (2006)

    Google Scholar 

  18. Rizzi, S., Golfarelli, M.: X-time: Schema versioning and cross-version querying in data warehouses. In: ICDE, pp. 1471–1472 (2007)

    Google Scholar 

  19. Grandi, F., Mandreoli, F., Tiberio, P.: Temporal modelling and management of normative documents in xml format. Data Knowl. Eng. 54(3), 327–354 (2005)

    Article  Google Scholar 

  20. Jørgensen, P.S., Böhlen, M.H.: Versioned relations: Support for conditional schema changes and schema versioning. In: Kotagiri, R., Radha Krishna, P., Mohania, M., Nantajeewarawat, E. (eds.) DASFAA 2007. LNCS, vol. 4443, pp. 1058–1061. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

  21. Wang, F., Zaniolo, C.: Representing and Querying the Evolution of Databases and their Schemas in XML. In: Intl. Workshop on Web Engineering, SEKE (2003)

    Google Scholar 

  22. Nash, A., Bernstein, P.A., Melnik, S.: Composition of mappings given by embedded dependencies. In: PODS (2005)

    Google Scholar 

  23. Bernstein, P.A., Green, T.J., Melnik, S., Nash, A.: Implementing mapping composition. VLDB J. 17(2), 333–353 (2008)

    Article  Google Scholar 

  24. Fagin, R.: Inverting schema mappings. ACM Trans. Database Syst. 32(4) (2007)

    Google Scholar 

  25. Curino, C.A., Tanca, L., Zaniolo, C.: Information systems integration and evolution: Ontologies at rescue. In: International Workshop on Semantic Technologies in System Maintenance (STSM) (2008)

    Google Scholar 

  26. Artale, A., Parent, C., Spaccapietra, S.: Evolving objects in temporal information systems. Ann. Math. Artif. Intell. 50(1-2), 5–38 (2007)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Politecnico di Milano, Italy

    Carlo A. Curino

  2. University of California, Los Angeles, USA

    Hyun J. Moon & Carlo Zaniolo

Authors
  1. Carlo A. Curino
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hyun J. Moon
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Carlo Zaniolo
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. College of Information Science and Technology, Drexel University, USA

    Il-Yeol Song

  2. Dep. of Information Technologies & Systems - Escuela Superior de Informática, University of Castilla-La Mancha, Alarcos Research Group- Institute of Information Technologies & Systems, Ciudad Real, Spain

    Mario Piattini

  3. School of Engineering and Information Technology, Deakin University, 221 Burwood Highway, Vic, 3125, Australia

    Yi-Ping Phoebe Chen

  4. Clausthal University of Technology, Julius-Albert-Str. 4, 38678, Clausthal-Zellerfeld, Germany

    Sven Hartmann

  5. Dipartimento di Elettronica, Informatica e Sistemistica, Alma Mater Studiorum – Università di Bologna, P.O. Box, Italy

    Fabio Grandi

  6. Department of Software and Computing Systems, University of Alicante, Spain

    Juan Trujillo

  7. Department of Information Science and Media Studies, University of Bergen, Fosswinckelsgate 6, 5007, Bergen, Norway

    Andreas L. Opdahl

  8. Istituto di Ricerche sulla Popolazione e Politiche Sociali, CNR, Via Nizza 128, 00198, Roma, Italy

    Fernando Ferri  & Patrizia Grifoni  & 

  9. IRPPS-CNR, Rome, Italy

    Maria Chiara Caschera

  10. Universit Paris1 Panthon Sorbonne, CRI, 90 Rue de Tolbiac, 75013, Paris

    Colette Rolland

  11. Portland State University, USA; Indiana University, USA University of British Columbia, Canada; Hill-Rom Company, USA University of British Columbia, Canada; Deloitte Consulting, P.O. Box, USA

    Carson Woo

  12. Centre de Recherche en Informatique, Université Paris 1 Panthéon-Sorbonne, 90 rue de Tolbiac, 75013, Paris

    Camille Salinesi

  13. Université Libre de Bruxelles, Belgium

    Esteban Zimányi

  14. Naval Academy Research Institute, Brest Naval, France

    Christophe Claramunt

  15. Technische Universiteit Eindhoven, PO Box 513, NL-5600 MB, Eindhoven, The Netherlands

    Flavius Frasincar

  16. Technische Universiteit Eindhoven, P.O. Box 513, NL 5600 MB, Eindhoven, The Netherlands

    Geert-Jan Houben

  17. IMRU-FUNDP, University of Namur, Namur, Belgium

    Philippe Thiran

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Curino, C.A., Moon, H.J., Zaniolo, C. (2008). Managing the History of Metadata in Support for DB Archiving and Schema Evolution. In: Song, IY., et al. Advances in Conceptual Modeling – Challenges and Opportunities. ER 2008. Lecture Notes in Computer Science, vol 5232. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-87991-6_11

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-87991-6_11

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-87990-9

  • Online ISBN: 978-3-540-87991-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation