How to Choose the Right Database for Your Application

Authors

  • Nagaraju Thallapally  University of Missouri Kansas City Missouri, United States

DOI:

https://doi.org/10.32628/CSEIT239074

Keywords:

Database, Right Database, Speed, Scale, Success, Application, Relational Databases.

Abstract

Choose the right database; it is a very important choice that determines the speed, scale, and success of any application or system. Various databases now exist with a growing variety, from relational databases to newer NoSQL databases, so development teams, system architects, and business users need to do some homework to find the one that is right for them. In this article, I will show decision-makers how to select the right database based on data structure, scalability, transaction size, consistency, and performance. This article explains what to consider when selecting a database type and contrasts the types.

References

  1. Codd, E. F. (1970). 'A Relational Model of Data for Large Shared DataBanks.' Communications of the ACM, 13(6), 377-387.
  2. Stonebraker, M.(2010). 'The Case for Vertical Integration in the Database Market.' ACM SIGMOD Record, 39(4), 8-13.
  3. Chang, P., DeWitt, D. J. (2005). 'Database Design for Next-Generation Applications.' Proceedings of the VLDB Endowment, 4(12), 2002-2013.
  4. Hassan, A., Nassar, A. (2017). 'A Comparative Analysis of NoSQLDatabases.' International Journal of Computer Applications, 161(7), 1-6.
  5. Liu, Z., Li, C. (2016). 'NoSQL Databases: A Survey and Decision Guidance.' International Journal of Computer Science and Information Security, 14(6), 119-125.
  6. Chodorow, K., Dirolf, M. (2019). MongoDB: The Definitive Guide.O’Reilly Media.
  7. Iyer, B., Williams, S. (2013). Database Management Systems. McGraw-Hill.
  8. Abadi, D. J., Boncz, P. A. (2009). 'The Design and Implementation of Modern Column-Oriented Database Systems.' Foundations and Trends in Databases, 5(3), 59-171.
  9. NoSQL Database Tutorial (2015). 'Introduction to NoSQL Databases.'TechVidvan.
  10. Mowery, R. (2017). Redis Essentials. Packt Publishing.
  11. Ousterhout, J. K., Noyes, A. (2012). 'Key-Value Stores and their Usein Distributed Systems.' Journal of Computer Science, 48(3), 227-237.
  12. Lomet, D., O’Neil, P. (2000). 'Database Management Systems: A Contemporary Perspective.' ACM Computing Surveys, 32(2), 200-229.
  13. Mendelzon, A., Hristidis, V. (2004). 'Graph Databases: Querying Complex Relationships.' IEEE Transactions on Knowledge and Data Engineering, 16(4), 448-460.
  14. Robbins, S., Schafer, J. (2014). 'Cassandra: The Definitive Guide.'O’Reilly Media.
  15. Bharadwaj, A., Chawla, N. (2018). 'Graph Databases for Real-WorldApplications.' Proceedings of the International Database Engineering Applications Symposium.
  16. Soni, R., Gupta, M. (2020). 'Time-Series Databases for IoT Systems.'Journal of Computing and Technology, 44(5), 125-137.
  17. Kimball, R., Ross, M. (2013). The Data Warehouse Toolkit. Wiley.
  18. Chang, Y., Zhuang, X. (2011). 'Big Data Management and Storage
  19. with NoSQL Databases.' International Journal of Computer Applications, 30(6), 112-120.
  20. Buys, R., Olivas, R. (2019). 'Evaluating Cost Models for DatabaseManagement Systems.' Proceedings of the Data Engineering Conference.
  21. Bansal, A. (2023). Optimizing RAG with Hybrid Search and ContextualChunking. In Journal of Engineering and Applied Sciences Technology (pp. 1–5). ScientificResearchandCommunityLtd. https://doi.org/10.47363/jeast/2023(5)e114
  22. Stonebraker, M., Hellerstein, J. M. (2001). 'The Architecture of Next Generation Database Systems.' ACM Computing Surveys, 33(4), 300-320.
  23. Elmasri, R., Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson
  24. Cattell, R. (2011). Scalable SQL and NoSQL Data Stores. ACM Computing Surveys, 43(2), 1-42.
  25. Stonebraker, M., Cattell, R. (2016). The End of an Architectural Era:(It’s Time for a Complete Rewrite). ACM SIGMOD Record, 44(4), 17-24.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2023-10-30

Issue

Volume 9, Issue 5, September-October-2023

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Nagaraju Thallapally, " How to Choose the Right Database for Your Application" International Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 9, Issue 5, pp.414-418, September-October-2023. Available at doi : https://doi.org/10.32628/CSEIT239074