亚洲一区欧美在线,日韩欧美视频免费观看,色戒的三场床戏分别是在几段,欧美日韩国产在线人成

聯(lián)合收獲機(jī)知識(shí)庫(kù)數(shù)據(jù)多表聯(lián)合查詢(xún)方法研究
作者:
作者單位:

作者簡(jiǎn)介:

通訊作者:

中圖分類(lèi)號(hào):

基金項(xiàng)目:

國(guó)家重點(diǎn)研發(fā)計(jì)劃項(xiàng)目(2017YFD0700100)


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

Fund Project:

  • 摘要
  • |
  • 圖/表
  • |
  • 訪問(wèn)統(tǒng)計(jì)
  • |
  • 參考文獻(xiàn)
  • |
  • 相似文獻(xiàn)
  • |
  • 引證文獻(xiàn)
  • |
  • 資源附件
  • |
  • 文章評(píng)論
    摘要:

    聯(lián)合收獲機(jī)知識(shí)庫(kù)系統(tǒng)使用SQL Server數(shù)據(jù)庫(kù),數(shù)據(jù)庫(kù)中的眾多數(shù)據(jù)表具有獨(dú)立性,便于構(gòu)建和管理。但當(dāng)知識(shí)庫(kù)數(shù)據(jù)量達(dá)到一定規(guī)模后,對(duì)數(shù)據(jù)表逐一查詢(xún)不具有可操作性,將全部數(shù)據(jù)表融合又會(huì)導(dǎo)致數(shù)據(jù)結(jié)構(gòu)混亂、內(nèi)容表述不清、技術(shù)無(wú)法實(shí)現(xiàn)。針對(duì)這一問(wèn)題,提出聯(lián)合收獲機(jī)知識(shí)庫(kù)數(shù)據(jù)多表聯(lián)合查詢(xún)方法。從多角度劃分?jǐn)?shù)據(jù)表類(lèi)型,分析聯(lián)合收獲機(jī)知識(shí)庫(kù)數(shù)據(jù)存儲(chǔ)結(jié)構(gòu),設(shè)置多表聯(lián)合數(shù)據(jù)管理范圍;應(yīng)用SQL(Structured query language)語(yǔ)言將多表信息融合為數(shù)據(jù)集并存入臨時(shí)表中,實(shí)現(xiàn)多表聯(lián)合運(yùn)行;利用人機(jī)交互界面將用戶(hù)查詢(xún)需求轉(zhuǎn)換成多表聯(lián)合查詢(xún)語(yǔ)句,生成查詢(xún)結(jié)果,實(shí)現(xiàn)多表近似范圍查詢(xún)和多表精確定位查詢(xún)。多表聯(lián)合查詢(xún)與傳統(tǒng)單表知識(shí)查詢(xún)之間的測(cè)試結(jié)果表明,多表近似范圍查詢(xún)比系統(tǒng)原有的單表近似范圍查詢(xún)節(jié)約用戶(hù)操作時(shí)間50%及以上,最高達(dá)到90.4%;多表精準(zhǔn)定位查詢(xún)比系統(tǒng)原有的單表精準(zhǔn)定位查詢(xún)節(jié)約用戶(hù)操作時(shí)間48.1%及以上,最高達(dá)到89.6%。多表聯(lián)合查詢(xún)的實(shí)現(xiàn)使聯(lián)合收獲機(jī)知識(shí)庫(kù)系統(tǒng)具有實(shí)用性與可行性,可為同類(lèi)知識(shí)庫(kù)系統(tǒng)數(shù)據(jù)管理提供可借鑒的思路和方法。

    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.

    參考文獻(xiàn)
    相似文獻(xiàn)
    引證文獻(xiàn)
引用本文

劉宏新,張一鳴,解勇濤,趙一健,郭麗峰.聯(lián)合收獲機(jī)知識(shí)庫(kù)數(shù)據(jù)多表聯(lián)合查詢(xún)方法研究[J].農(nóng)業(yè)機(jī)械學(xué)報(bào),2023,54(5):150-162. LIU Hongxin, ZHANG Yiming, XIE Yongtao, ZHAO Yijian, GUO Lifeng. Multi-table Joint Query Method for Combine Harvester Knowledge Base Data[J]. Transactions of the Chinese Society for Agricultural Machinery,2023,54(5):150-162.

復(fù)制
分享
文章指標(biāo)
  • 點(diǎn)擊次數(shù):
  • 下載次數(shù):
  • HTML閱讀次數(shù):
  • 引用次數(shù):
歷史
  • 收稿日期:2022-07-15
  • 最后修改日期:
  • 錄用日期:
  • 在線發(fā)布日期: 2023-05-10
  • 出版日期:
文章二維碼