Abstract
Traditional databases cannot handle a huge amount of data. NoSQL database like Cassandra can handle large data with easier management and lower cost compared to SQL databases like Oracle and other relational databases. Cassandra is an open source technology. This paper explains how Cassandra helps in handling large data efficiently with almost 30–35% more efficient than the relational database like Oracle when data size increases to ten thousand and beyond. For this, the paper explains an experiment which was carried out by varying the size of number of data records and comparing the performance of Cassandra and Oracle. As the data size was continuously increased, most of the Cassandra queries took almost 30–35% less time as compared to Oracle. Though Oracle was more efficient when data size was less (up to 40 × 103 records), the performance dropped thereafter continuously for every 10 × 103 increase in data size thereafter.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Hewitt, E.: The Definitive Guide, O’Reilly Media, 2nd edn. Cassandra (2016)
Abdi, D.: Problems with CAP and Yahoo’s little known NoSQL system http://dbmsmusings.blogspot.com/2010/04/problems-with-cap-and-yahoos-little.html, Yale University (2010)
Harrison, G.: Next Generation Databases, NoSQL, New SQL (2015)
McMurtry, D., Oakley, A., Sharp, J., Subramanian, M., Zhang, H.: Data Access for Highly Scalable Solutions: Using SQL, NoSQL and Polyglot persistence (2013)
Rabl, T., Gómez-Villamor, S., Sadoghi, M., Muntés-Mulero, V., Jacobsen, H.A., Mankovskii, S.: Solving big data challenges for enterprise application performance management. Proc. VLDB Endow. 5(12), 1724–1735 (2012)
Eure, I.: Looking to the future with Cassandra http://about.digg.com/blog/looking-future-cassandra, Sept (2009)
Date, C.J.: The New Relational Database Dictionary (2015)
Ellis, J., et. al.: Cassandra Gossiper Architecture http://wiki.apache.org/cassandra/ArchitectureGossip (2010)
Coulouris, G., Dollimore, J., Kindberg, T.: Distributed Systems: Concepts and Design Addison Wesley (2005)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Anand, S., Singh, P., Sagar, B.M. (2018). Working with Cassandra Database. In: Satapathy, S., Tavares, J., Bhateja, V., Mohanty, J. (eds) Information and Decision Sciences. Advances in Intelligent Systems and Computing, vol 701. Springer, Singapore. https://doi.org/10.1007/978-981-10-7563-6_55
Download citation
DOI: https://doi.org/10.1007/978-981-10-7563-6_55
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-7562-9
Online ISBN: 978-981-10-7563-6
eBook Packages: EngineeringEngineering (R0)