SQL-query Syntactic Optimization Based on the Local Model of the Controlled Process
П. П. Костенко, Mykola Guchenko · 2011
This paper describes the data storage technology (relation databases) and the query language to these databases (Structured Query Language), which today are the basis of the all information systems evolution. The article contains the review of the existing techniques for SQL-query optimization. Mathematical expressions for the generation of possible SQL-query syntactic constructs are considered. The paper contains the main control characteristics of the dynamic objects under conditions of low apriori information, based on the local model of the controlled process. The new approach to automatic external syntactic optimization of the SQL-query is presented.