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

  • Authors:

  • Carlo A. Curino;Hyun J. Moon;Carlo Zaniolo

  • Affiliations:

  • Politecnico di Milano,;University of California, Los Angeles,;University of California, Los Angeles,

  • Venue:
  • ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

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 Frameworkdesigned 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.