Vozovykov Y. Models and methods of control materialized views for information systems with relational databases

Dissertation is devoted to the development of models and methods of application - driven materialized views in the information systems to improve their performance. Improved mathematical model for the presentation of requests to the information systems, wherein the introduction of the concept of the intensity distribution of queries, the minimum time of the query in the application of the materialized views, the definition of the efficiency of use of materialized views operating mode selected . First proposed method for determining the principal control period, materialized views, which is characterized by successive refinement of the on/off switch and update data. For the first time a method finding the set governing driving materialized views which is characterized by periods binding on/off switch to the materialized views routine of intellectual property, which allows you to bring query time to theoretically determine the minimum value. For the first time a method of adapting mechanism of materialized views, wherein tracking the functional and structural changes in the information systems and intensity solve problems and develop information technology to support the effectiveness of materialized views. The experiments and the introduction of the proposed models of methods and technologies in the information systems possible to reduce the number of query execution time by 20 times, and the total query execution time by 15%, which confirms the theoretical principles work.