DenkzeitWiki

Main /

DBSchemaEvolution

DBMS

DBSchemaDiffs
DBSchemaVersionControl

InformationSchema
StoredProcedures
SchemaCompatibility
Transforming (i.e. changing) the schema of a database without loosing data.

The changes applied to a database schema should be VersionControlled, so that the changes in the schema and the changes in the access layer that makes use of those changes are versioned together and always 'fit'. See DBSchemaVersionControl for links on that topic...

---

• SchemaEvolution
  • Changing the schema of a DB without loosing existing data.
• SchemaVersioning?
  • managing different schemata of a DB so that the data within a DB can be viewed/accessed according to different schematas.

---

Django

• http://code.djangoproject.com/wiki/SchemaEvolution
  • http://code.djangoproject.com/wiki/SchemaEvolutionProposal
  • http://code.djangoproject.com/browser/django/branches/schema-evolution

---

• Database Refactoring
  
• MIGRATEdb
  • MIGRATEdb? will parse an XML file of database changes and load them to the targeted database if they are not already there.
  • A database change consists of a test to determine whether the change has already been applied and a set of change actions.
  
  
• http://www.mayocchi.com/blog/category/database/
  
• Database Versioning
  • This article discusses the maintenance of local client databases for applications that must operate in “disconnected mode” – without a server connection.
  
  
• Organizing Database Schema Updates
  • algorithm for transforming from version m to version n
  
  
• Version Control of Database Data
  • using pre-commit hook to create DBSchemaDiffs that are then version-controlled.
    
  
  
• Version control of database objects?
  • branding and merging
• The Database Patch Runner
• The Database Patch Runner - Rollbacks
  
  
• Evolutionary Database Design by MartinFowler
• Agile Database Schema Evolution
  • reverting schema changes? difficult - rollback-scripts
  • test thorougly and hope for best
  • don't delete unused fields until sure they are no longer needed
  • format schema consistently, then use SourceControl
• Migrations for RubyOnRails
  
  
• SCM for Databases?

---

• Seminar "Schema Evolution"
  • http://dbs.uni-leipzig.de/en/seminare/SE/WS0506/literatur.html
• A Survey of Schema Versioning Issues for Database Systems
• Database Change Management and Schema Evolution in DB2 for z/OS Version 8

One of the bigger causes of database downtime is caused when changes are made to DB2 database structures. This is so because many of the most common changes required of DB2 objects cannot be supported with simple ALTERs. Instead, DBAs are required to DROP the object and then re-CREATE it with the desired changes.

Online schema evolution begins the process of making more types of database change possible without requiring objects to be dropped and re-created.

• Schema Evolution and Versioning: a Logical and Computational Characterisation
  • ObjectOriented DBs
  
  
• Database Schema Evolution and Meta-Modeling. 9th International Workshop on Foundations of Models and Languages for Data and Objects FoMLaDO/DEMM 2000 Dagstuhl

---

• RDF - schema versioning and data typing
• Storing RDF in a relational database
• RDF and Databases @LtU

Windows INI format uses "key-equals-value," with keys grouped into sections. Think of "key-equals-value" as a special case of RDF's "subject-predicate-object." RDF generalizes to any verb, not just "equals," along with superior grouping. While INI nests just one level down (via sections), RDF URIs handle arbitrary nesting (via slashes), and URIs also permit remote data.

---

• Database Schema Transformation & Optimization
  
• Management of Schema Evolution in Databases
  
• Schema Evolution In Software Engineering Databases A New Approach In Adele Environment
  
• Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach
  • Automatic Migration and Wrapping of Database Applications a Schema Transformation Approach

---

• Dont Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources
  • http://db.cs.berkeley.edu/postmodern/lecs/mehul/
• On the Logical Foundations of Schema Integration and Evolution in Heterogeneous Database Systems
• Query Translation in Heterogeneous Database Environments

---

• Seminarvortrag "Schemaanpassungen"
• Impact of XML Schema Versioning on System Design

---

• Database generations
  • schema manager
  • minimum version

Tools

• http://www.dbghost.com/
  • DB Ghost BUILDS, COMPARES and SYNCHRONIZES your SQL Server 2000/2005 databases. It guarantees database integrity by building databases directly from your source control system.
  
  
• Daversy - database versioning system