Multi-table Joint Query Method for Combine Harvester Knowledge Base Data

LIU Hongxin ZHANG Yiming, XIE Yongtao, ZHAO Yijian, GUO Lifeng

Abstract

The combine harvester knowledge base system uses the SQL server database, numerous data tables in the database are independent and easy to build and manage. But when the amount of knowledge base data reaches a certain size, querying data tables one by one is not actionable and merging all the data tables will lead to confusion in the data structure, unclear content expression, and technical inability to achieve. In response to this problem, a multi-table joint query method of combine harvester knowledge base data was proposed. The data table types was divided from multiple perspectives, the data storage structure of the combine harvester knowledge base was analyzed and the management scope for multi-table joint data was set. The application structured query language (SQL) fused multi-table information into a dataset and stored it into a temporary table to achieve multi-table joint operation. The human-computer interactive interface was used to convert the user query requirements into multi-table joint query statements to generate query results, and multi-table approximate range query and multi-table precise positioning query were realized. The test results between multi-table joint query and traditional single-table knowledge query showed that on the one hand, multi-table approximate range query saved user operation time by 50% or more than the original single-table approximate range query of the system, and the highest reached 90.4%;on the other hand, the multi-table precise positioning query saved 48.1% or more user operation time compared with the original single-table precise positioning query of the system, and the highest reached 89.6%. The implementation of multi-table joint query made the combine harvester knowledge base system practical and feasible and provided a reference idea and method for data management of similar knowledge base system.


Keywords: combine harvester, knowledge base system, multi-table joint query, data table classification, data synchronization, human-computer interactive

 

Download Full Text:

PDF


References


XU Lizhang, LI Yang, LI Yaoming, et al. Researc h progress on cleaning technology and device of grain combine harvester [J] . Transactions of the Chinese Society for Agricultural Machinery, 2019, 50( 10) ; 1 - 16. (in Chinese)

DU Yuefeng, FU Shenghui, MAO Enrong, et al. Development situation and prospects of intelligent design for agricultural machinery [J]. Transactions of the Chinese Society for Agricultural Machinery, 2019, 50(9) : 1 - 17. (in Chinese)

YANG Guang, CHEN Qiaomin, XIA Xianfei, et al. Design and optimization of the key components for 4DL — 5A faba bean combine harvester[ J ]. Transactions of the CSAE, 2021 , 37(23) : 10 - 18. (in Chinese)

LIU Hongxin, WANG Dengyu, GUO Lifeng, et al. Development of advanced design technology and its application in agricultural equipment [J ]. Transactions of the Chinese Society for Agricultural Machinery, 2019, 50 (7): 1 - 18. (in Chinese)

LIU Hongxin, LIU Zhaojin, ZHANG Guangfu, et al. Interactive design system of threshing device based on Skeleton Design [J ]. Transactions of the Chinese Society for Agricultural Machinery, 2020, 51(12): 405 -416. ( in Chinese)

CHOI H, LEE S, JEONG D. Forensic recovery of SQL Server database; practical approach [J ]. IEEE Access, 2021 , 9; 14564 - 14575.

LI Qinglin, SONG Yuying, YAO Chengjian, et al. Intelligent design and optimization system for cleaning device of rice and wheat combine harvester [ J ]. Transactions of the Chinese Society for Agricultural Machinery, 2021, 52 ( 5 ) : 92 - 101. (in Chinese)

LI Wenbin, LI Qinglin, HUANG Yunlin, et al. Construction of intelligent design platform for threshing device of combine harvester for rice and wheat [J ]. Transactions of the Chinese Society for Agricultural Machinery, 2020, 51 ( Supp. 2 ) ; 154 - 161. (in Chinese)

SONG Zhenghe, BI Shuqin, JIN Xiaoping, et al. Rapid design reasoning method for crawler harvester transmission system [J]. Transactions of the Chinese Society for Agricultural Machinery, 2013, 44(Supp.2) ; 268 -272. (in Chinese)

RAHMAN M N, ESMAILPOUR A. A hybrid data center architecture for big data[ J]. Big Data Research, 2016, 3(C); 29 -40.

BAZAGA A, GUNWANT N, MICKLEM G. Translating synthetic natural language to database queries with a polyglot deep learning framework [ J ]. Scientific Reports, 2021 , 11(1): 1 -11.

KUMAR A, BOEHM M, YANG J. Data management in machine learning: challenges, techniques, and systems [ С ] // Proceedings of the 2017 ACM International Conference on Management of Data, 2017; 1717 - 1722.

LI Xinpeng, WANG Yong, FENG Hao, et al. A parallel host log analysis approach based on spark [С ] // 2018 14th International Conference on Computational Intelligence and Security (CIS). IEEE, 2018: 301 -305.

YI Weiguo, HE Jianguo, LIU Guishan, et al. Development and implementation of blockchain to enhance traeeabilitv and reliability of fruit and vegetable quality [ J ]. Transactions of the Chinese Society for Agricultural Machinery, 2022, 53(2) : 309 -315, 345. (in Chinese)

CHENG Wei, QIAN Xiaoming, LI Shiwei, et al. Research and application of PIE — Engine Studio for spatiotemporal remote sensing cloud computing platform [J ]. National Remote Sensing Bulletin, 2022, 26(2) ; 335 -347. (in Chinese)

ZHAO Runfa, LOU Yuansheng, YE Feng, et al. Research and application of industrial big data platform based on Flink [ J ]. Computer Engineering and Design, 2022, 43(3) ; 886 -894. (in Chinese)

LIU Hongxin, LI Jinlong, GUO Lifeng, et al. Knowledge organization and knowledge base system of combine harvester[ J ]. Transactions of the Chinese Society for Agricultural Machinery, 2021 , 52(2) ; 381 -393. (in Chinese)

LI Qing, ZHONG Jiang, LI Lili, et al. Self-correcting complex semantic analysis method based on pre-training mechanism [J]. Journal on Communications, 2019, 40( 12) ; 41 -50. (in Chinese)

SOEWITO B, GUNAWAN F E, HIRZI, et al. Prevention structured query language injection using regular expression and escape string [J ]. Procedia Computer Science, 2018, 135; 678 -687.

CHEN He, TIAN Xiuxia, YUAN Peisen, et al. Crypt—JDBC model; optimization of onion encryption algorithm [J ]. Journal of Frontiers of Computer Science and Technology, 2017, 11(8); 1246 - 1257. (in Chinese)

BAI Mei, WANG Jinghui, WANG Xite, et al. PSP: an efficient skyline computation method for partially ordered domains [j]. Journal of Hunan University ( Natural Sciences) , 2020, 47 (8) : 9 -20. (in Chinese)

GUO D, ONSTE1N E. State-of-the-art geospatial information processing in NoSQL databases [ J]. ISPRS International Journal of Geo-Information, 2020, 9(5) : 331 -351.

SCHREINER G A, DUARTE D, DOS SANTOS M R. Bringing SQL databases to key-based NoSQL databases: a canonical approach [J]. Computing, 2020, 102(1); 221 -246.

ZHANG Chenyu, LIU Wenjie, PANG Tianze, et al. Optimization of correlate subquery based on distributed database [ J]. Journal of Northwestern Polytechnical University, 2021 , 39(4) ; 909 -918. (in Chinese)


Refbacks

  • There are currently no refbacks.