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

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. Categories and Subject Descriptors D.2.2 [Design Tools]: Evolutionary Prototyping; D.2.12 [Interoperability]: Data Mapping General Terms Algorithms, Theory Keywords Schema evolution, model management, O-R mapping

• Type: Conference
• Year: 2010
• Where: SIGMOD
• Authors: James F. Terwilliger, Philip A. Bernstein, Adi Unnithan
• Keywords: Database, Object-relational Mapping Artifacts, Schema Evolution, SIGMOD 2010, Valid Mapping