Comparison of SQL and NoSQL databases with different workloads: MongoDB vs MySQL evaluation
Date Issued
2022-10-25
Author(s)
Capris, Ticiana
Melo, Pedro
M Garcia, Nuno
Pires, Ivan Miguel
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.
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.
Subjects
File(s)![Thumbnail Image]()
Loading...
Name
1570847213stamped-e.pdf
Size
783.73 KB
Format
Adobe PDF
Checksum
(MD5):72f191d96c556dee515c9bbe8fcd12ca