Please use this identifier to cite or link to this item:
http://hdl.handle.net/20.500.12188/27500
Title: | Comparison of SQL and NoSQL databases with different workloads: MongoDB vs MySQL evaluation | Authors: | Capris, Ticiana Melo, Pedro M Garcia, Nuno Pires, Ivan Miguel Zdravevski, Eftim |
Keywords: | Non-relational database, Database engines, SQL vs. NoSQL, big data | Issue Date: | 25-Oct-2022 | Publisher: | IEEE | Conference: | 2022 International Conference on Data Analytics for Business and Industry (ICDABI) | Abstract: | One of the most important considerations when selecting a database is how relational (SQL) and non-relational (NoSQL) data structures will interact. While all options are viable, consumers should take certain distinctions into account before choosing. Since SQL databases are vertically scalable, you can typically scale server components like CPU, RAM, or SSD. NoSQL databases, on the other hand, support horizontal scaling. As a result, you can increase the capacity of your NoSQL database by fragmenting (data partitioning), or by adding extra servers. Why, then, is it still challenging to choose the instance that is most appropriate for a given application and requires the least amount of runtime? Because data that will be conveyed via the internet uses a cloud in computer networks as a metaphor. To determine which model to utilize, it is required to conduct a comparison study of SQL-oriented database engines. SQL has a form created for another side of non-productive data and is offered in the form of ordered data, but NoSQL databases are horizontally expandable. Workload management solutions are therefore also in charge of automating organizational procedures, i.e., they carry out activities without requiring manual employee attendance. For businesses trying to implement continuous delivery methods and enhance the effectiveness of customer service delivery, they are unavoidable. | URI: | http://hdl.handle.net/20.500.12188/27500 |
Appears in Collections: | Faculty of Computer Science and Engineering: Conference papers Faculty of Computer Science and Engineering: Conference papers |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
1570847213stamped-e.pdf | 783.73 kB | Adobe PDF | View/Open |
Page view(s)
24
checked on Jul 24, 2024
Download(s)
3
checked on Jul 24, 2024
Google ScholarTM
Check
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.