Working with Cassandra Database

  • Saurabh Anand
  • Pallavi Singh
  • B. M. Sagar
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 701)


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.


  1. 1.
    Hewitt, E.: The Definitive Guide, O’Reilly Media, 2nd edn. Cassandra (2016)Google Scholar
  2. 2.
    Abdi, D.: Problems with CAP and Yahoo’s little known NoSQL system, Yale University (2010)
  3. 3.
    Harrison, G.: Next Generation Databases, NoSQL, New SQL (2015)CrossRefGoogle Scholar
  4. 4.
    McMurtry, D., Oakley, A., Sharp, J., Subramanian, M., Zhang, H.: Data Access for Highly Scalable Solutions: Using SQL, NoSQL and Polyglot persistence (2013)Google Scholar
  5. 5.
    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)CrossRefGoogle Scholar
  6. 6.
    Eure, I.: Looking to the future with Cassandra, Sept (2009)
  7. 7.
    Date, C.J.: The New Relational Database Dictionary (2015)Google Scholar
  8. 8.
    Ellis, J., et. al.: Cassandra Gossiper Architecture (2010)
  9. 9.
    Coulouris, G., Dollimore, J., Kindberg, T.: Distributed Systems: Concepts and Design Addison Wesley (2005)Google Scholar

Copyright information

© Springer Nature Singapore Pte Ltd. 2018

Authors and Affiliations

  1. 1.J.C. PenneyBengaluruIndia
  2. 2.R.V College of EngineeringBengaluruIndia

Personalised recommendations