Comparison between relational and NOSQL databases

Kosovare Sahatqija; Jaumin Ajdari; Xhemal Zenuni; Bujar Raufi; Florije Ismaili

doi:10.23919/MIPRO.2018.8400041

Comparison between relational and NOSQL databases

Kosovare Sahatqija, Jaumin Ajdari, Xhemal Zenuni, Bujar Raufi, Florije Ismaili

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

Abstract

The relational database is provided from the traditional DBMS, which ensures the integrity of data and consistency of transactions. For many software applications, these are the principles of a proper DBMS. But in the last few years, witnessing the velocity of data growth and the lack of support from traditional databases for this issue, as a solution to it, the NoSQL (Not Only SQL) databases have appeared. These two kinds while being used for the same purposes (create, retrieve, update and manage data) they both have their own advantages and disadvantages over each other. The purpose of this study is to try and compare the research question of what are the pros and cons for each of these database' features and characteristics? This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years.

Original language	English
Title of host publication	2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings
Editors	Boris Vrdoljak, Edvard Tijan, Tihana Galinac Grbac, Vlado Sruk, Marina Cicin-Sain, Slobodan Ribaric, Karolj Skala, Marko Koricic, Mladen Mauher, Stjepan Gros, Predrag Pale, Matej Janjic
Publisher	Institute of Electrical and Electronics Engineers Inc.
Pages	216-221
Number of pages	6
ISBN (Electronic)	9789532330977
DOIs	https://doi.org/10.23919/MIPRO.2018.8400041
Publication status	Published - 28 Jun 2018
Externally published	Yes
Event	41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Opatija, Croatia Duration: 21 May 2018 → 25 May 2018

Publication series

Name	2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings

Conference

Conference	41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018
Country/Territory	Croatia
City	Opatija
Period	21/05/18 → 25/05/18

Keywords

ACID properties
BASE properties
Big Data
NoSQL
Relational Databases

Access to Document

10.23919/MIPRO.2018.8400041

Cite this

Sahatqija, K., Ajdari, J., Zenuni, X., Raufi, B., & Ismaili, F. (2018). Comparison between relational and NOSQL databases. In B. Vrdoljak, E. Tijan, T. G. Grbac, V. Sruk, M. Cicin-Sain, S. Ribaric, K. Skala, M. Koricic, M. Mauher, S. Gros, P. Pale, & M. Janjic (Eds.), 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings (pp. 216-221). (2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.23919/MIPRO.2018.8400041

Sahatqija, Kosovare ; Ajdari, Jaumin ; Zenuni, Xhemal et al. / Comparison between relational and NOSQL databases. 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings. editor / Boris Vrdoljak ; Edvard Tijan ; Tihana Galinac Grbac ; Vlado Sruk ; Marina Cicin-Sain ; Slobodan Ribaric ; Karolj Skala ; Marko Koricic ; Mladen Mauher ; Stjepan Gros ; Predrag Pale ; Matej Janjic. Institute of Electrical and Electronics Engineers Inc., 2018. pp. 216-221 (2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings).

@inproceedings{12ca84568e904b1abdaf9cea834ad65f,

title = "Comparison between relational and NOSQL databases",

abstract = "The relational database is provided from the traditional DBMS, which ensures the integrity of data and consistency of transactions. For many software applications, these are the principles of a proper DBMS. But in the last few years, witnessing the velocity of data growth and the lack of support from traditional databases for this issue, as a solution to it, the NoSQL (Not Only SQL) databases have appeared. These two kinds while being used for the same purposes (create, retrieve, update and manage data) they both have their own advantages and disadvantages over each other. The purpose of this study is to try and compare the research question of what are the pros and cons for each of these database' features and characteristics? This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years.",

keywords = "ACID properties, BASE properties, Big Data, NoSQL, Relational Databases",

author = "Kosovare Sahatqija and Jaumin Ajdari and Xhemal Zenuni and Bujar Raufi and Florije Ismaili",

note = "Publisher Copyright: {\textcopyright} 2018 Croatian Society MIPRO.; 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 ; Conference date: 21-05-2018 Through 25-05-2018",

year = "2018",

month = jun,

day = "28",

doi = "10.23919/MIPRO.2018.8400041",

language = "English",

series = "2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

pages = "216--221",

editor = "Boris Vrdoljak and Edvard Tijan and Grbac, \{Tihana Galinac\} and Vlado Sruk and Marina Cicin-Sain and Slobodan Ribaric and Karolj Skala and Marko Koricic and Mladen Mauher and Stjepan Gros and Predrag Pale and Matej Janjic",

booktitle = "2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings",

address = "United States",

}

Sahatqija, K, Ajdari, J, Zenuni, X, Raufi, B & Ismaili, F 2018, Comparison between relational and NOSQL databases. in B Vrdoljak, E Tijan, TG Grbac, V Sruk, M Cicin-Sain, S Ribaric, K Skala, M Koricic, M Mauher, S Gros, P Pale & M Janjic (eds), 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings. 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings, Institute of Electrical and Electronics Engineers Inc., pp. 216-221, 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018, Opatija, Croatia, 21/05/18. https://doi.org/10.23919/MIPRO.2018.8400041

Comparison between relational and NOSQL databases. / Sahatqija, Kosovare; Ajdari, Jaumin; Zenuni, Xhemal et al.
2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings. ed. / Boris Vrdoljak; Edvard Tijan; Tihana Galinac Grbac; Vlado Sruk; Marina Cicin-Sain; Slobodan Ribaric; Karolj Skala; Marko Koricic; Mladen Mauher; Stjepan Gros; Predrag Pale; Matej Janjic. Institute of Electrical and Electronics Engineers Inc., 2018. p. 216-221 (2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Comparison between relational and NOSQL databases

AU - Sahatqija, Kosovare

AU - Ajdari, Jaumin

AU - Zenuni, Xhemal

AU - Raufi, Bujar

AU - Ismaili, Florije

PY - 2018/6/28

Y1 - 2018/6/28

N2 - The relational database is provided from the traditional DBMS, which ensures the integrity of data and consistency of transactions. For many software applications, these are the principles of a proper DBMS. But in the last few years, witnessing the velocity of data growth and the lack of support from traditional databases for this issue, as a solution to it, the NoSQL (Not Only SQL) databases have appeared. These two kinds while being used for the same purposes (create, retrieve, update and manage data) they both have their own advantages and disadvantages over each other. The purpose of this study is to try and compare the research question of what are the pros and cons for each of these database' features and characteristics? This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years.

AB - The relational database is provided from the traditional DBMS, which ensures the integrity of data and consistency of transactions. For many software applications, these are the principles of a proper DBMS. But in the last few years, witnessing the velocity of data growth and the lack of support from traditional databases for this issue, as a solution to it, the NoSQL (Not Only SQL) databases have appeared. These two kinds while being used for the same purposes (create, retrieve, update and manage data) they both have their own advantages and disadvantages over each other. The purpose of this study is to try and compare the research question of what are the pros and cons for each of these database' features and characteristics? This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years.

KW - ACID properties

KW - BASE properties

KW - Big Data

KW - NoSQL

KW - Relational Databases

UR - https://www.scopus.com/pages/publications/85050214894

U2 - 10.23919/MIPRO.2018.8400041

DO - 10.23919/MIPRO.2018.8400041

M3 - Conference contribution

AN - SCOPUS:85050214894

T3 - 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings

SP - 216

EP - 221

BT - 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings

A2 - Vrdoljak, Boris

A2 - Tijan, Edvard

A2 - Grbac, Tihana Galinac

A2 - Sruk, Vlado

A2 - Cicin-Sain, Marina

A2 - Ribaric, Slobodan

A2 - Skala, Karolj

A2 - Koricic, Marko

A2 - Mauher, Mladen

A2 - Gros, Stjepan

A2 - Pale, Predrag

A2 - Janjic, Matej

PB - Institute of Electrical and Electronics Engineers Inc.

T2 - 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018

Y2 - 21 May 2018 through 25 May 2018

ER -

Sahatqija K, Ajdari J, Zenuni X, Raufi B, Ismaili F. Comparison between relational and NOSQL databases. In Vrdoljak B, Tijan E, Grbac TG, Sruk V, Cicin-Sain M, Ribaric S, Skala K, Koricic M, Mauher M, Gros S, Pale P, Janjic M, editors, 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings. Institute of Electrical and Electronics Engineers Inc. 2018. p. 216-221. (2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2018 - Proceedings). doi: 10.23919/MIPRO.2018.8400041

Comparison between relational and NOSQL databases

Abstract

Publication series

Conference

Keywords

Access to Document

Fingerprint

Cite this