CoChat
Sign Up
Cited by 21Advanced Database Systems and QueriesSoftware Engineering ResearchSemantic Web and Ontologies

The DOI matches its Crossref record; 81 of the 82 references it cites were found in a registry or an index.

A Literature Review on Schema Evolution in Databases

Open access
Brahmia, Zouhaier, Grandi, Fabio, Oliboni, Barbara·2024·Computing Open
DOI 10.1142/s2972370124300012
Open this paper in CoChat — free account

Abstract

Changing a database schema is a fact of life in information systems, as a response to changes inside the enterprise (e.g., new users’ requirements, correction of errors in the current database schema) or outside it (e.g., new regulations, new partners’ requirements). In the database research field, a well-known technique has been proposed for managing schema changes, called schema evolution. It allows the database to survive schema changes by adapting existing data to conform to the new schema. A lot of research efforts addressed the topic of schema evolution, in both conventional (i.e., relational) and advanced (e.g., XML, stream, NoSQL) databases, providing a plethora of heterogeneous approaches and solutions making up a quite large literature. Since there is no research work that extensively deals with different proposals and compares them, the purpose of this paper is to fill this gap by reviewing the available schema evolution literature. For that, first we collected and summarized the contributions of research papers dealing with database schema evolution. Then we organized their presentation in a chronological order, also giving a historical perspective on the topic development. Finally, we defined a list of six comparison criteria (database model, implementation, schema change semantics, schema change propagation, integrity constraints, and software evolution) that have helped us to categorize and compare the different database schema evolution proposals. In sum, our…

Overview

Integrity signals

Registry

Crossref · 10.1142/s2972370124300012

Cites

81 of 81 references verified0 citation errors · 0 not checkable

Statistics

Recomputing p-values needs the paper’s full text.

Verification

Claims the paper makes

We couldn’t retrieve this paper’s full text, so its claims and self-check weren’t run. The registry and citation checks still apply.

Claims other papers make about this one

Each is checked against this paper’s own text: does it say what the citing paper says it does?

Citations

Cites

Show all 82 references

Research works printed but not linked: 101

  1. Björklund H., Proc. 33rd Int. Symp. Mathematical Foundations of Computer Science (MFCS 2008), 132
  2. Wang G., Proc. 7th Int. Database Engineering and Applications Symp. (IDEAS 2003), 230
  3. Lenzerini M., Proc. 21st ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Systems (PODS 2002), 233
  4. Milo T., Proc. 24th Int. Conf. Very Large Data Bases (VLDB 1998), 122
  5. Cluet S., Proc. 1998 ACM SIGMOD Int. Conf. Management of Data (SIGMOD 1998), 177
  6. Seylan I., Proc. 21st Int. Joint Conf. Artificial Intelligence (IJCAI 2009), 923
  7. Curino C., Proc. 25th Int. Conf. Data Engineering (ICDE 2009), 1523
  8. Moon H. J., Proc. ACM SIGMOD Int. Conf. Management of Data (SIGMOD 2009), 1019
  9. Curino C., Proc. 5th Int. Workshop on Evolution and Change in Data Management (ECDM 2008), 78
  10. Curino C. A., Proc. 10th Int. Conf. Enterprise Information Systems (ICEIS 2008), 323
  11. De Vries D., Proc. 3rd Int. Workshop on Evolution and Change in Data Management (ECDM 2004), 429
  12. De Vries D., Proc. 15th Int. Conf. Database and Expert Systems Applications (DEXA 2004), 663
  13. Xue J., Proc. 13th Int. Conf. Web-Age Information Management (WAIM 2012), 405
  14. Moro M. M., Proc. 2007 ACM SIGMOD Int. Conf. Management of Data (SIGMOD 2007), 959
  15. Hamill P., 2004, Unit Test Frameworks
  16. Herrmann K., Proc. 19th East European Conf. Advances in Databases and Information Systems (ADBIS 2015), 63
  17. Nguyen G. T., Proc. IFIP 11th World Computer Congress (IFIP Congress 1989), 815
  18. Lerner B. S., Proc. Conf. Object-Oriented Programming Systems, Languages, and Applications/European Conf. Object-Oriented Programming (OOPSLA/ECOOP 1990), 67
  19. Ferrandina F., Proc. OOPSLA’1993 Workshop on Supporting the Evolution of Class Definitions
  20. Ferrandina F., Proc. 20th Int. Conf. Very Large Data Bases (VLDB 1994), 261
  21. Ferrandina F., Proc. 6th Int. Workshop on Persistent Object Systems (POS 1994), 284
  22. Lagorce J., Proc. 6th Int. Conf. Database Theory (ICDT 1997), 379
  23. Al-Jadir L., Proc. 17th Int. Conf. Conceptual Modeling (ER 1998), 316
  24. Al-Jadir L., Proc. 4th Int. Conf. Database Systems for Advanced Applications (DASFAA 1995), 284
  25. Li X., Proc. 31st Int. Conf. Technology of Object-Oriented Languages and Systems (TOOLS 1999), 362
  26. Penney D. J., Proc. 2nd Conf. Object-Oriented Programming Systems, Languages and Applications (OOPSLA’87), 111
  27. Monk S. R., Proc. 10th British National Conf. Databases (BNCOD 1992), 42
  28. Ferrandina F., Proc. 21st Int. Conf. Very Large Data Bases (VLDB 1995), 170
  29. Ra Y. G., 1997, IEEE Trans. Knowl. Data Eng., 9, 600
  30. Claypool K. T., Proc. 1998 ACM Int. Conf. Information and Knowledge Management (CIKM 1998), 314
  31. Claypool K. T., Proc. Int. ECOOP’2000 Symp. Objects and Databases, 114
  32. Su H., Proc. 11th Int. Workshop on Research Issues in Data Engineering Document Management for Data Intensive Business and Scientific Applications (RIDE-DM 2001), 103
  33. Al-Jadir L., Proc. 9th Int. Conf. Object Oriented Information Systems (OOIS 2003), 3
  34. Prashant B. V. N., Proc. 13th Int. Conf. Management of Data (COMAD’2006), 174
  35. Bouchou B., Proc. 29th Int. Symp. Mathematical Foundations of Computer Science (MFCS 2004), 876
  36. Bouchou B., Proc. 22nd Brazilian Symp. Databases (SBBD 2007), 270
  37. Amavi J., Proc. 25th Int. Conf. Database and Expert Systems Applications (DEXA 2014), 299
  38. Guerrini G., Proc. 7th ACM Int. Workshop on Web Information and Data Management (WIDM 2005), 39
  39. Guerrini G., Proc. 3rd Int. DEXA Workshop on XML Data Management Tools and Techniques (XANTEC’08), 251
  40. Cavalieri F., Proc. 2010 EDBT/ICDT Workshops (Updates in XML), 10
  41. Cavalieri F., Proc. 27th Int. Conf. Data Engineering (ICDE 2011), 1320
  42. Cavalieri F., Proc. 1st Int. ICDE Workshop on Managing Data Throughout its Lifecycle (DaLi 2011), 77
  43. Klettke M., Workshop Proc. Datenbanksysteme in Business, Technologie und Web (BTW 2007), 53
  44. Nösinger T., Proc. 25th GI-Workshop on Foundations of Databases (Grundlagen von Datenbanken 2013), 28
  45. Nösinger T., Proc. 24th Int. Conf. Database and Expert Systems Applications (DEXA 2013), 293
  46. Nösinger T., Proc. 26th GI-Workshop on Foundations of Databases (Grundlagen von Datenbanken 2014), 11
  47. Klímek J., Proc. 12th Annual Int. Workshop on DAtabases, TExts, Specifications and Objects (DATESO 2012), 69
  48. Klímek J., 2015, Inf. (Lithuanian Acad. Sci.), 26, 453
  49. Galvao I., Proc. 11th IEEE Int. Enterprise Distributed Object Computing Conf. (EDOC 2007), 313
  50. Brahmia Z., Proc. ACM — 7th Int. Conf. Software Engineering and New Technologies (ACM-ICSENT’2018)
  51. Picalausa F., Proc. 2011 ACM Symp. Applied Computing (SAC 2011), 1645
  52. Alur R., Proc. 36th Annual ACM Symp. Theory of Computing (STOC 2004), 202
  53. Guerrini G., Proc. 5th Int. XML Database Symp. (XSym 2007), 92
  54. Baqasah A., Proc. 24th IEEE Int. Conf. Advanced Information Networking and Applications Workshops (WAINA 2010), 455
  55. Quass D., Proc. 1997 ACM SIGMOD Int. Conf. Management of Data (SIGMOD 1997), 393
  56. Terwilliger J. F., 2010, J. Univ. Comput. Sci., 16, 3073
  57. Neamtiu I., Proc. ACM SIGPLAN 2006 Conf. Programming Language Design and Implementation (PLDI 2006), 72
  58. Makris K., Proc. 2009 USENIX Annual Technical Conf. (USINEX’09)
  59. Subramanian S., Proc. 2009 ACM SIGPLAN Conf. on Programming Language Design and Implementation (PLDI 2009), 1
  60. Wu S., Proc. 3rd ICDE Workshop on Hot Topics in Software Upgrades (HotSWUp 2011), 151
  61. Liu Z., Proc. 14th Int. Conf. Extending Database Technology (EDBT 2011), 105
  62. Scherzinger S., Proc. 14th Int. Symp. Database Programming Languages (DBPL 2013)
  63. Tiwari S., 2011, Professional NoSQL
  64. Scherzinger S., Proc. 16th Conf. Database Systems for Business, Technology, and Web (BTW 2015), 241, 659
  65. Dean J., Proc. 6th Symp. Operating System Design and Implementation (OSDI 2004), 137
  66. Störl U., Proc. 16th Conf. Database Systems for Business, Technology, and Web (BTW 2015), 241, 579
  67. Scherzinger S., Proc. 31st IEEE Int. Conf. Data Engineering (ICDE 2015), 1464
  68. Cerqueus T., Proc. 1st IEEE/ACM Int. Workshop on Big Data Software Engineering (BIGDSE 2015), 4
  69. Cerqueus T., Proc. 24th Int. Conf. World Wide Web Companion (WWW 2015), 15
  70. Saur K., Proc. 32nd IEEE Int. Conf. Software Maintenance and Evolution (ICSME 2016), 166
  71. Han J., Proc. 6th Int. Conf. Pervasive Computing and Applications (ICPCA 2011), 363
  72. Scherzinger S., Proc. 2nd Int. Workshop on Quality-Aware DevOps (QUDOS@ISSTA 2016), 38
  73. Klettke M., Proc. 2016 IEEE Int. Conf. Big Data (BigData 2016), 2764
  74. Störl U., Proc. 17th Conf. Database Systems for Business, Technology, and Web (BTW 2017), 611
  75. Haubold F., Proc. 17th Conf. Database Systems for Business, Technology, and Web (BTW 2017), 601
  76. Bonifati A., Proc. 38th Int. Conf. Conceptual Modeling (ER 2019), 448
  77. Francis N., Proc. 2018 Int. Conf. Management of Data (SIGMOD’2018), 1433
  78. Hillenbrand A., Proc. 2020 IEEE 36th Int. Conf. Data Engineering Workshops (ICDEW 2020), 133
  79. Brown M., 2013, Developing with Couchbase Server
  80. Klettke M., Proc. 16th Conf. Database Systems for Business, Technology, and Web (BTW 2015), 241, 425
  81. Lightstone S., 2010, Making it Big in Software
  82. Bhattacherjee S., Proc. 2021 Int. Conf. Management of Data (SIGMOD’2021), 194
  83. Störl U., Workshop Proc. EDBT/ICDT 2022 Joint Conf.
  84. Möller M. L., 2020, Proc. 2020 IEEE Int. Conf. Big Data (Big Data), 1974
  85. Conrad A., 2021, Technology Conf. Performance Evaluation and Benchmarking, 33
  86. Chillón A. H., Proc. 40th Int. Conf. Conceptual Modeling (ER’2021), 176
  87. Holubová I., 2021, DataKnowl. Eng., 136, 101932
  88. Vavrek M., Proc. 22nd Int. Conf. Extending Database Technology (EDBT 2019), 19, 586
  89. Benats P., Proc. 41st Int. Conf. Conceptual Modeling (ER 2022), ER’2022 Forum and Symp.
  90. Basciani F., Proc. 23rd ACM/IEEE Int. Conf. Model Driven Engineering Languages and Systems (MODELS’2020): Companion Proc., 1
  91. Sow D. M., Proc. 2007 Inaugural Int. Conf. Distributed Event-Based Systems (DEBS 2007), 189
  92. Lu J., Proc. 20th Int. Conf. Extending Database Technology (EDBT’2017), 602
  93. Tsunakawa T., PG Conf. ASIA 2017
  94. Koupil P., Proc. 26th Int. Conf. Extending Database Technology (EDBT’2023), 831
  95. Koupil P., Proc. 31st ACM Int. Conf. Information & Knowledge Management (CIKM’2022), 4892
  96. Kolev B., Proc. 2016 IEEE Int. Conf. Big Data (Big Data), 2574
  97. Vogt M., Proc. 2018 IEEE Int. Conf. Big Data (Big Data), 3364
  98. Delplanque J., Proc. 2018 IEEE Int. Conf. Software Maintenance and Evolution (ICSME), 635
  99. Solodovnikova D., Proc. Spring Young Researcher’s Colloquium on Database and Information Systems (SYRCoDIS’07), 6
  100. Faisal S., 2017, Sci. Programm., 2017
  101. Klettke M., Proc. 2017 IEEE Int. Conf. Big Data (Big Data), 2462

Cited by

Sorted by citations

See all 21

Related

Metadata

Authors
Brahmia, Z., Grandi, F., & Oliboni, B.
Affiliations
  • University of Sfax (TN)
  • Dipartimento di Informatica – Scienza e Ingegneria, Alma Mater Studiorum – Università di Bologna, Viale Risorgimento 2, I-40136 Bologna, Italy
  • University of Verona (IT)
ORCID
Venue
Computing Open
Publisher
World Scientific Pub Co Pte Ltd
Published
2024-01
Volume
02
ISSN
2972-3701 (ISSN-L)
DOI
10.1142/s2972370124300012
OpenAlex
W4399752508
Cited by
12
References
82
Citations by year
2026: 8 · 2025: 3 · 2024: 1
FWCI
2.00
Type
journal article
Language
en
Open access
Licence
cc-by
Locations
  • Computing Open (publishedVersion, cc-by)
  • Archivio istituzionale della ricerca (Alma Mater Studiorum Università di Bologna) (submittedVersion, cc-by)
  • DOAJ (DOAJ: Directory of Open Access Journals) (submittedVersion, cc-by-sa)
Topics
  • Physical Sciences › Computer Science › Information Systems › Advanced Database Systems and Queries
  • Physical Sciences › Computer Science › Information Systems › Software Engineering Research
  • Physical Sciences › Computer Science › Artificial Intelligence › Semantic Web and Ontologies
Keywords
schema evolution, database schema changes, data migration, integrity constraints, software evolution, relational databases, XML databases, NoSQL databases, stream databases

About these checks

Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.

Statistics and arithmetic are recomputed, not judged.

Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.

What counts as a claim ›How we measure confidence ›How we check this ›

Are you an author, or do you see a problem with this page? Request a review