Difference between revisions of "Prism"

From Schema Evolution
Jump to: navigation, search
Line 5: Line 5:
  
 
Carlo A. Curino (contact author): [http://carlo.curino.us/]
 
Carlo A. Curino (contact author): [http://carlo.curino.us/]
 +
 
Hyun J. Moon: [http://www.cs.ucla.edu/~hjmoon/]
 
Hyun J. Moon: [http://www.cs.ucla.edu/~hjmoon/]
 +
 
Carlo Zaniolo: [http://www.cs.ucla.edu/~zaniolo/]
 
Carlo Zaniolo: [http://www.cs.ucla.edu/~zaniolo/]
  

Revision as of 02:56, 11 May 2008

PRISM-LOGO.png

PRISM is a joint project of Politecnico di Milano and University of California, Los Angeles. The main investigators are:

Carlo A. Curino (contact author): [1]

Hyun J. Moon: [2]

Carlo Zaniolo: [3]

Abstract

Supporting graceful schema evolution represents an unsolved problem for traditional information systems that is further exacerbated in web information systems, such as Wikipedia and public scientific databases: in these projects based on multiparty cooperation the frequency of database schema changes has increased while tolerance for downtimes has nearly disappeared. As of today, schema evolution remains an error-prone and time-consuming undertaking, because the DB Administrator (DBA) lacks the methods and tools needed to manage and automate this endeavor by (i) predicting and evaluating the effects of the proposed schema changes, (ii) rewriting queries and applications to operate on the new schema, and (iii) migrating the database.

Our PRISM system takes a big first step toward addressing this pressing need by providing: (i) a language of Schema Modification Operators (SMO) to express concisely complex schema changes, (ii) tools that allow the DBA to evaluate the effects of such changes, (iii) optimized translation of old queries to work on the new schema version, (iv) automatic data migration, and (v) full documentation of intervened changes as needed to support data provenance, database flash back, and historical queries. PRISM solves these problems by integrating recent theoretical advances on mapping composition and invertibility, into a design that also achieves usability and scalability. Wikipedia and its 170+ schema versions provided an invaluable testbed for validating PRISM tools and their ability to support legacy queries.



On-line Demo

It is currently available an on-line Demo for the PRISM system PrismDemo. The Demo is still under development and has limited functionalities w.r.t. the internal prototype, but we are working on it... stay tuned!

Publication

This work is currently under submission. We will release more details soon. Contact: Carlo Curino [4]

Personal tools