Polyglot Persistence: data storage and its possibilities

Abstract

The exponential growth in data generation by organizations results in the need to persist data in a way that ensures integrity, consistency, and availability. As data complexity continues to increase, the relational model no longer fully meets storage requirements. To address these new demands, NoSQL databases have emerged as an alternative. In this context, Polyglot Persistence presents itself as a strategy for managing the diversity of data and application requirements in modern systems. This multiplicity of approaches to data storage raises the guiding question of this study: how can we assist in choosing the most appropriate model? To address this question, a literature review was conducted to analyze relational and NoSQL database models, highlighting the advantages and disadvantages of each within a polyglot persistence framework. This study produced a theoretical framework to aid in selecting the most suitable model for each storage scenario.