Browse wiki

Jump to: navigation, search
Graceful database schema evolution: the prism workbench
Abstract Supporting graceful schema evolution repreSupporting 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 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.d their ability to support legacy queries.
Added by wikilit team Added on initial load  +
Collected data time dimension Longitudinal  +
Comments "Continuous validation against challenging"Continuous validation against challenging real-life evolution histories, such as the one of Wikipedia, proved invaluable in molding PRISM into a system that builds on the theoretical foundations laid by recent research and provides a practical solution to the difficult problems of schema evolution." p.772 Wikipedia Database backend revisionsp.772 Wikipedia Database backend revisions
Conclusion The system provides interfaces with commerThe system provides interfaces with commercial relational DBMSs to implement the actual data migration and to deploy views and rewritten queries. As a by-product, the schema evolution history is recorded. This represents an invaluable piece of information for the purposes of documentation, database flash back, and DBA education. Continuous validation against challenging real-life evolution histories, such as the one of Wikipedia, proved invaluable in molding PRISM into a system that builds on the theoretical foundations laid by recent research and provides a practical solution to the difficult problems of schema evolution.he difficult problems of schema evolution.
Data source Experiment responses  + , Wikipedia pages  +
Doi 10.1145/1453856.1453939 +
Google scholar url http://scholar.google.com/scholar?ie=UTF-8&q=%22Graceful%2Bdatabase%2Bschema%2Bevolution%3A%2Bthe%2Bprism%2Bworkbench%22  +
Has author Carlo A. Curino + , Hyun J. Moon + , Carlo Zaniolo +
Has domain Computer science +
Has topic Other corpus topics +
Issue 1  +
Month August  +
Pages 761-772  +
Peer reviewed Yes  +
Publication type Conference paper  +
Published in Proceedings of the VLDB Endowment VLDB Endowment Hompage +
Research design Design science  + , Experiment  +
Research questions As of today, schema evolution remains an eAs 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 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.d their ability to support legacy queries.
Revid 10,796  +
Theories PRISM solves these problems by integrating recent theoretical advances on mapping composition and invertibility, into a design that also achieves usability and scalability.
Theory type Design and action  +
Title Graceful database schema evolution: the prism workbench
Unit of analysis N/A  +
Url http://dl.acm.org/citation.cfm?id=1453939  +
Volume 1  +
Wikipedia coverage Sample data  +
Wikipedia data extraction Dump  +
Wikipedia language Not specified  +
Wikipedia page type Article  + , History  +
Year 2008  +
Creation dateThis property is a special property in this wiki. 15 March 2012 20:28:38  +
Categories Other corpus topics  + , Computer science  + , Publications  +
Modification dateThis property is a special property in this wiki. 30 January 2014 20:28:37  +
hide properties that link here 
  No properties link to this page.
 

 

Enter the name of the page to start browsing from.