Schema Versioning in Databases: A Literature Review
Changes involving the database schema are unavoidable events that sometimes occur in data-centric systems, due to many reasons like evolution of user requirements, corrective maintenance, improvement of the current schema with the addition of new integrity constraints, implementation of new business...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
World Scientific Publishing
2024-01-01
|
| Series: | Computing Open |
| Subjects: | |
| Online Access: | https://www.worldscientific.com/doi/10.1142/S2972370124300024 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832542511366668288 |
|---|---|
| author | Zouhaier Brahmia Fabio Grandi Barbara Oliboni |
| author_facet | Zouhaier Brahmia Fabio Grandi Barbara Oliboni |
| author_sort | Zouhaier Brahmia |
| collection | DOAJ |
| description | Changes involving the database schema are unavoidable events that sometimes occur in data-centric systems, due to many reasons like evolution of user requirements, corrective maintenance, improvement of the current schema with the addition of new integrity constraints, implementation of new business rules, or compliance to new regulations. In order to manage schema changes, researchers have proposed a technique named “schema versioning”, in which all versions of the database schema are kept along with their underlying data, preventing loss of information and obsolescence of legacy applications. This technique has been widely studied in both conventional and emerging databases. Despite lot of interesting research efforts that have dealt with database schema versioning and the importance of this technique for database maintenance, current Database Management Systems (DBMSs) do not provide sufficient support for its implementation. This paper (i) gives an overview of state-of-the-art research approaches to schema versioning in databases, based on the study of more than 270 papers and providing a historical perspective on the development of the topic, (ii) illustrates the support of schema versioning in commercial DBMSs, and (iii) points out some possible future research directions in this area. |
| format | Article |
| id | doaj-art-5768e933fe6b42dcac1d2be91b7e0e2b |
| institution | Kabale University |
| issn | 2972-3701 |
| language | English |
| publishDate | 2024-01-01 |
| publisher | World Scientific Publishing |
| record_format | Article |
| series | Computing Open |
| spelling | doaj-art-5768e933fe6b42dcac1d2be91b7e0e2b2025-02-04T03:24:11ZengWorld Scientific PublishingComputing Open2972-37012024-01-010210.1142/S2972370124300024Schema Versioning in Databases: A Literature ReviewZouhaier Brahmia0Fabio Grandi1Barbara Oliboni2Department of Computer Science, Faculty of Economics and Management, University of Sfax, Road of the Aerodrome, Km 4.5, P.O. Box 1088, 3018 Sfax, TunisiaDipartimento di Informatica – Scienza e Ingegneria, Alma Mater Studiorum – Università di Bologna, Viale Risorgimento 2, I-40136 Bologna, ItalyDepartment of Computer Science, University of Verona, Ca’ Vignal 2, Strada Le Grazie 15, I-37134 Verona, ItalyChanges involving the database schema are unavoidable events that sometimes occur in data-centric systems, due to many reasons like evolution of user requirements, corrective maintenance, improvement of the current schema with the addition of new integrity constraints, implementation of new business rules, or compliance to new regulations. In order to manage schema changes, researchers have proposed a technique named “schema versioning”, in which all versions of the database schema are kept along with their underlying data, preventing loss of information and obsolescence of legacy applications. This technique has been widely studied in both conventional and emerging databases. Despite lot of interesting research efforts that have dealt with database schema versioning and the importance of this technique for database maintenance, current Database Management Systems (DBMSs) do not provide sufficient support for its implementation. This paper (i) gives an overview of state-of-the-art research approaches to schema versioning in databases, based on the study of more than 270 papers and providing a historical perspective on the development of the topic, (ii) illustrates the support of schema versioning in commercial DBMSs, and (iii) points out some possible future research directions in this area.https://www.worldscientific.com/doi/10.1142/S2972370124300024Database schemaschema changesschema change semanticsschema change propagationschema versioningdatabase conversion |
| spellingShingle | Zouhaier Brahmia Fabio Grandi Barbara Oliboni Schema Versioning in Databases: A Literature Review Computing Open Database schema schema changes schema change semantics schema change propagation schema versioning database conversion |
| title | Schema Versioning in Databases: A Literature Review |
| title_full | Schema Versioning in Databases: A Literature Review |
| title_fullStr | Schema Versioning in Databases: A Literature Review |
| title_full_unstemmed | Schema Versioning in Databases: A Literature Review |
| title_short | Schema Versioning in Databases: A Literature Review |
| title_sort | schema versioning in databases a literature review |
| topic | Database schema schema changes schema change semantics schema change propagation schema versioning database conversion |
| url | https://www.worldscientific.com/doi/10.1142/S2972370124300024 |
| work_keys_str_mv | AT zouhaierbrahmia schemaversioningindatabasesaliteraturereview AT fabiograndi schemaversioningindatabasesaliteraturereview AT barbaraoliboni schemaversioningindatabasesaliteraturereview |