{"title":"An Approach to Improving the Efficiency of the Database of a Large Industrial Enterprise","authors":"M. M. Bazhutin, V. Moshkin","doi":"10.1109/SmartIndustryCon57312.2023.10110728","DOIUrl":null,"url":null,"abstract":"The paper describes an approach to improving the efficiency of queries in the SQL language in order to optimize the time of retrieving and processing data from highly loaded DBMS. The proposed approach involves the formation of a knowledge base in the form of sets of rules that allow you to optimize the time of data retrieval from relational databases. The set of rules that increase the efficiency of processing data from the database can be divided into sets that solve the following problems: the lack of profiling, performance issues caused by combining of SQL and the algorithmic part of the task, SQL execution structure. Also, the paper presents the results of experiments on data processing of the information system of the Branch of PJSC \"Il\" - Aviastar.","PeriodicalId":157877,"journal":{"name":"2023 International Russian Smart Industry Conference (SmartIndustryCon)","volume":"99 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-03-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2023 International Russian Smart Industry Conference (SmartIndustryCon)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/SmartIndustryCon57312.2023.10110728","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1
Abstract
The paper describes an approach to improving the efficiency of queries in the SQL language in order to optimize the time of retrieving and processing data from highly loaded DBMS. The proposed approach involves the formation of a knowledge base in the form of sets of rules that allow you to optimize the time of data retrieval from relational databases. The set of rules that increase the efficiency of processing data from the database can be divided into sets that solve the following problems: the lack of profiling, performance issues caused by combining of SQL and the algorithmic part of the task, SQL execution structure. Also, the paper presents the results of experiments on data processing of the information system of the Branch of PJSC "Il" - Aviastar.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
