DATABASE DILEMMA: NAVIGATING THE SEA OF CHOICES TO FIND YOUR PERFECT FIT
Keywords:
Database Selection, NoSQL Vs SQL, Analytical Database, Scalability, PerformanceAbstract
The rapid growth of data and the emergence of diverse database solutions have made database selection a critical aspect of software development. This article presents a structured methodology for choosing the right database based on an organization's requirements and use cases. The proposed approach consists of five key steps: defining project requirements, identifying core database features, evaluating available database options, prioritizing and eliminating candidates, and conducting proof of concepts or benchmarks. Organizations can navigate the complex landscape of database options by considering data volume, performance expectations, scalability, and deployment models. The article highlights the importance of aligning the selected database with the application's specific needs to ensure optimal performance and cost-effectiveness.
References
D. Reinsel, J. Gantz, and J. Rydning, "The Digitization of the World From Edge to Core," IDC White Paper, Nov. 2018.
R. Cattell, "Scalable SQL and NoSQL data stores," ACM SIGMOD Record, vol. 39, no. 4, 2011.
A. Pavlo and M. Aslett, "What's Really New with NewSQL?," ACM SIGMOD Record, vol. 45, no. 2, 2016.
FirstMark. (2024). The 2024 MAD (ML, AI & Data) Landscape. Retrieved from https://mad.firstmark.com/
S. Chaudhuri and V. Narasayya, "Self-tuning database systems: A decade of progress," VLDB, 2007.
AltexSoft, “Unstructured Data: Understanding the Benefits and Challenges,” 2023. [Online]. Available: https://www.altexsoft.com/blog/unstructured-data/.
M. Stonebraker et al., "The end of an architectural era: (it's time for a complete rewrite)," VLDB, 2007.
Gartner, "Gartner Forecasts Worldwide Public Cloud Revenue to Grow 17% in 2020," 2020.
ScaleGrid. (2019, March 4). 2019 Database Trends: SQL vs. NoSQL - Top Databases, Single vs. Multiple Database Use. ScaleGrid Blog. Retrieved from https://scalegrid.io/blog/2019-database-trends-sql-vs-nosql-top-databases-single-vs-multiple-database-use
DB-Engines, "Historical trend of the popularity ranking of database management systems," 2024. [Online]. Available: https://db-engines.com/en/ranking_trend.
B. F. Cooper et al., "Benchmarking cloud serving systems with YCSB," ACM Symposium on Cloud Computing, 2010.
Transaction Processing Performance Council, "TPC Benchmarks," 2021.
