Open Access iconOpen Access

REVIEW

crossmark

A Systematic Review of Automated Classification for Simple and Complex Query SQL on NoSQL Database

Nurhadi, Rabiah Abdul Kadir*, Ely Salwana Mat Surin, Mahidur R. Sarker*

Institute of Visual Informatics, The National University of Malaysia, Selangor, 43600, Malaysia

* Corresponding Authors: Rabiah Abdul Kadir. Email: email; Mahidur R. Sarker. Email: email

Computer Systems Science and Engineering 2024, 48(6), 1405-1435. https://doi.org/10.32604/csse.2024.051851

Abstract

A data lake (DL), abbreviated as DL, denotes a vast reservoir or repository of data. It accumulates substantial volumes of data and employs advanced analytics to correlate data from diverse origins containing various forms of semi-structured, structured, and unstructured information. These systems use a flat architecture and run different types of data analytics. NoSQL databases are nontabular and store data in a different manner than the relational table. NoSQL databases come in various forms, including key-value pairs, documents, wide columns, and graphs, each based on its data model. They offer simpler scalability and generally outperform traditional relational databases. While NoSQL databases can store diverse data types, they lack full support for atomicity, consistency, isolation, and durability features found in relational databases. Consequently, employing machine learning approaches becomes necessary to categorize complex structured query language (SQL) queries. Results indicate that the most frequently used automatic classification technique in processing SQL queries on NoSQL databases is machine learning-based classification. Overall, this study provides an overview of the automatic classification techniques used in processing SQL queries on NoSQL databases. Understanding these techniques can aid in the development of effective and efficient NoSQL database applications.

Keywords


Cite This Article

APA Style
Nurhadi, , Kadir, R.A., Surin, E.S.M., Sarker, M.R. (2024). A systematic review of automated classification for simple and complex query SQL on nosql database. Computer Systems Science and Engineering, 48(6), 1405-1435. https://doi.org/10.32604/csse.2024.051851
Vancouver Style
Nurhadi , Kadir RA, Surin ESM, Sarker MR. A systematic review of automated classification for simple and complex query SQL on nosql database. Comput Syst Sci Eng. 2024;48(6):1405-1435 https://doi.org/10.32604/csse.2024.051851
IEEE Style
Nurhadi, R.A. Kadir, E.S.M. Surin, and M.R. Sarker, “A Systematic Review of Automated Classification for Simple and Complex Query SQL on NoSQL Database,” Comput. Syst. Sci. Eng., vol. 48, no. 6, pp. 1405-1435, 2024. https://doi.org/10.32604/csse.2024.051851



cc Copyright © 2024 The Author(s). Published by Tech Science Press.
This work is licensed under a Creative Commons Attribution 4.0 International License , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
  • 1753

    View

  • 414

    Download

  • 0

    Like

Share Link