{"title":"基于混合学习的外企德语数据库查询优化","authors":"Yan Chengcheng","doi":"10.1142/s0219649222400196","DOIUrl":null,"url":null,"abstract":"Traditional database query optimisation methods use stochastic algorithms to approximate the query optimisation results by continuously adjusting the optimisation plan. Since the stochastic algorithm only performs query optimisation from a single perspective, it leads to no significant improvement of the optimised database query efficiency. To address the above problems, we studied the query optimisation method of foreign enterprises’ German language data database based on hybrid learning. By reducing the database query search space and selecting query optimisation strategy, the data query complexity is reduced. After estimating the cost of database query optimisation, the policy selection algorithm is trained using the hybrid learning theory to obtain the database query optimisation path. The simulation experimental results show that the average query response of the optimised database after applying the studied method saves about 13.6%, and the query cost is lower and the optimisation effect is better.","PeriodicalId":127309,"journal":{"name":"J. Inf. Knowl. Manag.","volume":"21 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-05-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Optimisation of German Language Database Query for Foreign Companies Based on Hybrid Learning\",\"authors\":\"Yan Chengcheng\",\"doi\":\"10.1142/s0219649222400196\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Traditional database query optimisation methods use stochastic algorithms to approximate the query optimisation results by continuously adjusting the optimisation plan. Since the stochastic algorithm only performs query optimisation from a single perspective, it leads to no significant improvement of the optimised database query efficiency. To address the above problems, we studied the query optimisation method of foreign enterprises’ German language data database based on hybrid learning. By reducing the database query search space and selecting query optimisation strategy, the data query complexity is reduced. After estimating the cost of database query optimisation, the policy selection algorithm is trained using the hybrid learning theory to obtain the database query optimisation path. The simulation experimental results show that the average query response of the optimised database after applying the studied method saves about 13.6%, and the query cost is lower and the optimisation effect is better.\",\"PeriodicalId\":127309,\"journal\":{\"name\":\"J. Inf. Knowl. Manag.\",\"volume\":\"21 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-05-21\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"J. Inf. Knowl. Manag.\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1142/s0219649222400196\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"J. Inf. Knowl. Manag.","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1142/s0219649222400196","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Optimisation of German Language Database Query for Foreign Companies Based on Hybrid Learning
Traditional database query optimisation methods use stochastic algorithms to approximate the query optimisation results by continuously adjusting the optimisation plan. Since the stochastic algorithm only performs query optimisation from a single perspective, it leads to no significant improvement of the optimised database query efficiency. To address the above problems, we studied the query optimisation method of foreign enterprises’ German language data database based on hybrid learning. By reducing the database query search space and selecting query optimisation strategy, the data query complexity is reduced. After estimating the cost of database query optimisation, the policy selection algorithm is trained using the hybrid learning theory to obtain the database query optimisation path. The simulation experimental results show that the average query response of the optimised database after applying the studied method saves about 13.6%, and the query cost is lower and the optimisation effect is better.