Designing NoSQL databases based on multiple requirement views

Noa Roy-Hubara; Arnon Sturm; Peretz Shoval

doi:10.1016/j.datak.2023.102149

Designing NoSQL databases based on multiple requirement views

Noa Roy-Hubara, Arnon Sturm, Peretz Shoval

Department of Software and Information Systems Engineering

Research output: Contribution to journal › Article › peer-review

7 Scopus citations

Abstract

In recent years, new data characteristics led to the development of new database management systems named NoSQL. As opposed to the mature Relational databases, design methods for the new databases receive little attention and mainly consider the data-related requirements. In this paper, we present methods for designing two types of NoSQL databases – Document and Graph databases – that consider not only the data-related but also functional-related requirements. We empirically evaluate the methods and apply the design methods to two leading database systems. We found that the databases designed with the consideration of functional requirements perform better, with respect to time of execution and database I/O operations, compared to when designed without considering them.

Original language	English
Article number	102149
Journal	Data and Knowledge Engineering
Volume	145
DOIs	https://doi.org/10.1016/j.datak.2023.102149
State	Published - 1 May 2023

Keywords

Conceptual modeling
Database design
Document Database
Graph database
NoSQL
User requirements

ASJC Scopus subject areas

Information Systems and Management

Access to Document

10.1016/j.datak.2023.102149

Cite this

@article{afe52c834ae64a0497ff676127d05645,

title = "Designing NoSQL databases based on multiple requirement views",

abstract = "In recent years, new data characteristics led to the development of new database management systems named NoSQL. As opposed to the mature Relational databases, design methods for the new databases receive little attention and mainly consider the data-related requirements. In this paper, we present methods for designing two types of NoSQL databases – Document and Graph databases – that consider not only the data-related but also functional-related requirements. We empirically evaluate the methods and apply the design methods to two leading database systems. We found that the databases designed with the consideration of functional requirements perform better, with respect to time of execution and database I/O operations, compared to when designed without considering them.",

keywords = "Conceptual modeling, Database design, Document Database, Graph database, NoSQL, User requirements",

author = "Noa Roy-Hubara and Arnon Sturm and Peretz Shoval",

note = "Publisher Copyright: {\textcopyright} 2023 Elsevier B.V.",

year = "2023",

month = may,

day = "1",

doi = "10.1016/j.datak.2023.102149",

language = "English",

volume = "145",

journal = "Data and Knowledge Engineering",

issn = "0169-023X",

publisher = "Elsevier",

}

TY - JOUR

T1 - Designing NoSQL databases based on multiple requirement views

AU - Roy-Hubara, Noa

AU - Sturm, Arnon

AU - Shoval, Peretz

PY - 2023/5/1

Y1 - 2023/5/1

N2 - In recent years, new data characteristics led to the development of new database management systems named NoSQL. As opposed to the mature Relational databases, design methods for the new databases receive little attention and mainly consider the data-related requirements. In this paper, we present methods for designing two types of NoSQL databases – Document and Graph databases – that consider not only the data-related but also functional-related requirements. We empirically evaluate the methods and apply the design methods to two leading database systems. We found that the databases designed with the consideration of functional requirements perform better, with respect to time of execution and database I/O operations, compared to when designed without considering them.

AB - In recent years, new data characteristics led to the development of new database management systems named NoSQL. As opposed to the mature Relational databases, design methods for the new databases receive little attention and mainly consider the data-related requirements. In this paper, we present methods for designing two types of NoSQL databases – Document and Graph databases – that consider not only the data-related but also functional-related requirements. We empirically evaluate the methods and apply the design methods to two leading database systems. We found that the databases designed with the consideration of functional requirements perform better, with respect to time of execution and database I/O operations, compared to when designed without considering them.

KW - Conceptual modeling

KW - Database design

KW - Document Database

KW - Graph database

KW - NoSQL

KW - User requirements

UR - http://www.scopus.com/inward/record.url?scp=85149772091&partnerID=8YFLogxK

U2 - 10.1016/j.datak.2023.102149

DO - 10.1016/j.datak.2023.102149

M3 - Article

AN - SCOPUS:85149772091

SN - 0169-023X

VL - 145

JO - Data and Knowledge Engineering

JF - Data and Knowledge Engineering

M1 - 102149

ER -

Designing NoSQL databases based on multiple requirement views

Abstract

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Studies from Ben-Gurion University of the Negev Describe New Findings in Information Technology (Designing Nosql Databases Based On Multiple Requirement Views)

Cite this

Designing NoSQL databases based on multiple requirement views

Abstract

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Press/Media

Studies from Ben-Gurion University of the Negev Describe New Findings in Information Technology (Designing Nosql Databases Based On Multiple Requirement Views)

Cite this