SQL or NoSQL? Performance and scalability evaluation
by Veronika Abramova; Jorge Bernardino; Pedro Furtado
International Journal of Business Process Integration and Management (IJBPIM), Vol. 7, No. 4, 2015

Abstract: The big data era brought a set of new database features, such as parallel execution of requests and data distribution among different nodes as well as new types of databases. NoSQL technology emerged to aid people and companies to easily scale systems with simple and transparent data distribution. It became possible to cope with higher demand in less time while performing different types of operations and storing large amounts of data. In this paper, we evaluate Cassandra's scalability and execution time of CRUD operations and, posteriorly, compare one relational and one non-relational system by evaluating their performance during execution of decision support queries. For that purpose, we used two standard benchmarks, Yahoo! Cloud Serving Benchmark, to evaluate execution time of requests and speedup of Cassandra, and Star-Schema Benchmark, to run queries over MySQL cluster, as relational database, and Hadoop with Hive as non-SQL counterpart. We conclude about the capabilities and limitations of those systems.

Online publication date: Tue, 15-Dec-2015

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Process Integration and Management (IJBPIM):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com