SQL and NOSQL Databases in the Application of Business Analytics

SQL and NOSQL Databases in the Application of Business Analytics

연구 분야: Databases

학회: 2023 International Conference on Computer Science and Emerging Technologies (CSET)

Data is the source for decision making in the several organizations. Decision making comes from the careful analysis of the data. Business analytics is the area it focuses on gaining the business insights with the help of tools and techniques by analysing the data. This paper outline the data storage architecture for SQL and NoSQL. Further, this paper describes the difference between the relational databases and non-relational databases. There are many relational database management systems are available those are oracle, mysql, IBM DB2 etc., likewise non-relational database management systems are Cassandra, Redis, Mongo, GraphQ1 etc., NoSQL is a genetic name indicating Not only structured query language. NoSQL is not aligned with the relational database model but still it is used widely in the industry. One of the main objective of this paper was performance analysis in the query languages such as SQL and NoSQL. Comparative analysis also outlines the advantages and disadvantages of the relational and non-relational databases. A comprehensive discussion is outlined in the results section.