Технічна інженерія (Dec 2021)
Design and development of a document-oriented database management system
Abstract
The article is devoted to the design and development of a document-oriented database management system. The components of modern database management systems, their three-level architecture are described, the general block diagram of the system operation is given. The work of all modules of the developed system is demonstrated, in particular IParseStrategy and IExecuteStrategy. The parser system is created, the order of execution of some classes, algorithms of work of DCL and DDL components are resulted. The interface of the developed database management system is presented, the general order of execution of query in it is defined, execution of requests for creation of a database and collections is shown. Working with data in the database management system allows creatштп requests to insert and edit data, their selection and deletion. The system additionally provides the ability to output data to a PDF and Excel file. For operations that involve the combination of many tables, the implementation of Union commands is provided. To improve the functionality for automation, the system includes the ability to create views, stored procedures, and triggers for commands. The developed system works with small data sets and has a number of advantages: small system size, clear user interface; small code size; formation of an abstract nucleus; processing of regulatory rules through special objects, etc. An established data integrity support system based on a relational data model ensures that the user cannot accidentally delete data used by other data. The developed system is intended for use by small and microbusiness enterprises, which on the one hand need a database management system with support for the required minimum of data integrity control mechanisms, and on the other hand need great mobility and ease of use.
Keywords
