Database design methods for command and control special-purpose systems
Mathematical support and software for computers, complexes and networks
Аuthors1*, 1**, 2***
1. Group of Companies «RTI», 10/1, 8 Marta str., Moscow, 127083, Russia
2. Radiotechnical Institute named after academician A.L. Mintz, 10-1, str. 8 March, Moscow, 127083, Russia
The purpose of this article is development of database design methods for command and control special-purpose systems.
It is shown that the use of the all-purpose client-server databases for solving the air force and air defense tasks leads to poor query performance. In some cases, the use of more simple distributed databases allows reducing the query time by 90%, but the amount of data does not allow using them as a single solution.
It is proposed that in dealing with heterogeneous highly dynamic tasks, it more effective to use a special-designed database in order to meet the requirements of the designed system.
Given the lack of scientific and methodological methods for selection of proper software in the design of the database, the article offers a method of formalizing requirements for the composition and structure of the DBMS to solve the required tasks.
The article provides a way of grouping and quantitative description of the requirements at the stage of conceptual design of DBMS, which forms the space on the basis of the requirements specification while modeling each task as the DBMS client.
It is shown that in case of the total area of a the requirements of a certain type, it is effective to use an inhomogeneous distributed DBMS. Thus, with weakly bound heterogeneous data and the anticipated load, the article proposes to use multiple databases, each of which handles a particular piece of data. Continuous data partitioning and management of the database structure allows having a data partition that provides better performance.
The article provides the technique of the requirements substantiation to the structure and characteristics of DBMS for command and control special-purpose systems.
It is shown, that the developed technique for DBMS design can increase query performance by more than twice in air force and air defense tasks.
Keywords:database management systems, command and control systems software requirements
Andreev V.N. Voenno-kosmicheskaya oborona, 2011, no. 2 (57), pp. 14-19.
Konnolly T., Begg K. Basy dannyh, proektirovanie, realizaciya i soprovozhdenie (Databases, design, realization and accompaniment), Moscow, Izdatel’skii dom «Vil’yams», 2003, 1440 p.
Kuznecov S.D. Osnovy sovremennyh baz dannyh (Fundamentals of modern databases), Moscow, Isdatelstvo «Internet-universitet informacionnyh tehnologij», 2007, 488 p.
.Brekhov O.M., Tin M.A. Trudy MAI, 2015, no. 84: http://www.mai.ru/science/trudy/published.php?ID=63152
Date C.J. Vvedenie v sistemy baz dannykh (Introduction to Database Systems), Moscow, Izdatel’skii dom «Vil’yams», 2001, 1328 p.
Dudakov N.S., Pirogov N.E., Shumilov Y.Y. Vestnik natsional’nogo issledovatel’skogo yadernogo universiteta MIFI, 2012, vol.1, no.1, pp.119-124.
Kokuev A.A., Ktitrov S.V. Vestnik natsional’nogo issledovatel’skogo yadernogo universiteta MIFI, 2014, vol. 3, no.1, pp.119-124.