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
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
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
