NoSql Database Optimization Based on Metadata About Queries and Relationships Between Objects

NoSql Database Optimization Based on Metadata About Queries and Relationships Between Objects

연구 분야: Databases

학회: International Conference on Computational Science and Its Applications

Most experts in the field of big data agree that the volume of data generated by various devices will increase exponentially in the future. Therefore, there is no doubt the relevance of solving the problem of data storage in such a way that access to the necessary information would be as quick as possible. In this article, we propose an approach based on set theory, which is suitable for databases that store information about objects with many relationships. Such databases can include both relational and NoSQL databases. This approach takes into account the relationships between objects and the structure of the most frequently executed database queries when designing the database architecture. This allows to remove operations “join” from queries and, at the same time, to minimize the data redundancy anomaly in a separate database structural unit. We demonstrated the application of this approach on three types of databases: relational, document, and columns family.