An Empirical Study on the Design and Evolution of NoSQL Database Schemas

被引：14
|
作者：
Scherzinger, Stefanie [1 ]
Sidortschuck, Sebastian [2 ]
机构：
[1] Univ Passau, Passau, Germany
[2] SPARETECH Io, Stuttgart, Germany
来源：
CONCEPTUAL MODELING, ER 2020 | 2020年 / 12400卷
关键词：
Schema evolution; NoSQL Databases; Empirical study;
D O I：
10.1007/978-3-030-62522-1_33
中图分类号：
TP39 [计算机的应用];
学科分类号：
081203 ; 0835 ;
摘要：
We study how software engineers design and evolve their domain model when building applications against NoSQL data stores. Specifically, we target Java projects that use object-NoSQL mappers to interface with schema-free NoSQL data stores. This is a popular software stack. Given the source code of ten real-world database applications, we extract the NoSQL database schema thus implied in the application code. We can confirm that schemas are generally denormalized, as is recommended practice in data modeling for NoSQL data stores. Further, we analyze the entire project history, and with it, the evolution history of the NoSQL database schema. We show that NoSQL schemas evolve in all analyzed projects, and observe a comparatively high frequency in schema changes. In doing so, we conduct the so far largest empirical study on NoSQL schema design and evolution.
引用
收藏
页码：441 / 455
页数：15
相关论文
共 50 条
  • [21] An Empirical Study of Local Database Usage in Android Applications
    Lyu, Yingjun
    Gui, Jiaping
    Wan, Mian
    Halfond, William G. J.
    2017 IEEE INTERNATIONAL CONFERENCE ON SOFTWARE MAINTENANCE AND EVOLUTION (ICSME), 2017, : 444 - 455
  • [22] Evaluation of container orchestration systems for deploying and managing NoSQL database clusters
    Truyen, Eddy
    Van Landuyt, Dimitri
    Lagaisse, Bert
    Joosen, Wouter
    Bruzek, Matt
    PROCEEDINGS 2018 IEEE 11TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING (CLOUD), 2018, : 468 - 475
  • [23] A Multi-Key Transactions Model for NoSQL Cloud Database Systems
    Ogunyadeka, Adewole
    Younas, Muhammad
    Zhu, Hong
    Aldea, Arantza
    PROCEEDINGS 2016 IEEE SECOND INTERNATIONAL CONFERENCE ON BIG DATA COMPUTING SERVICE AND APPLICATIONS (BIGDATASERVICE 2016), 2016, : 24 - 27
  • [24] A NoSQL Database Approach for Modeling Heterogeneous and Semi-Structured Information
    Vonitsanos, Gerasimos
    Kanavos, Andreas
    Mylonas, Phivos
    Sioutas, Spyros
    2018 9TH INTERNATIONAL CONFERENCE ON INFORMATION, INTELLIGENCE, SYSTEMS AND APPLICATIONS (IISA), 2018, : 296 - 303
  • [25] Remaining in Control of the Impact of Schema Evolution in NoSQL Databases
    Hillenbrand, Andrea
    Scherzinger, Stefanie
    Storl, Uta
    CONCEPTUAL MODELING, ER 2021, 2021, 13011 : 149 - 159
  • [26] Understanding database schema evolution: A case study
    Cleve, Anthony
    Gobert, Maxime
    Meurice, Loup
    Maes, Jerome
    Weber, Jens
    SCIENCE OF COMPUTER PROGRAMMING, 2015, 97 : 113 - 121
  • [27] Gamification and SQL: An Empirical Study on Student Performance in a Database Course
    Morales-Trujillo, Miguel Ehecatl
    Alberto Garcia-Mireles, Gabriel
    ACM TRANSACTIONS ON COMPUTING EDUCATION, 2021, 21 (01)
  • [28] Comparative Analysis of Relational Database Watermarking Techniques: An Empirical Study
    Rani, Sapana
    Halder, Raju
    IEEE ACCESS, 2022, 10 : 27970 - 27989
  • [29] NoSQL document data migration strategy in the context of schema evolution
    Fedushko, Solomiia
    Malyi, Roman
    Syerov, Yuriy
    Serdyuk, Pavlo
    DATA & KNOWLEDGE ENGINEERING, 2024, 154
  • [30] Evolutionary Database Design: Enhancing Data Abstraction Through Database Modularization to Achieve Graceful Schema Evolution
    Guedes, Gustavo Bartz
    Baioco, Gisele Busichia
    de Oliveira Moraes, Regina Lucia
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, DEXA 2016, PT I, 2016, 9827 : 355 - 369
12345