TY  - EJOU
AU  - ElDahshan, Kamal 
AU  - Selim, Eman 
AU  - Ebada, Ahmed Ismail 
AU  - Abouhawwash, Mohamed 
AU  - Nam, Yunyoung 
AU  - Behery, Gamal 

TI  - Handling Big Data in Relational Database Management Systems
T2  - Computers, Materials \& Continua

PY  - 2022
VL  - 72
IS  - 3
SN  - 1546-2226

AB  - Currently, relational database management systems (RDBMSs) face different challenges in application development due to the massive growth of unstructured and semi-structured data. This introduced new DBMS categories, known as not only structured query language (NoSQL) DBMSs, which do not adhere to the relational model. The migration from relational databases to NoSQL databases is challenging due to the data complexity. This study aims to enhance the storage performance of RDBMSs in handling a variety of data. The paper presents two approaches. The first approach proposes a convenient representation of unstructured data storage. Several extensive experiments were implemented to assess the efficiency of this approach that could result in substantial improvements in the RDBMSs storage. The second approach proposes using the JavaScript Object Notation (JSON) format to represent multivalued attributes and many to many (M:N) relationships in relational databases to create a flexible schema and store semi-structured data. The results indicate that the proposed approaches outperform similar approaches and improve data storage performance, which helps preserve software stability in huge organizations by improving existing software packages whose replacement may be highly costly.
KW  - Big data; RDBMS; NoSQL DBMSs; MongoDB; MySQL; unstructured data; semi-structured data

DO  - 10.32604/cmc.2022.028326