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

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 descri...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Odes'kyi Politechnichnyi Universytet. Pratsi 2015-03, Vol.2015 (1), p.113-120
Hauptverfasser: Kungurtsev, A.B, Zinovatnaya, S.L, Abdo, Munzer Al
Format: Artikel
Sprache:eng
Schlagworte:
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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. Keywords: information system, relational database, query, test, modeling, prediction. [TEXT NOT REPRODUCIBLE IN ASCII] [TEXT NOT REPRODUCIBLE IN ASCII]
ISSN:2076-2429
2223-3814
DOI:10.15276/opu.1.45.2015.19