Difference between revisions of "Prism"

From Schema Evolution
Jump to: navigation, search
(On-line Demo)
Line 42: Line 42:
  
 
== On-line Demo ==
 
== On-line Demo ==
 +
 
[[Image:Prism screenshot.png|thumb|Prism: a tool for schema evolution support]]
 
[[Image:Prism screenshot.png|thumb|Prism: a tool for schema evolution support]]
  
It is currently available an on-line Demo for [[PrismDemo | Prism a tool for schema evolution support]].
+
 
 +
There is a '''Video''' of the Demo available at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/Prism-Demo.mov
 +
 
 +
While the actual demo is available online at: [[PrismDemo | Prism a tool for schema evolution support]].
 
The Demo is still under development and has limited functionalities w.r.t. the internal prototype, but we are working on it... stay tuned!
 
The Demo is still under development and has limited functionalities w.r.t. the internal prototype, but we are working on it... stay tuned!
  

Revision as of 00:52, 14 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

Prism: a tool for schema evolution support


There is a Video of the Demo available at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/Prism-Demo.mov

While the actual demo is available online at: Prism a tool for schema evolution support. 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