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] Comparative Study Between the MySQL Relational Database and the MongoDB NoSQL Database
    Matallah, Houcine
    Belalem, Ghalem
    Bouamrane, Karim
    INTERNATIONAL JOURNAL OF SOFTWARE SCIENCE AND COMPUTATIONAL INTELLIGENCE-IJSSCI, 2021, 13 (03): : 38 - 63
  • [22] BigDimETL with NoSQL Database
    Mallek, Hana
    Ghozzi, Faiza
    Teste, Olivier
    Gargouri, Faiez
    KNOWLEDGE-BASED AND INTELLIGENT INFORMATION & ENGINEERING SYSTEMS (KES-2018), 2018, 126 : 798 - 807
  • [23] Mortadelo: A Model-Driven Framework for NoSQL Database Design
    de la Vega, Alfonso
    Garcia-Saiz, Diego
    Blanco, Carlos
    Zorrilla, Marta
    Sanchez, Pablo
    MODEL AND DATA ENGINEERING, MEDI 2018, 2018, 11163 : 41 - 57
  • [24] Conceptual Design of Document NoSQL Database with Formal Concept Analysis
    Varga, Viorica
    Janosi-Rancz, Katalin Tuende
    Kalman, Balazs
    ACTA POLYTECHNICA HUNGARICA, 2016, 13 (02) : 229 - 248
  • [25] Schema design advisor model for RDBMS to NoSQL database migration
    Namdeo B.
    Suman U.
    International Journal of Information Technology, 2021, 13 (1) : 277 - 286
  • [26] Form and Substance in Physical Database Design: An Empirical Study
    Prietula, Michael J.
    March, Salvatore T.
    INFORMATION SYSTEMS RESEARCH, 1991, 2 (04) : 287 - 314
  • [27] Analysis and study on the performance of query based on NOSQL database
    Qi, Yan, 1600, Transport and Telecommunication Institute, Lomonosova street 1, Riga, LV-1019, Latvia (18):
  • [28] An Exploratory Study of a NoSQL Database for a Clinical Data Repository
    Hak, Francini
    Guimaraes, Tiago
    Abelha, Antonio
    Santos, Manuel
    TRENDS AND INNOVATIONS IN INFORMATION SYSTEMS AND TECHNOLOGIES, VOL 3, 2020, 1161 : 476 - 483
  • [29] Symbolic Execution of NoSQL Applications using Versioned Schemas
    Winkelmann, Hendrik
    Kuchen, Herbert
    36TH ANNUAL ACM SYMPOSIUM ON APPLIED COMPUTING, SAC 2021, 2021, : 1778 - 1787
  • [30] Comparative analysis of the semantic models used to design database schemas
    Babanov, A. M.
    TOMSK STATE UNIVERSITY JOURNAL, 2006, (290): : 251 - +
12345