An Expert System Knowledge Base for Analyzing Query Code to Industrial Databases

This article discusses an approach to enhancing the efficiency of database queries to optimize data retrieval and processing times from high-load database management systems. The proposed method involves forming a knowledge base for an expert system in sets of rules that optimize data retrieval time from relational databases. The set of rules, which increase data processing efficiency, addresses several issues: lack of profiling, performance problems caused by merging the structure of queries with the algorithmic part of the task, and the execution structure of queries. Additionally, the paper presents results from experiments on data processing for the information system of the Ilyushin Aviation Complex–Aviastar Public Joint Stock Company.