The Use Case of Relational and Non-relational Database
Keywords:
SQL, NoSQL, data, digital, relational database, non-relational databaseAbstract
The digital revolution has unleashed vast data collection by digital service providers, driving businesses to undergo digital transformation. Intelligent data integration is crucial for this transformation. A reliable database is essential for efficient data reading and writing. Each type of database suits specific use cases, such as relational databases for structured data and NoSQL databases for flexibility. Time-series databases handle time-stamped data, while graph databases manage complex relationships. In-memory databases provide real-time processing, and distributed databases offer scalability. Understanding database suitability is vital for thriving in the data-driven era.
References
Ongo G, Kusuma GP. Hybrid database system of MySQL and MongoDB in web application development. In2018 international conference on information management and technology (ICIMTech) 2018 Sep 3 (pp. 256–260). IEEE.
SQL - Overview. Tutorialspoint.com. 2023. Available from: https://www.tutorialspoint.com/sql/
sql-overview.htm
Dzsquared. Tutorial: Design your first relational database using SSMS - Azure SQL Database. Microsoft.com. 2023. Available from: https://learn.microsoft.com/en-us/azure/azure-sql/database/design-first-database-tutorial?view=azuresql-db&viewFallbackFrom=azuresq
Li Y, Manoharan S. A performance comparison of SQL and NoSQL databases. In2013 IEEE Pacific Rim conference on communications, computers and signal processing (PACRIM) 2013 Aug 27 (pp. 15–19). IEEE.
SQL vs. NoSQL Databases: What’s the Difference?. Ibm.com. 2022. Available from: https://www.ibm.com/cloud/blog/sql-vs-nosql
RenHe L, Wongkittisuksa B. The study of arm joint angle movement using one-channel and multi-frequency bio-impedance measurement. In2017 International Electrical Engineering Congress (iEECON) 2017 Mar 8 (pp. 1–4). IEEE.
Martinekuan. Non-relational data and NoSQL - Azure Architecture Center. Microsoft.com. 2023. Available from: https://learn.microsoft.com/en-us/azure/architecture/data-guide/big-data/non-relational-data
Gupta A, Tyagi S, Panwar N, Sachdeva S, Saxena U. NoSQL databases: Critical analysis and comparison. In2017 International conference on computing and communication technologies for smart nation (IC3TSN) 2017 Oct 12 (pp. 293–299). IEEE.
Wang R, Yang Z. SQL vs NoSQL: A Performance Comparison. University of Rochester. 2017.
Padhy S, Kumaran GM. A quantitative performance analysis between Mongodb and Oracle NoSQL. In2019 6th international conference on computing for sustainable global development (INDIACom) 2019 Mar 13 (pp. 387–391). IEEE.
SQL vs NoSQL - javatpoint. www.javatpoint.com. 2023. Available from: https://www.javatpo
int.com/sql-vs-nosql
