Creating Collections with Embedded Documents for Document Databases Taking into Account the Queries

Yulia Shichkina,Muon Ha

doi:10.3390/computation8020045

Abstract

In this article, we describe a new formalized method for constructing the NoSQL document database of MongoDB, taking into account the structure of queries planned for execution to the database. The method is based on set theory. The initial data are the properties of objects, information about which is stored in the database, and the set of queries that are most often executed or whose execution speed should be maximum. In order to determine the need to create embedded documents, our method uses the type of relationship between tables in a relational database. Our studies have shown that this method is in addition to the method of creating collections without embedded documents. In the article, we also describe a methodology for determining in which cases which methods should be used to make working with databases more efficient. It should be noted that this approach can be used for translating data from MySQL to MongoDB and for the consolidation of these databases.

Highlights

Access to accurate information in the modern era is a major challenge that organizations have to face
We propose a new formalized method for constructing a NoSQL document database, taking into account the structure of queries planned for execution to the database
In our article [25], we presented a method based on set theory, which allows determining which of the three options will be effective

Summary

Introduction

Access to accurate information in the modern era is a major challenge that organizations have to face. A police officer must know whether he has the right to apply the law when a new situation arises. The doctor wants to know all the information about the patient who could be treated in any hospital and with any diagnosis. The aforementioned situations and many other situations require quick access to either a single common source of information, or to a data collection system from various sources. The main problem is that each of the sources of information usually allows obtaining specific information stored in it and this, as a result, entails a loss of understanding of the requested object as a whole. It is important to create systems for the automatic collection of data from databases of various types and structures

Objectives

Methods

Conclusion