Open AccessOptimization structure database of complex systems
Author(s) -
Andrey Mastislavovich Korneev,
Anatoly Pogodaev,
L S. Abdullakh,
M V. Salfetnikov
Publication year - 2018
Publication title -
international journal of engineering and technology
Language(s) - English
Resource type - Journals
ISSN - 2227-524X
DOI - 10.14419/ijet.v7i2.13.11626
Subject(s) - computer science , relational database , relational model , transformation (genetics) , expression (computer science) , database model , database design , data model (gis) , theoretical computer science , data mining , entity–relationship model , data structure , scheme (mathematics) , database , information retrieval , programming language , artificial intelligence , mathematics , mathematical analysis , biochemistry , chemistry , gene
In the article such ways of optimization of the structure of a database of complex structured objects that allow simplifying the scheme of an information system. As a result, the response time of the information system to the user's request is reduced, and it becomes possible to more effectively manage and monitor the progress of ongoing processes. A formalized model of the relational expression is developed, a model of the corresponding equivalent transformation of the chosen relational expression is created, a formal description of the developed algorithm for optimizing the queries is presented.