Optimization of the physical parameters of the organization of databases

The main task of the transport system is the most complete satisfaction of the needs of business entities and the population in transportation, reducing the time of delivery of goods and transportation of passengers on the basis of a qualitative increase in the capacity of the entire transport system. This problem is solved with the help of computer technology and new information technologies in transport management systems. The most demanded is the database technology implemented in modern automated transport management information systems.

Given the exponential growth in the volume of databases used, strict time limits for real-time management decisions in transport management systems, the task of minimizing the time to execute information queries in the database is of particular relevance.

The execution time of information requests is influenced by the methods of physical storage of databases. To solve the problem of minimizing the execution time of information requests, it is necessary to determine the physical parameters that affect the efficiency of database processing.

An external memory simulation model is described for optimizing the physical parameters of database organization, based on the exchange procedures implemented in modern database management systems between external and operational memory upon information requests. As a key optimization parameter, a memory block reservation factor is substantiated, which allows minimizing the number of slow accesses to external memory.

The rationality and adequacy of the proposed model in the process of research is confirmed by the results of simulation modeling.

1. Alexeev O., Pronin S. The аpplication of database for passenger transport estimation. Automobile Transport. 2009;24:94-97. (In Russ.).

2. Nurmukhamedov T.R., Gulyamov J.N. Automation of inventory accounting in the wagon depot warehouse. Intellectual Technologies on Transport. 2021;4(28):39-45. DOI: 10.24412/2413-2527-2021-428-39-45 (In Russ.).

3. Pokhilko S.P., Ivanchenko I.S. Implementation of a database of refusals to accept empty freight cars for loading into automated railway transport systems. Collection of Scientific Works of the Donetsk Institute of Railway Transport. 2021;61:40-48. (In Russ.).

4. Tanayno Yu. A., Bessonenko S.A., Medvedev V.I. Automated quality management system for loading. Bulletin of the Siberian State University of Communications. 2018;2(45):19-23. (In Russ.).

5. Fomenko Yu.S., Abou Hasan R., Khomonenko A.D. Logical data integration on the example of organizing queries to the database air transportation. Intellectual Technologies on Transport. 2019;4(20):39-47. (In Russ.).

6. Date C.J. An Introduction to Database Systems. Moscow, Nauka, 1980;463. (In Russ.).

7. Martin J. Strategic data-planning methodologies. Moscow, Finance and statistics, 1984;196. (In Russ.).

8. Chetverikov V.N., Revunkov G.I., Samokhvalov E.N. Databases and data banks: textbook for universities. Moscow, Higher school, 1987;245. (In Russ).

9. Jackson G. Designing relational databases for use with microcomputers. Moscow, Mir, 1991;252. (In Russ.).

10. Connolly T., Begg K., Strachan A. Databases: design, implementation and maintenance. Theory and practice, 2nd ed. Moscow, Williams, 2000;1120. (In Russ.).

11. Ozkarakhan E. Database machines and database management. Moscow, Mir, 1989;695. (In Russ.).

12. Golenishchev E.P., Klimenko I.V. Information support of control systems. Rostov-on-Don, Phoenix, 2010;315. (In Russ.).

13. Meyer D. Theory of relational databases. Moscow, Mir, 1987;608. (In Russ.).

14. Kopeikin M.V., Spiridonov V.V., Shumova E.O. The choice of a method for storing relations in information systems. Journal of Mining Institute. 2014;208:249-255. (In Russ.).

15. Drozhdin V.V., Volodin A.M. Methods of physical organization of data, supported by existing data management systems. Izvestiya of the Penza State Pedagogical University. V.G. Belinsky. 2008;12:103-106. (In Russ.).

16. Dorofeeva O.S., Kazakov B.V., Kazakova I.A. Criteria for the optimal placement of database blocks based on simple Markov chains. Transactions of the International Symposium on Reliability and Quality. 2020;1:44-45. (In Russ.).