Graceful database schema evolution: the prism workbench

From WikiLit
Jump to: navigation, search
Publication (help)
Graceful database schema evolution: the prism workbench
Authors: Carlo A. Curino, Hyun J. Moon, Carlo Zaniolo [edit item]
Citation: Proceedings of the VLDB Endowment VLDB Endowment Hompage 1 (1): 761-772. 2008 August.
Publication type: Conference paper
Peer-reviewed: Yes
Database(s):
DOI: 10.1145/1453856.1453939.
Google Scholar cites: Citations
Link(s): Paper link
Added by Wikilit team: Added on initial load
Search
Article: Google Scholar BASE PubMed
Other scholarly wikis: AcaWiki Brede Wiki WikiPapers
Web search: Bing Google Yahoo!Google PDF
Other:
Services
Format: BibTeX
Graceful database schema evolution: the prism workbench is a publication by Carlo A. Curino, Hyun J. Moon, Carlo Zaniolo.


[edit] 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 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.

[edit] Research questions

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

Research details

Topics: Other corpus topics [edit item]
Domains: Computer science [edit item]
Theory type: Design and action [edit item]
Wikipedia coverage: Sample data [edit item]
Theories: "PRISM solves these problems by integrating recent theoretical advances on

mapping composition and invertibility, into a design that also achieves usability and scalability." [edit item]

Research design: Design science, Experiment [edit item]
Data source: Experiment responses, Wikipedia pages [edit item]
Collected data time dimension: Longitudinal [edit item]
Unit of analysis: N/A [edit item]
Wikipedia data extraction: Dump [edit item]
Wikipedia page type: Article, History [edit item]
Wikipedia language: Not specified [edit item]

[edit] Conclusion

"The 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."

[edit] Comments

""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 revisions"


Further notes[edit]

Facts about "Graceful database schema evolution: the prism workbench"RDF feed
AbstractSupporting 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 teamAdded on initial load +
Collected data time dimensionLongitudinal +
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
ConclusionThe 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 sourceExperiment responses + and Wikipedia pages +
Doi10.1145/1453856.1453939 +
Google scholar urlhttp://scholar.google.com/scholar?ie=UTF-8&q=%22Graceful%2Bdatabase%2Bschema%2Bevolution%3A%2Bthe%2Bprism%2Bworkbench%22 +
Has authorCarlo A. Curino +, Hyun J. Moon + and Carlo Zaniolo +
Has domainComputer science +
Has topicOther corpus topics +
Issue1 +
MonthAugust +
Pages761-772 +
Peer reviewedYes +
Publication typeConference paper +
Published inProceedings of the VLDB Endowment VLDB Endowment Hompage +
Research designDesign science + and Experiment +
Research questionsAs 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.
Revid10,796 +
TheoriesPRISM solves these problems by integrating recent theoretical advances on mapping composition and invertibility, into a design that also achieves usability and scalability.
Theory typeDesign and action +
TitleGraceful database schema evolution: the prism workbench
Unit of analysisN/A +
Urlhttp://dl.acm.org/citation.cfm?id=1453939 +
Volume1 +
Wikipedia coverageSample data +
Wikipedia data extractionDump +
Wikipedia languageNot specified +
Wikipedia page typeArticle + and History +
Year2008 +