Optimization of the physical parameters of the organization of databases

Abstract

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.