THE EFFECTIVENESS OF THE PRINCIPLES OF ADAPTIVE LAYOUT IN THE DEVELOPMENT OF USER INTERFACES

Vinogradova Maria Valerievna, Goryachkin Boris Sergeevich, Litvinovich Lyudmila Valentinovna

Problem statement. Reducing the execution time of complex database queries becomes an urgent problem when working with tables and collections with a large number of records [1-4, 9-17]. During the operation of information systems, the load on database management systems increases. Server performance in multiuser mode does not meet user expectations. This problem is found in all information systems that work with big data. When solving the problem, companies use tools such as vertical and horizontal scaling or query optimization. Vertical and horizontal scaling is significantly more expensive compared to optimizing database queries. Query optimization in multiuser mode involves fragmentation, analysis, and tracking the execution time of all queries[16]. Thus, correcting the situation of a long wait for a response for complex queries to tables and collections with a large number of records requires a lot of material and time costs for companies. It is necessary to optimize the execution of complex database queries, helping companies create a database of their queries that will be completed in an acceptable time. Results. The existing units of measurement are considered. It is determined how and why they are used in web design. The types of units of measurement are studied: absolute and relative, their differences and areas of applicability are indicated. The principles of adaptive layout are highlighted, as well as the tasks for solving which the principles of adaptive layout and the units of measurement considered were used. Practical significance. The practical significance lies in reducing the execution time of such requests to a level below the time of visual perception by a human operator.

Keywords:information model, query optimizer, B-tree, composite indexes, covering indexes, selectivity, query ergonomics, query ergonomics