Dvoretskyi M. Models and information technology for optimizing the structure of the node database in corporate information systems

The aim of the work is to increase the level of data availability and efficiency of distributed computer systems use by implementing information technology to optimize the structure of the database of the remote node based on the statistics of SQL queries The work creates the dependence model of the criteria of database optimal structure of CIS node on the value of the data representation marker according to the statistical data of SQL queries to the database. The values are calculated on the basis of a multidimensional database with obtaining of the corresponding data slices according to the developed aggregation function. The SQL query model has been improved, which is presented on the basis of a multidimensional database with the possibility of performing operational and analytical analysis according to the multiplicity of dimensions. When building the model, it is proposed to obtain ranges of query keys to determine the set of tuples of the relation of the resulting set of rows. А modified analytic hierarchy process with automatic initialization of the matrix of pairwise comparisons of alternatives according to the obtained mathematical models and normalization of values is proposed. Elements of fuzzy inference were used to dephase the vector of global priorities. The classification of new data was performed using the naive Bayesian algorithm. The information technology (IT) of calculation of optimality criteria of the CIS DB structure node is developed. The IT bases on the statistics of SQL-queries and calculates an optimum level of the data representation on DCIS node. The results of the research were implemented in the working DCIS and positive effect was obtained.