Direkt zum Inhalt

Chillon, Alberto Hernandez ; Klettke, Meike ; Ruiz, Diego Sevilla ; Molina, Jesus Garcia

A Generic Schema Evolution Approach for NoSQL and Relational Databases

Chillon, Alberto Hernandez, Klettke, Meike , Ruiz, Diego Sevilla und Molina, Jesus Garcia (2024) A Generic Schema Evolution Approach for NoSQL and Relational Databases. IEEE Trans. Knowl. Data Eng. 36 (7), S. 2774-2789.

Veröffentlichungsdatum dieses Volltextes: 13 Aug 2025 05:59
Artikel
DOI zum Zitieren dieses Dokuments: 10.5283/epub.77266


Zusammenfassung

In the same way as with relational systems, schema evolution is a crucial aspect of NoSQL systems. But providing approaches and tools to support NoSQL schema evolution is more challenging than for relational databases. Not only are most NoSQL systems schemaless, but different data models exist without a standard specification for them. Moreover, recent proposals fail to address some key aspects ...

In the same way as with relational systems, schema evolution is a crucial aspect of NoSQL systems. But providing approaches and tools to support NoSQL schema evolution is more challenging than for relational databases. Not only are most NoSQL systems schemaless, but different data models exist without a standard specification for them. Moreover, recent proposals fail to address some key aspects related to the kinds of relationships between entities, the definition of relationship types, and the support of structural variation. In this article, we present a generic schema evolution approach able to support the most popular NoSQL data models (columnar, document, key-value, and graph) and the relational model. The proposal is based on the Orion language that implements a schema change operation taxonomy defined for the U-Schema unified data model that integrates NoSQL and relational abstractions. The consistency of the taxonomy operations is formally evaluated with Alloy, and the Orion semantics is expressed by translating operations into native code to update data and schema. Several database systems are supported, and the engine built for each of them has been validated by testing each individual SCO and refactoring study cases. A study of relative execution time of operations is also shown.



Beteiligte Einrichtungen


Details

DokumentenartArtikel
Titel eines Journals oder einer ZeitschriftIEEE Trans. Knowl. Data Eng.
Verlag:IEEE Service Center
Band:36
Nummer des Zeitschriftenheftes oder des Kapitels:7
Seitenbereich:S. 2774-2789
Datum5 Februar 2024
InstitutionenInformatik und Data Science > Allgemeine Informatik > Data Engineering (Prof. Dr.-Ing. Meike Klettke)
Identifikationsnummer
WertTyp
10.1109/TKDE.2024.3362273DOI
Dewey-Dezimal-Klassifikation000 Informatik, Informationswissenschaft, allgemeine Werke > 004 Informatik
StatusVeröffentlicht
BegutachtetJa, diese Version wurde begutachtet
An der Universität Regensburg entstandenZum Teil
URN der UB Regensburgurn:nbn:de:bvb:355-epub-772666
Dokumenten-ID77266

Bibliographische Daten exportieren

Nur für Besitzer und Autoren: Kontrollseite des Eintrags

nach oben