A Generic Schema Evolution Approach for NoSQL and Relational Databases

被引:3
作者
Chillon, Alberto Hernandez [1 ]
Klettke, Meike [2 ]
Ruiz, Diego Sevilla [1 ]
Molina, Jesus Garcia [1 ]
机构
[1] Univ Murcia, Fac Comp Sci, Murcia 30100, Spain
[2] Univ Regensburg, Fac Comp Sci & Data Sci, D-93053 Regensburg, Germany
关键词
Data models; Taxonomy; Codes; Databases; Engines; Aggregates; Relational databases; NoSQL databases; schema evolution; Evolution management; taxonomy of changes; schema change operations; MANAGEMENT;
D O I
10.1109/TKDE.2024.3362273
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
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.
引用
收藏
页码:2774 / 2789
页数:16
相关论文
共 50 条
  • [41] UML4NOSQL: A NOVEL APPROACH FOR MODELING NOSQL DOCUMENT-ORIENTED DATABASES BASED ON UML
    Maicha, Mohammed ElHabib
    Ouinten, Youcef
    Ziani, Benameur
    COMPUTING AND INFORMATICS, 2022, 41 (03) : 813 - 833
  • [42] A comprehensive approach to anomaly detection in relational databases
    Spalka, A
    Lehnhardt, J
    DATA AND APPLICATIONS SECURITY XIX, PROCEEDINGS, 2005, 3654 : 207 - 221
  • [43] Beyond Database Schema Evolution
    Yannakoudakis, E. J.
    Diamantis, I. K.
    IMETI 2008: INTERNATIONAL MULTI-CONFERENCE ON ENGINEERING AND TECHNOLOGICAL INNOVATION, VOL I, PROCEEDINGS, 2008, : 245 - +
  • [44] NoSQL Databases: A Software Engineering Perspective
    Lourenco, Joao Ricardo
    Abramova, Veronika
    Vieira, Marco
    Cabral, Bruno
    Bernardino, Jorge
    NEW CONTRIBUTIONS IN INFORMATION SYSTEMS AND TECHNOLOGIES, VOL 1, PT 1, 2015, 353 : 741 - 750
  • [45] NoSQL Databases - Seek for a Design Methodology
    Asaad, Chaimae
    Baina, Karim
    MODEL AND DATA ENGINEERING, MEDI 2018, 2018, 11163 : 25 - 40
  • [46] Rule-based schema evolution in object-oriented databases
    Alhajj, R
    Polat, F
    KNOWLEDGE-BASED SYSTEMS, 2003, 16 (01) : 47 - 57
  • [47] Temporal and versioning model for schema evolution in object-oriented databases
    Galante, RD
    dos Santos, CS
    Edelweiss, N
    Moreira, AF
    DATA & KNOWLEDGE ENGINEERING, 2005, 53 (02) : 99 - 128
  • [48] Experimental Assessment of NoSQL Databases Dependability
    Ventura, Luis
    Antunes, Nuno
    2016 12TH EUROPEAN DEPENDABLE COMPUTING CONFERENCE (EDCC 2016), 2016, : 161 - 168
  • [49] A performance comparison of SQL and NoSQL databases
    Li, Yishan
    Manoharan, Sathiamoorthy
    2013 IEEE PACIFIC RIM CONFERENCE ON COMMUNICATIONS, COMPUTERS AND SIGNAL PROCESSING (PACRIM), 2013, : 15 - 19
  • [50] Provenance-Aware NoSQL Databases
    Chacko, Anu Mary
    Fairooz, Munavar
    Kumar, S. D. Madhu
    SECURITY IN COMPUTING AND COMMUNICATIONS, SSCC 2016, 2016, 625 : 152 - 160