A performance comparison of SQL and NoSQL databases
The DOI matches its Crossref record; 15 of the 15 references it cites were found in a registry or an index.
Abstract
With the current emphasis on “Big Data”, NoSQL databases have surged in popularity. These databases are claimed to perform better than SQL databases. In this paper we aim to independently investigate the performance of some NoSQL and SQL databases in the light of key-value stores. We compare read, write, delete, and instantiate operations on key-value stores implemented by NoSQL and SQL databases. Besides, we also investigate an additional operation: iterating through all keys. An abstract key-value pair framework supporting these basic operations is designed and implemented using all the databases tested. Experimental results measure the timing of these operations and we summarize our findings of how the databases stack up against each other. Our results show that not all NoSQL databases perform better than SQL databases. Some are much worse. And for each database, the performance varies with each operation. Some are slow to instantiate, but fast to read, write, and delete. Others are fast to instantiate but slow on the other operations. And there is little correlation between performance and the data model each database uses.
Overview
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cites
Benchmarking cloud serving systems with YCSB
Cooper, B. F., Silberstein, A., Tam, E., Ramakrishnan, R., & Sears, R. (2010) · Proceedings of the 1st ACM symposium on Cloud computing · doi:10.1145/1807128.1807152 · Cited by 3,716
(2007) · doi:10.1145/1294261.1294281 · Cited by 3,447 · cited 1×
“The success of proprietary non-relational databases such as BigTable and Amazon’s Dynamo [7] initiated a number of other open-source and closed-source non-relational database developments.”
BackgroundBigtable: a distributed storage system for structured data
Chang, F. W., Dean, J. B., Ghemawat, S., Hsieh, W. C., Wallach, D. A., Burrows, M., Chandra, T., Fikes, A., & Gruber, R. E. (2006) · doi:10.5555/1298455.1298475 · Cited by 1,928
Han, J., Haihong, E., Le, G., & Du, J. (2011) · 2011 6th International Conference on Pervasive Computing and Applications · doi:10.1109/icpca.2011.6106531 · Cited by 617
Will NoSQL Databases Live Up to Their Promise?
Leavitt, N. (2010) · Computer · doi:10.1109/mc.2010.58 · Cited by 504
Chodorow, K., & Dirolf, M. (2010) · CERN Document Server (European Organization for Nuclear Research) · Cited by 460
A Survey of Large Scale Data Management Approaches in Cloud Environments
Sakr, S., Liu, A., Batista, D. M., & Alomari, M. (2011) · IEEE Communications Surveys & Tutorials · doi:10.1109/surv.2011.032211.00087 · Cited by 424
George, L. (2011) · Cited by 382
NoSQL evaluation: A use case oriented survey
Hecht, R., & Jablonski, S. (2011) · International Conference on Cloud and Service Computing (CSC) · doi:10.1109/csc.2011.6138544 · Cited by 309
A comparison between several NoSQL databases with comments and notes
Tudorica, B. G., & Bucur, C. (2011) · 2011 RoEduNet International Conference 10th Edition: Networking in Education and Research · doi:10.1109/roedunet.2011.5993686 · Cited by 229
Anderson, J., Lehnardt, J., & Slater, N. (2010) · Cited by 177
MongoDB vs Oracle -- Database Comparison
Boicea, A., Radulescu, F., & Agapin, L. I. (2012) · 2012 Third International Conference on Emerging Intelligent Data and Web Technologies · doi:10.1109/eidwt.2012.32 · Cited by 158
Cassandra: The Definitive Guide
Carpenter, J., & Hewitt, E. (2010) · Cited by 138
Database Research: Are We at a Crossroad? Reflection on NoSQL
Indrawan, M. (2012) · International Conference on Network-Based Information Systems · doi:10.1109/nbis.2012.95 · Cited by 61
Warden, P. (2011) · CERN Document Server (European Organization for Nuclear Research) · Cited by 34
Cited by
Design and Implementation of Open LoRa for IoT
Zhou, Q., Zheng, K., Hou, L., Xing, J., & Xu, R. (2019) · IEEE Access · doi:10.1109/access.2019.2930243 · Cited by 181
“However, the main bottleneck of SQL database is the inefficiency in handling high concurrent read and write which often happens in real-time IoT applications [19].”
BackgroundKhan, W., Kumar, T., Zhang, C., Raj, K., Roy, A. M., & Luo, B. (2023) · Big Data and Cognitive Computing · doi:10.3390/bdcc7020097 · Cited by 143
“In order to reduce cloud consumer effort during data movement across many cloud platforms and to exert control over data interoperability and portability concerns, the state of the art requires unified API [134,135,138] frameworks.”
BackgroundSQL, NewSQL, and NOSQL Databases: A Comparative Survey
Khasawneh, T. N., AL-Sahlee, M. H., & Safia, A. A. (2020) · 2020 11th International Conference on Information and Communication Systems (ICICS) · doi:10.1109/icics49469.2020.239513 · Cited by 63
Metadata
- Authors
- Li, Y., & Manoharan, S.
- Venue
- 2013 IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM)
- Publisher
- IEEE
- Published
- 2013-08
- Pages
- 15-19
- OpenAlex
- W1995751017
- Cited by
- 262
- References
- 15
- FWCI
- 12.57
- Type
- conference paper
- Language
- en
- Open access
- closed
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.