demonstration

Worry-free database upgrades: automated model-driven evolution of schemas and complex mappings

Authors:

James F. Terwilliger,

Philip A. Bernstein,

Adi UnnithanAuthors Info & Claims

SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

Pages 1191 - 1194

https://doi.org/10.1145/1807167.1807316

Published: 06 June 2010 Publication History

Get Access

Abstract

Schema evolution is an unavoidable consequence of the application development lifecycle. The two primary schemas in an application, the client conceptual object model and the persistent database model, must co-evolve or risk quality, stability, and maintainability issues. We present MoDEF, an extension to Visual Studio that supports automatic evolution of object-relational mapping artifacts in the Microsoft Entity Framework. When starting with a valid mapping between client and store, MoDEF translates changes made to a client model into incremental changes to the store as an upgrade script, along with a new valid mapping to the new store. MoDEF mines the existing mapping for mapping patterns which MoDEF reuses for new client artifacts.

References

[1]

E. Domíngueza, J. Lloret, A. L. Rubio, and M. A. Zapata. Evolving the Implementation of ISA Relationships in EER Schemas. ER Workshops 2006, LNCS 4231.

Digital Library

Google Scholar

[2]

Hibernate. Available at http://www.hibernate.org/.

Google Scholar

[3]

A. Malpani, P. A. Bernstein, S. Melnik, and J. F. Terwilliger. Reverse Engineering Models from Databases to Bootstrap Application Development. ICDE 2010.

Crossref

Google Scholar

[4]

P. McBrien and A. Poulovassilis. Schema Evolution in Heterogeneous Database Architectures, a Schema Transformation Approach. CAiSE 2002.

Digital Library

Google Scholar

[5]

S. Melnik, A. Adya, and P. A. Bernstein. Compiling Mappings to Bridge Applications and Databases. ACM TODS, 33(4) (2008).

Digital Library

Google Scholar

[6]

Ruby on Rails. http://rubyonrails.org/.

Google Scholar

[7]

E. Rahm and P. A. Bernstein. An Online Bibliography on Schema Evolution. SIGMOD Record, 35(4), 2006.

Digital Library

Google Scholar

[8]

Y. Velegrakis, R. J. Miller, and L. Popa. Preserving Mapping Consistency Under Schema Changes. VLDB Journal, 2004, 13(3).

Digital Library

Google Scholar

[9]

C. Yu and L. Popa. Semantic Adaptation of Schema Mappings When Schemas Evolve. VLDB 2005.

Digital Library

Google Scholar

Cited By

View all

Schuler RKesselman C(2022)Managing Database-Application Co-Evolution in a Scientific Data Ecosystem2022 IEEE 18th International Conference on e-Science (e-Science)10.1109/eScience55777.2022.00035(214-224)Online publication date: Oct-2022
https://doi.org/10.1109/eScience55777.2022.00035
Schuler RKesselman C(2021)CHiSEL: a user-oriented framework for simplifing database evolutionDistributed and Parallel Databases10.1007/s10619-020-07314-x39:2(483-543)Online publication date: 1-Jun-2021
https://dl.acm.org/doi/10.1007/s10619-020-07314-x
Schuler RKessleman CMaltzahn CMalik T(2019)A High-level User-oriented Framework for Database EvolutionProceedings of the 31st International Conference on Scientific and Statistical Database Management10.1145/3335783.3335787(157-168)Online publication date: 23-Jul-2019
https://dl.acm.org/doi/10.1145/3335783.3335787
Show More Cited By

Index Terms

Worry-free database upgrades: automated model-driven evolution of schemas and complex mappings
1. Information systems
  1. Data management systems
    1. Information integration
    2. Middleware for databases
      1. Object-relational mapping facilities
2. Software and its engineering
  1. Software creation and management
    1. Software development techniques
      1. Software prototyping
    2. Software post-development issues
      1. Software evolution

Recommendations

Automating database schema evolution in information system upgrades
HotSWUp '09: Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades

The complexity, cost, and down-time currently created by the database schema evolution process is the source of incessant problems in the life of information systems and a major stumbling block that prevent graceful upgrades. Furthermore, our studies ...
Managing Schema Evolution in Hybrid XML-Relational Database Systems
WAINA '10: Proceedings of the 2010 IEEE 24th International Conference on Advanced Information Networking and Applications Workshops

Many applications and data enterprises need to change their data content and structure from time to time. The schema evolution in database systems has been studied well by the database community and several projects have been proposed for supporting ...
CHiSEL: a user-oriented framework for simplifing database evolution
Abstract
In order to conduct research effectively, scientists must be able to access, organize, describe, and produce data as part of their daily research activities. While relational databases are well suited to the tasks of describing and organizing ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

June 2010

1286 pages

ISBN:9781450300322

DOI:10.1145/1807167

General Chair:
Ahmed Elmagarmid
Purdue University, USA
,
Program Chair:
Divyakant Agrawal
University of California at Santa Barbara, USA

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 06 June 2010

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Demonstration

Conference

SIGMOD/PODS '10

Sponsor:

SIGMOD

SIGMOD/PODS '10: International Conference on Management of Data

June 6 - 10, 2010

Indiana, Indianapolis, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
384
Total Downloads

Downloads (Last 12 months)4
Downloads (Last 6 weeks)0

Reflects downloads up to 12 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Schuler RKesselman C(2022)Managing Database-Application Co-Evolution in a Scientific Data Ecosystem2022 IEEE 18th International Conference on e-Science (e-Science)10.1109/eScience55777.2022.00035(214-224)Online publication date: Oct-2022
https://doi.org/10.1109/eScience55777.2022.00035
Schuler RKesselman C(2021)CHiSEL: a user-oriented framework for simplifing database evolutionDistributed and Parallel Databases10.1007/s10619-020-07314-x39:2(483-543)Online publication date: 1-Jun-2021
https://dl.acm.org/doi/10.1007/s10619-020-07314-x
Schuler RKessleman CMaltzahn CMalik T(2019)A High-level User-oriented Framework for Database EvolutionProceedings of the 31st International Conference on Scientific and Statistical Database Management10.1145/3335783.3335787(157-168)Online publication date: 23-Jul-2019
https://dl.acm.org/doi/10.1145/3335783.3335787
Schuler RKesselman CSacharidis DGamper JBöhlen M(2018)Towards an efficient and effective framework for the evolution of scientific databasesProceedings of the 30th International Conference on Scientific and Statistical Database Management10.1145/3221269.3221300(1-4)Online publication date: 9-Jul-2018
https://dl.acm.org/doi/10.1145/3221269.3221300
Herrmann KVoigt HRausch JBehrend ALehner W(2018)Robust and simple database evolutionInformation Systems Frontiers10.1007/s10796-016-9730-220:1(45-61)Online publication date: 1-Feb-2018
https://dl.acm.org/doi/10.1007/s10796-016-9730-2
Manousis PVassiliadis PZarras APapastefanatos G(2016)Schema Evolution for Databases and Data WarehousesBusiness Intelligence10.1007/978-3-319-39243-1_1(1-31)Online publication date: 10-May-2016
https://doi.org/10.1007/978-3-319-39243-1_1
Milovanovic VMilicev D(2015)An interactive tool for UML class model evolution in database applicationsSoftware and Systems Modeling (SoSyM)10.1007/s10270-013-0378-914:3(1273-1295)Online publication date: 1-Jul-2015
https://dl.acm.org/doi/10.1007/s10270-013-0378-9
Herrmann KVoigt HBehrend ALehner W(2015)CoDEL – A Relationally Complete Language for Database EvolutionAdvances in Databases and Information Systems10.1007/978-3-319-23135-8_5(63-76)Online publication date: 15-Aug-2015
https://doi.org/10.1007/978-3-319-23135-8_5
Curino CMoon HDeutsch AZaniolo C(2013)Automating the database schema evolution processThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-012-0302-x22:1(73-98)Online publication date: 1-Feb-2013
https://dl.acm.org/doi/10.1007/s00778-012-0302-x
Terwilliger J(2013)Bidirectional by Necessity: Data Persistence and Adaptability for Evolving Application DevelopmentGenerative and Transformational Techniques in Software Engineering IV10.1007/978-3-642-35992-7_6(219-270)Online publication date: 2013
https://doi.org/10.1007/978-3-642-35992-7_6
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Automating database schema evolution in information system upgrades

Managing Schema Evolution in Hybrid XML-Relational Database Systems

CHiSEL: a user-oriented framework for simplifing database evolution