Prediction of a relational database’s operation in the information system

• Main Authors: Аlexey B. Kungurtsev, Svitlana L. Zinovatnaya, Munzer Al Abdo
• Format: Article
• Language: English
• Published: Odessa National Polytechnic University 2015-10-01
• Series: Trudy Odesskogo Politehničeskogo Universiteta
• Subjects: information system; relational database; query; test; modeling; prediction
• Online Access: http://pratsi.opu.ua/articles/show/1150

A necessary condition of any information system’s efficient operation is to ensure that response time to user requests satisfies the subject area requirements. Actual is the problem of automated methods for choosing the tools reducing the execution time of queries to the database. Formal description of the system’s state and development gives the possibility to apply the most effective ways of speeding up queries in time when there is a need to improve system performance. While researching some dependences are obtained, allowing to predict the intensity of requests entering the information system, to determine the trend of system’s loading, to identify peak periods and set of the most commonly used tables and fields. The results on system operative features researching provide the possibility to predict system’s behavior and to take timely measures to maintain the required level of performance.