TW201621712A - Method of operating a solution searching system and solution searching system - Google Patents

Method of operating a solution searching system and solution searching system Download PDF

Info

Publication number
TW201621712A
TW201621712A TW103142674A TW103142674A TW201621712A TW 201621712 A TW201621712 A TW 201621712A TW 103142674 A TW103142674 A TW 103142674A TW 103142674 A TW103142674 A TW 103142674A TW 201621712 A TW201621712 A TW 201621712A
Authority
TW
Taiwan
Prior art keywords
solution
server
file
problem description
model
Prior art date
Application number
TW103142674A
Other languages
Chinese (zh)
Other versions
TWI563402B (en
Inventor
盧盈志
Original Assignee
英業達股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 英業達股份有限公司 filed Critical 英業達股份有限公司
Priority to TW103142674A priority Critical patent/TWI563402B/en
Publication of TW201621712A publication Critical patent/TW201621712A/en
Application granted granted Critical
Publication of TWI563402B publication Critical patent/TWI563402B/en

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A solution searching system includes a utility server, a model server, a database server, and a controller central server. The utility server is used to generate a first model input file according to a first issue description file. The model server is used to generate a first solution key according to the first model input file and a prediction an estimation model. The database server is used to read a first solution from a big an information database according to the first solution key. The controller central server is used to transfer the first issue description file to the utility server, to transfer the first model input file to the model server, to transfer the first solution key to the database server, and to output the first solution when receiving the first issue description file.

Description

解決方案搜尋系統之操作方法及解決方案搜尋系統 Solution search system operation method and solution search system

本發明係有關於一種解決方案搜尋系統,尤指一種利用巨量資料及資料探勘技術之解決方案搜尋系統。 The present invention relates to a solution search system, and more particularly to a solution search system that utilizes massive data and data exploration techniques.

一個產品的成功與否除了與研發技術息息相關之外,亦須要大量的測試以確保產品的穩定性,尤其是要求高穩定性、高信賴度的科技產品,如工業儀器、行動裝置、工作站、個人電腦或伺服器...等產品,對於品管測試的標準即更加嚴格。而當產品被檢測出問題時,必須經由複製問題、蒐集及分析相關資料、找出問題可能之成因、提出可能的解決方案並驗證所提出的解決方案...等步驟以確保檢測出的問題得以被適當地解決,這些過程不僅可能十分耗時,甚至可能導致產品錯過進入市場的時機,且實行上又必需仰賴工程師的個人經驗及專業程度;亦即工程師的經驗及專業程度是否足夠將會大大地影響提出解決方案所需要的時間,同時也可能影響了所提出之解決方案是否能夠徹底解決問題,導致解決方案的品質不易掌握。另外,由於個人經驗不易傳承,因此即便欲解決的問題相同或類似,不同的工程師仍可能必須重複上述的過程才能得出解決方案,這樣的做法不僅沒有效率,也無法確保工程師能找出最適切的解決方案。 In addition to being closely related to R&D technology, the success of a product requires a large number of tests to ensure product stability, especially for high-stability, high-reliability technology products such as industrial instruments, mobile devices, workstations, and individuals. For products such as computers or servers, the standards for quality control testing are more stringent. When a product is detected as a problem, it must be ensured by copying the problem, collecting and analyzing the relevant information, identifying possible causes of the problem, proposing possible solutions, and verifying the proposed solution. Being properly addressed, these processes can be not only time consuming, they can even lead to missed opportunities for the product to enter the market, and implementation must rely on the individual experience and professionalism of the engineer; that is, whether the engineer’s experience and professionalism will be sufficient It greatly affects the time required to propose a solution, and may also affect whether the proposed solution can completely solve the problem, resulting in the quality of the solution is difficult to grasp. In addition, because personal experience is not easy to pass on, even if the problem to be solved is the same or similar, different engineers may have to repeat the above process to get a solution. This practice is not only inefficient, but also ensures that the engineer can find the most appropriate. s solution.

此外,對於同類型的產品,其出現相同或相似問題的比例甚高,過去雖亦有將解決方案紀錄或存檔的作法,但由於問題種類繁多,所牽涉到的資訊量相當龐大,加上各工程師對於問題描述的方式可能不一致,因此難 以系統化地儲存,因此在實行上,工程師仍不易搜尋到相關的解決方案,而難以達成使工程師共享經驗的目的。因此如何能使工程師能分享彼此的經驗,且能輕易地搜尋到可能的解決方案以減少解決產品問題的時間,並提升解決方案品質,即成為重要的問題。 In addition, for the same type of products, the proportion of the same or similar problems is very high. Although there have been solutions or archived solutions in the past, due to the wide variety of problems, the amount of information involved is quite large, plus The way the engineer describes the problem may be inconsistent, so it is difficult In a systematic way, it is difficult for engineers to find relevant solutions in terms of implementation, and it is difficult to achieve the purpose of sharing experience with engineers. So how to enable engineers to share their experiences and easily find possible solutions to reduce the time to solve product problems and improve the quality of solutions becomes an important issue.

本發明之一實施例提出一種解決方案搜尋系統,其可應用於如工業儀器、行動裝置、工作站、個人電腦或伺服器...等產品之開發與維護。解決方案搜尋系統包含運算伺服器、模型伺服器、巨量資料庫、資料庫伺服器及中樞伺服器。運算伺服器用以根據第一問題描述檔案產生第一模型輸入檔案。模型伺服器用以根據第一模型輸入檔案及預測模型產生第一解決方案代碼。資料庫伺服器用以根據第一解決方案代碼由巨量資料庫讀取第一解決方案。中樞伺服器用以當接收到第一問題描述檔案時,將第一問題描述檔案傳送至運算伺服器,將運算伺服器所產生之第一模型輸入檔案傳送至模型伺服器,將模型伺服器所產生之第一解決方案代碼傳送至資料庫伺服器,並輸出資料庫伺服器由巨量資料庫讀取之第一解決方案。 One embodiment of the present invention provides a solution search system that can be applied to the development and maintenance of products such as industrial instruments, mobile devices, workstations, personal computers, or servers. The solution search system includes a computing server, a model server, a huge database, a database server, and a hub server. The computing server is configured to generate a first model input file according to the first problem description file. The model server is configured to generate the first solution code according to the first model input file and the prediction model. The database server is used to read the first solution from the huge database according to the first solution code. The central server is configured to: when receiving the first problem description file, transmit the first problem description file to the computing server, and transmit the first model input file generated by the computing server to the model server, and the model server The generated first solution code is transmitted to the database server and outputs the first solution that the database server reads from the huge database.

本發明之另一實施例提出一種解決方案搜尋系統之操作方法。解決方案搜尋系統包含運算伺服器、模型伺服器、巨量資料庫、資料庫伺服器及中樞伺服器。解決方案搜尋系統之操作方法包含當中樞伺服器接收到第一問題描述檔案時,中樞伺服器將第一問題描述檔案傳送至運算伺服器;運算伺服器根據第一問題描述檔案產生第一模型輸入檔案;中樞伺服器將第一模型輸入檔案傳送至模型伺服器;模型伺服器根據第一模型輸入檔案及預測模型取得第一解決方案代碼;中樞伺服器將第一解決方案代碼傳送至資料庫伺服器;資料庫伺服器根據第一解決方案代碼讀取儲存於巨量資料庫之第一解決方案;及中樞伺服器輸出由巨量資料庫讀取之第一解決方案。 Another embodiment of the present invention provides a method of operating a solution search system. The solution search system includes a computing server, a model server, a huge database, a database server, and a hub server. The operation method of the solution search system comprises: when the hub server receives the first problem description file, the hub server transmits the first problem description file to the operation server; the operation server generates the first model input according to the first problem description file. The hub server transmits the first model input file to the model server; the model server obtains the first solution code according to the first model input file and the prediction model; the hub server transmits the first solution code to the database server The database server reads the first solution stored in the huge database according to the first solution code; and the central server outputs the first solution read by the huge database.

100、200‧‧‧解決方案搜尋系統 100, 200‧‧‧ Solution Search System

110‧‧‧運算伺服器 110‧‧‧ Computing Server

120‧‧‧模型伺服器 120‧‧‧Model Server

130‧‧‧巨量資料庫 130‧‧‧ huge database

140‧‧‧資料庫伺服器 140‧‧‧Database Server

150‧‧‧中樞伺服器 150‧‧‧Central Server

160‧‧‧網頁伺服器 160‧‧‧Web server

170‧‧‧建模伺服器 170‧‧‧Modeling Server

A1‧‧‧第一問題描述檔案 A1‧‧‧First problem description file

B1‧‧‧第一模型輸入檔案 B1‧‧‧ first model input file

C1‧‧‧第一解決方案代碼 C1‧‧‧First Solution Code

D1‧‧‧第一解決方案 D1‧‧‧ first solution

A2‧‧‧複數個第二問題描述檔案 A2‧‧‧Multiple second problem description files

B2‧‧‧複數個第二模型輸入檔案 B2‧‧‧Multiple second model input files

D2‧‧‧複數個第二解決方案 D2‧‧‧Multiple second solutions

D’2‧‧‧複數個第二解決方案代碼 D’2‧‧‧Multiple second solution codes

300、400‧‧‧解決方案搜尋系統之操作方法 300, 400‧‧‧How to find a solution search system

S310~S370‧‧‧步驟 S310~S370‧‧‧Steps

S410~S450‧‧‧步驟 S410~S450‧‧‧Steps

第1圖為本發明一實施例之解決方案搜尋系統的示意圖。 FIG. 1 is a schematic diagram of a solution search system according to an embodiment of the present invention.

第2圖為本發明另一實施例之解決方案搜尋系統的示意圖。 2 is a schematic diagram of a solution searching system according to another embodiment of the present invention.

第3圖為本發明一實施例之解決方案搜尋系統之操作方法流程圖。 FIG. 3 is a flow chart of an operation method of the solution searching system according to an embodiment of the present invention.

第4圖為本發明另一實施例之解決方案搜尋系統之操作方法流程圖。 4 is a flow chart of an operation method of a solution search system according to another embodiment of the present invention.

第1圖為本發明一實施例之解決方案搜尋系統100的示意圖。解決方案搜尋100包含運算伺服器110、模型伺服器120、巨量資料庫130、資料庫伺服器140及中樞伺服器150。運算伺服器110可用以根據第一問題描述檔案A1產生第一模型輸入檔案B1。第一問題描述檔案A1為尚未有解決方案之問題描述檔,其可利用文字描述與產品系統問題相關的資訊,內容可包含系統問題及現象之描述、系統問題所屬之子系統及發生問題的經過(亦即,可說明如何複製問題),但不限於上述資訊。在本發明之一實施例中,第一問題描述檔案A1可利用固定格式(例如但不限於csv、json、xml等文字檔案格式)條列與系統問題相關的資訊,以使運算伺服器110可較為精確地判讀第一問題描述檔案A1的內容以產生第一模型輸入檔案B1。在本發明的其他實施例中,第一問題描述檔案A1亦可使用非固定格式之文字條列與系統問題相關的資訊。 1 is a schematic diagram of a solution search system 100 in accordance with an embodiment of the present invention. The solution search 100 includes an arithmetic server 110, a model server 120, a huge database 130, a database server 140, and a hub server 150. The computing server 110 can be used to generate the first model input file B1 according to the first problem description file A1. The first problem description file A1 is a problem description file that has not yet been solved. It can use text to describe information related to product system problems. The content can include descriptions of system problems and phenomena, subsystems to which system problems belong, and problems that occur ( That is, it can explain how to copy the problem), but it is not limited to the above information. In an embodiment of the present invention, the first problem description file A1 may use a fixed format (such as but not limited to a text file format such as csv, json, xml, etc.) to list information related to system problems, so that the computing server 110 can The content of the first problem description file A1 is relatively accurately interpreted to generate the first model input file B1. In other embodiments of the present invention, the first problem description file A1 may also use information in a non-fixed format text column related to system problems.

在本發明之一實施例中,運算伺服器110可根據第一問題描述檔案A1之文字產生關鍵詞(attributes)描述檔案。關鍵詞(attributes)描述檔案可由多個關鍵詞(attributes)所組成,每一個關鍵詞是由一對關鍵詞名字(attribute name)與關鍵詞之值(attribute value)所組成,在本發明之一實施例中,可以json之文字格式來描述。當第一問題描述檔案A1使用非固定格式文字條列與系統問題相關的資訊時,運算伺服器110亦可使用正規表示法(regular expression)來識別關鍵詞名字與取得關鍵詞之值。再者,運算伺服器110可利用標準詞對照 表與第一問題描述檔案A1之文字對照以產生關鍵詞描述檔案。表1為本發明一實施例之標準詞對照表的部分內容。透過標準詞對照表可以標準化同義之字彙與詞彙,如此即可較有效率地表達關鍵詞描述檔案之語意。此外,為避免關鍵詞描述檔案之語意之混淆,所有關鍵詞之值皆可以小寫表示。 In an embodiment of the present invention, the computing server 110 may describe a text description attribute file of the file A1 according to the first problem. The attribute description file may be composed of a plurality of keywords, each of which is composed of a pair of attribute name and attribute value, and is one of the present inventions. In the embodiment, it can be described in the text format of json. When the first problem description file A1 uses non-fixed format text bar information related to system problems, the computing server 110 may also use a regular expression to identify the keyword name and the value of the obtained keyword. Furthermore, the computing server 110 can use standard word comparison The table is compared with the text of the first problem description file A1 to generate a keyword description file. Table 1 is a partial view of a standard word comparison table according to an embodiment of the present invention. Syntactic vocabulary and vocabulary can be standardized through the standard word comparison table, so that the meaning of the keyword description file can be expressed more efficiently. In addition, in order to avoid the confusion of the semantics of the keyword description file, the values of all keywords can be represented in lowercase.

完成關鍵詞描述檔案後,運算伺服器110可自關鍵詞描述檔案中挑選出預測因子(predictors)以產生預測因子檔案,再根據預測因子檔案及預測模型產生第一模型輸入檔案B1,例如運算伺服器110可根據預測模型(例如CBayes模型)之特性調整預測因子檔案,而將預測因子檔案中的數字部分刪除,以產生第一模型輸入檔案B1,然而不同的預測模型對於輸入檔案的格式有不同要求,本發明並不以上述實施例為限。 After completing the keyword description file, the computing server 110 may select predictors from the keyword description file to generate a predictor file, and then generate a first model input file B1 according to the predictive factor file and the prediction model, such as an arithmetic servo. The predictor file may be adjusted according to the characteristics of the predictive model (for example, the CBayes model), and the digital portion of the predictor file may be deleted to generate the first model input file B1. However, different prediction models have different formats for the input file. It is to be understood that the invention is not limited to the above embodiments.

模型伺服器120可用以根據第一模型輸入檔案B1及預測模型產生第一解決方案代碼C1,而資料庫伺服器140即可用以根據第一解決方案代碼C1由巨量資料庫130讀取第一解決方案D1。中樞伺服器150可用以在接收到第一問題描述檔案A1時,將第一問題描述檔案A1傳送至運算伺服器110,再將運算伺服器110所產生之第一模型輸入檔案B1傳送至模型伺服器120,並將模型伺服器120所產生之第一解決方案代碼C1傳送至資料庫伺服器130,最後則輸出資料庫伺服器140由巨量資料庫130讀取之第一解決方案D1。在本發明之一實施例中,資料庫伺服器140及巨量資料庫130可為支援Hadoop Distribute File System(HDFS)、Hadoop Map/Reduce及Hive...等系統之資料庫伺服器及 巨量資料庫,或可支援其他適合處理巨量資料的資料庫系統,以符合解決方案搜尋系統100對於快速處理、儲存大量資料的需求。而解決方案搜尋系統100可另包含一般檔案系統與關聯式資料庫。關聯式資料庫(如MySql、PostgreSql...等關聯式資料庫)是基於一般檔案系統,並用以提供儲存中樞伺服器150在運算時所需的小量或暫時性的資料。 The model server 120 can be configured to generate the first solution code C1 according to the first model input file B1 and the prediction model, and the database server 140 can be used to read the first file from the huge database 130 according to the first solution code C1. Solution D1. The hub server 150 can be configured to transmit the first problem description file A1 to the computing server 110 when receiving the first problem description file A1, and then transmit the first model input file B1 generated by the computing server 110 to the model server. The first solution code C1 generated by the model server 120 is transmitted to the database server 130, and finally the first database solution D1 is read by the database server 140 by the huge database 130. In an embodiment of the present invention, the database server 140 and the huge database 130 can be database servers supporting systems such as Hadoop Distribute File System (HDFS), Hadoop Map/Reduce, and Hive. A huge database, or other database system suitable for processing huge amounts of data, to meet the needs of the solution search system 100 for quickly processing and storing large amounts of data. The solution search system 100 can additionally include a general file system and an associated database. The associated database (such as MySql, PostgreSql, etc.) is based on the general file system and is used to provide a small amount or temporary data required for the storage of the hub server 150.

此外,解決方案搜尋系統100還可包含網頁伺服器160。使用者可透過網頁伺服器160所提供的網頁介面輸入第一問題描述檔案A1,而網頁伺服器160接收到第一問題描述檔案A1後,可將第一問題描述檔案A1傳送至中樞伺服器150,並於網頁介面上顯示中樞伺服器150所輸出之第一解決方案D1。 Additionally, the solution search system 100 can also include a web server 160. The user can input the first problem description file A1 through the webpage interface provided by the web server 160, and after receiving the first problem description file A1, the web server 160 can transmit the first problem description file A1 to the hub server 150. And displaying the first solution D1 output by the hub server 150 on the web interface.

透過上述本發明實施例之解決方案搜尋系統100,即可使工程師分享彼此過去解決系統問題的經驗,而能輕易地搜尋到可能的解決方案以減少解決產品問題的時間,並提升解決方案的品質。 Through the above-described solution searching system 100 of the embodiment of the present invention, engineers can share their experiences in solving system problems in the past, and can easily find possible solutions to reduce the time for solving product problems and improve the quality of the solution. .

在第1圖的實施例中,模型伺服器120所使用的預測模型M1可為事先已存在於系統內的模型,然而在本發明之另一實施例中,解決方案搜尋系統亦可用以建立預測模型。第2圖為本發明一實施例之解決方案搜尋系統200的示意圖,解決方案搜尋系統200與解決方案搜尋系統100可根據相同原理運作,然而解決方案搜尋系統200還包含建模伺服器170。當解決方案搜尋系統200之中樞伺服器150接收到複數個已解決之第二問題描述檔案A2時,中樞伺服器150可將接收到的複數個已解決之第二問題描述檔案A2傳送至運算伺服器110。每一個已解決之第二問題描述檔案A2可與第一問題描述檔案A1具有相同的格式,且每一個已解決之第二問題描述檔案A2除了可包含紀錄與系統問題的相關欄位,如系統問題及現象之描述、系統問題所屬之子系統、發生問題的經過...等欄位之外,尚可包含系統問題的成因說明欄位、解決方案欄位及解決方案代碼。 In the embodiment of FIG. 1, the prediction model M1 used by the model server 120 may be a model already existing in the system. However, in another embodiment of the present invention, the solution search system may also be used to establish a prediction. model. 2 is a schematic diagram of a solution search system 200 according to an embodiment of the present invention. The solution search system 200 and the solution search system 100 can operate according to the same principle. However, the solution search system 200 further includes a modeling server 170. When the solution search system 200 hub server 150 receives a plurality of resolved second problem description files A2, the hub server 150 may transmit the received plurality of resolved second problem description files A2 to the operation servo. 110. Each of the resolved second problem description files A2 may have the same format as the first problem description file A1, and each of the resolved second problem description files A2 may contain related fields such as records and system problems, such as a system. In addition to the description of the problem and the phenomenon, the subsystem to which the system problem belongs, the process of the problem, etc., the cause description field, the solution field and the solution code of the system problem can be included.

運算伺服器110在接收到複數個已解決之第二問題描述檔案A2後, 即可根據每一第二問題描述檔案A2產生每一個已解決之第二問題描述檔案A2所對應之第二模型輸入檔案B2及第二解決方案D2。中樞伺服器150可將每一個第二問題描述檔案A2所對應之第二解決方案D2傳送至資料庫伺服器140,使資料庫伺服器140可根據每一個第二解決方案D2所包含之第二解決方案代碼D’2將每一第二解決方案D2儲存在巨量資料庫140。同時,中樞伺服器150可將每一已解決之第二問題描述檔案A2所對應之第二模型輸入檔案B2及第二解決方案代碼D’2傳送至建模伺服器170,以使建模伺服器170根據每一已解決之第二問題描述檔案A2所對應之第二模型輸入檔案B2及第二解決方案代碼D’2建立預測模型。建模伺服器170可以根據不同的資料探勘演算法來建立預測模型,在本發明之一實施例中,建模伺服器170可以利用適用於資料探勘之演算法如Bayes、CBayes或SGD來建立預測模型。 After receiving the plurality of solved second problem description files A2, the computing server 110 According to each second problem description file A2, a second model input file B2 and a second solution D2 corresponding to each of the solved second problem description files A2 are generated. The hub server 150 can transmit the second solution D2 corresponding to each second problem description file A2 to the database server 140, so that the database server 140 can be included according to each second solution D2. Solution code D'2 stores each second solution D2 in a huge database 140. At the same time, the hub server 150 can transmit the second model input file B2 and the second solution code D'2 corresponding to each of the solved second problem description files A2 to the modeling server 170 to make the modeling servo. The controller 170 establishes a prediction model according to the second model input file B2 and the second solution code D'2 corresponding to the second problem description file A2. The modeling server 170 can establish a prediction model according to different data exploration algorithms. In an embodiment of the invention, the modeling server 170 can use a algorithm suitable for data exploration such as Bayes, CBayes or SGD to establish a prediction. model.

在本發明的一實施例中,運算伺服器110可根據每一第二問題描述檔案A2中複數個關鍵欄位之文字,如紀錄問題所屬之子系統(例如為bios、bmc、power、thermal、mechanical、hardware、os、driver)的欄位、系統問題的成因說明欄位及解決方案欄位中的文字敘述,產生每一第二問題描述檔案A2所對應之第二解決方案D2,所產生的每一個第二解決方案D2包含第二解決方案代碼D’2、解決方案欄位及成因說明欄位。在本發明一實施例中,解決方案欄位可用以紀錄解決步驟文件所存放之位址,如網路位址,而非直接紀錄解決方案的步驟,如此即可避免因為解決步驟太過繁複與相關資料太大,而不必要地增加運算伺服器110的負擔。 In an embodiment of the present invention, the computing server 110 can describe the characters of the plurality of key fields in the file A2 according to each second question, such as the subsystem to which the recording problem belongs (for example, bios, bmc, power, thermal, mechanical). , hardware, os, driver) field, system problem description field and text description in the solution field, resulting in each second problem description file A2 corresponding to the second solution D2, each generated A second solution D2 includes a second solution code D'2, a solution field, and a description field. In an embodiment of the present invention, the solution field can be used to record the address stored in the step file, such as the network address, instead of directly recording the solution steps, so that the solution step is too complicated. The related information is too large, and the burden on the computing server 110 is unnecessarily increased.

此外,雖然每一個第二問題描述檔案A2中原本即可能已包含其所對應的解決方案代碼,然而運算伺服器110可進一步根據第二問題描述檔案A2中其他欄位,如成因說明欄位、子系統欄位,的資訊來調整最終每一個第二解決方案中所包含的第二解決方案代碼。例如可根據成因說明欄位之內容取得關鍵字的方式以產生解決方案代碼,使得凡是具有相同成因說明之解決方案皆可具有相同之解決方案代碼。 In addition, although each second problem description file A2 may have originally included its corresponding solution code, the computing server 110 may further describe other fields in the file A2 according to the second problem, such as a description field, The subsystem field, the information to adjust the second solution code included in each of the final second solutions. For example, the solution code can be generated according to the content of the cause description field to generate a solution code, so that all solutions with the same cause description can have the same solution code.

。例如在本發明的一實施例中,若有一第二問題描述檔案的解決方案代碼包含複數個子代碼,如bios.mrc,其中bios表示第二問題描述檔案與基本輸入輸出系統(basic input/output system)相關,而mrc表示第二問題描述檔案係與基本輸入輸出系統中的記憶體參照碼(memory reference code)相關,則運算伺服器110可以根據其他欄位的資訊將第二問題描述檔案中的解決方案代碼bios.mrc擴充至bios.mrc.i2c,表示第二問題描述檔案係與基本輸入輸出系統中記憶體參照碼的內部整合電路(Inter-integrated circuit,I2C)相關。亦即當解決方案代碼所包含的子代碼數目越多時,表示將問題分類得越細。由於解決方案代碼所包含的子代碼數目可能影響到解決方案搜尋系統200的搜尋速度及準確度,因此可根據各系統的需求來調整。 . For example, in an embodiment of the present invention, if there is a second problem description, the solution code of the file includes a plurality of subcodes, such as bios.mrc, where bios represents the second problem description file and the basic input/output system (basic input/output system). Correlation, and mrc indicates that the second problem description file system is related to the memory reference code in the basic input/output system, and the operation server 110 can describe the second problem in the file according to the information of other fields. The solution code bios.mrc is extended to bios.mrc.i2c, indicating that the second problem description file is associated with an inter-integrated circuit (I2C) of the memory reference code in the basic input/output system. That is, when the number of subcodes included in the solution code is larger, it means that the problem is classified as finer. Since the number of subcodes included in the solution code may affect the search speed and accuracy of the solution search system 200, it can be adjusted according to the needs of each system.

在資料庫伺服器140根據每一個第二解決方案D2所包含之第二解決方案代碼D’2將每一第二解決方案D2儲存在巨量資料庫130,且建模伺服器170完成建立預測模型後,解決方案搜尋系統200即可利用建模伺服器170所建立之預測模型來搜尋系統問題的可能解決方案。而在前述的實施例中,當資料庫伺服器140根據模型伺服器120所產生的第一解決方案代碼C1欲由巨量資料庫130讀取第一解決方案D1時,資料庫伺服器140所讀取的第一方案D1即可為複數個第二解決方案D2中具有與第一解決方案代碼C1相符之第二解決方案代碼D’2的第二解決方案,且與第一解決方案代碼C1相符之第二解決方案代碼D’2所包含之子代碼的數目不少於第一解決方案代碼C1所包含之子代碼的數目。 Each of the second solutions D2 is stored in the huge database 130 by the database server 140 according to the second solution code D'2 included in each of the second solutions D2, and the modeling server 170 completes the prediction establishment. After the model, the solution search system 200 can utilize the predictive model established by the modeling server 170 to search for possible solutions to system problems. In the foregoing embodiment, when the database server 140 reads the first solution D1 from the huge database 130 according to the first solution code C1 generated by the model server 120, the database server 140 The read first solution D1 may be a second solution of the plurality of second solutions D2 having the second solution code D'2 corresponding to the first solution code C1, and the first solution code C1 The number of subcodes included in the matching second solution code D'2 is not less than the number of subcodes included in the first solution code C1.

此外,在本發明一實施例中,解決方案搜尋系統200中,中樞伺服器150與運算伺服器110、資料庫伺服器140、模型伺服器120及建模伺服器170之間可透過網路封包及中樞伺服器150、運算伺服器110、資料庫伺服器140、模型伺服器120及建模伺服器170之應用程式介面(application programming interface,API)傳送檔案與通訊。在本發明之一實施例中,可利用使用者資料協定(User Datagram Protocol,UDP)埠或傳輸控制協定(Transmission Control Protocol,TCP)埠來達成應用程式介面間之遠端程式呼叫(Remote Procedure Call,RPC),如此一來,解決方案搜尋系統200即可以分散式的方式建構,而有利於系統擴充及維護。 In addition, in an embodiment of the present invention, in the solution search system 200, the hub server 150 and the computing server 110, the database server 140, the model server 120, and the modeling server 170 are permeable to each other. The application server (API) of the hub server 150, the computing server 110, the database server 140, the model server 120, and the modeling server 170 transmits files and communications. In an embodiment of the present invention, a User Datagram Protocol (UDP) or a Transmission Control Protocol (Transmission Control) may be utilized. Protocol, TCP) to achieve the Remote Procedure Call (RPC) between the application interfaces, so that the solution search system 200 can be constructed in a decentralized manner, which is beneficial to system expansion and maintenance.

綜上所述,本發明之解決方案搜尋系統200可透過巨量資料庫及資料探勘的演算法使工程師分享彼此過去解決系統問題的經驗,而能輕易地搜尋到可能的解決方案以減少解決產品問題的時間,並提升解決方案品質。 In summary, the solution search system 200 of the present invention enables engineers to share their past experiences in solving system problems through a huge database and data exploration algorithms, and can easily find possible solutions to reduce solution products. Time for problems and improve the quality of the solution.

第3圖為本發明一實施例中,解決方案搜尋系統100之操作方法300之流程圖。解決方案搜尋系統之操作方法300包含步驟S310至S370:S310:當中樞伺服器150接收到第一問題描述檔案時,中樞伺服器150將第一問題描述檔案傳送至運算伺服器110;S320:運算伺服器110根據第一問題描述檔案產生第一模型輸入檔案;S330:中樞伺服器150將第一模型輸入檔案傳送至模型伺服器120;S340:模型伺服器120根據第一模型輸入檔案及預測模型取得第一解決方案代碼;S350:中樞伺服器150將第一解決方案代碼傳送至資料庫伺服器140;S360:資料庫伺服器140根據第一解決方案代碼讀取儲存於巨量資料庫130之第一解決方案;S370:中樞伺服器150輸出由巨量資料庫140讀取之第一解決方案。 FIG. 3 is a flow diagram of an operation method 300 of the solution search system 100 in accordance with an embodiment of the present invention. The operation method 300 of the solution search system includes steps S310 to S370: S310: when the hub server 150 receives the first problem description file, the hub server 150 transmits the first problem description file to the operation server 110; S320: operation The server 110 generates a first model input file according to the first problem description file; S330: the hub server 150 transmits the first model input file to the model server 120; S340: the model server 120 inputs the file and the prediction model according to the first model Obtaining a first solution code; S350: the hub server 150 transmits the first solution code to the database server 140; S360: the database server 140 reads the stored in the huge database 130 according to the first solution code First solution; S370: The hub server 150 outputs the first solution read by the huge database 140.

第4圖說明為本發明另一實施例中,解決方案搜尋系統200之操作方法400之流程圖。解決方案搜尋系統之操作方法400包含步驟S410至S450:S410:當中樞伺服器150接收到複數個已解決之第二問題描述檔 案時,中樞伺服器150將複數個已解決之第二問題描述檔案傳送至運算伺服器110;S420:運算伺服器110根據複數個已解決之第二問題描述檔案產生每一已解決之第二問題描述檔案所對應之第二模型輸入檔案及第二解決方案;S430:資料庫伺服器140根據每一第二解決方案所包含之第二解決方案代碼儲存每一第二解決方案;S440:將每一已解決之第二問題描述檔案所對應之第二模型輸入檔案及第二解決方案代碼傳送至建模伺服器170;S450:建模伺服器170根據每一已解決之第二問題描述檔案所對應之第二模型輸入檔案、第二解決方案代碼及所選取之資料探勘演算法建立預測模型。 4 is a flow chart showing an operation method 400 of the solution search system 200 in another embodiment of the present invention. The operation method 400 of the solution search system includes steps S410 to S450: S410: the hub server 150 receives a plurality of solved second problem description files. In the case, the hub server 150 transmits a plurality of solved second problem description files to the computing server 110; S420: the computing server 110 generates each second solved according to the plurality of solved second problem description files. The second model input file corresponding to the problem description file and the second solution; S430: the database server 140 stores each second solution according to the second solution code included in each second solution; S440: The second model input file and the second solution code corresponding to each of the solved second problem description files are transmitted to the modeling server 170; S450: the modeling server 170 describes the file according to each of the solved second problems. The corresponding second model input file, the second solution code, and the selected data exploration algorithm establish a prediction model.

透過本發明上述實施例之解決方案搜尋系統100、200的操作方法300及400,即可利用巨量資料庫及資料探勘的演算法使工程師分享彼此過去解決系統問題的經驗,而能輕易地搜尋到可能的解決方案以減少解決產品問題的時間,並提升解決方案品質。 Through the operation methods 300 and 400 of the solution searching system 100, 200 of the above embodiment of the present invention, the algorithm of the huge database and the data exploration can be utilized to enable the engineers to share their experiences in solving system problems in the past, and can be easily searched. Probable solutions to reduce time to resolve product issues and improve solution quality.

綜上所述,本發明實施例之解決方案搜尋系統及解決方案搜尋系統之操作方法,可利用巨量資料庫及資料探勘的演算法,協助使用者分享彼此過去解決問題的經驗,而在使用者發現系統問題時,能輕易地搜尋到可能的解決方案以減少解決產品問題的時間。如此一來。就可以避免先前技術中,因為相關的解決方案搜尋不易,而導致解決系統問題的效率及品質難以控制的問題。 In summary, the solution search system and the solution search system operation method of the embodiments of the present invention can utilize a huge database and a data exploration algorithm to assist users in sharing their past experience in solving problems, while using When discovering system problems, it is easy to find possible solutions to reduce the time to resolve product issues. So come. It is possible to avoid the problems in the prior art because the related solutions are not easy to search, and the efficiency and quality of solving the system problems are difficult to control.

以上所述僅為本發明之較佳實施例,凡依本發明申請專利範圍所做之均等變化與修飾,皆應屬本發明之涵蓋範圍。 The above are only the preferred embodiments of the present invention, and all changes and modifications made to the scope of the present invention should be within the scope of the present invention.

300‧‧‧解決方案搜尋系統之操作方法 300‧‧‧How to find a solution search system

S310~S370‧‧‧步驟 S310~S370‧‧‧Steps

Claims (10)

一種解決方案搜尋系統,包含:一運算伺服器,用以根據一標準詞對照表與一第一問題描述檔案之文字對照以產生一關鍵詞描述檔案,根據該關鍵詞描述檔案產生一預測因子檔案,以及根據該預測因子檔案產生一第一模型輸入檔案;一模型伺服器,用以根據該第一模型輸入檔案及一預測模型產生一第一解決方案代碼;一巨量資料庫;一資料庫伺服器,用以根據該第一解決方案代碼由該巨量資料庫讀取一第一解決方案;及一中樞伺服器,用以:當接收到該第一問題描述檔案時,將該第一問題描述檔案傳送至該運算伺服器;將該運算伺服器所產生之該第一模型輸入檔案傳送至該模型伺服器;將該模型伺服器所產生之該第一解決方案代碼傳送至該資料庫伺服器;及輸出該資料庫伺服器由該巨量資料庫讀取之該第一解決方案。 A solution search system includes: an operation server for comparing a text of a first problem description file with a standard word comparison table to generate a keyword description file, and generating a predictive factor file according to the keyword description file And generating a first model input file according to the predictive factor file; a model server for generating a first solution code according to the first model input file and a prediction model; a huge database; a database a server for reading a first solution from the huge database according to the first solution code; and a hub server, configured to: when receiving the first problem description file, the first Transmitting a problem description file to the computing server; transmitting the first model input file generated by the computing server to the model server; transmitting the first solution code generated by the model server to the database The server; and outputting the first solution that the database server reads from the huge database. 如請求項1所述之解決方案搜尋系統,其中該中樞伺服器另用以:當該中樞伺服器接收到複數個已解決之第二問題描述檔案時,將該些已解決之第二問題描述檔案傳送至該運算伺服器,以使該運算伺服器根據該些已解決之第二問題描述檔案產生每一已解決之第二問題描述檔案所對應之一第二模型輸入檔案及一第二解決方案;使該資料庫伺服器根據每一第二解決方案所包含之一第二解決方案代碼 儲存每一第二解決方案;及將每一已解決之第二問題描述檔案所對應之該第二模型輸入檔案及該第二解決方案代碼傳送至一建模伺服器,以使該建模伺服器根據每一已解決之第二問題描述檔案所對應之該第二模型輸入檔案、該第二解決方案代碼及一資料探勘演算法建立該預測模型;其中該資料庫伺服器由該巨量資料庫讀取之該第一解決方案係為該些第二解決方案中,具有與該第一解決方案代碼相符之一第二解決方案代碼之一第二解決方案。 The solution search system of claim 1, wherein the hub server is further configured to: when the hub server receives the plurality of solved second problem description files, describe the second problem that has been solved Transmitting the file to the computing server, so that the computing server generates a second model input file corresponding to each of the solved second problem description files according to the second problem description file that has been solved and a second solution Solution; enabling the database server to include a second solution code according to each of the second solutions Storing each second solution; and transmitting the second model input file and the second solution code corresponding to each of the solved second problem description files to a modeling server to make the modeling servo The predictive model is established according to the second model input file corresponding to each of the solved second problem description files, the second solution code, and a data exploration algorithm; wherein the database server is configured by the huge amount of data The first solution read by the library is one of the second solutions in the second solution having one of the second solution codes in accordance with the first solution code. 如請求項2所述之解決方案搜尋系統,其中該第一解決方案代碼及每一第二解決方案代碼各包含至少一子代碼,且與該第一解決方案代碼相符之該第二解決方案代碼所包含之子代碼的數目不少於該第一解決方案代碼所包含之子代碼的數目。 The solution search system of claim 2, wherein the first solution code and each second solution code each include at least one subcode, and the second solution code conforms to the first solution code The number of subcodes included is not less than the number of subcodes included in the first solution code. 如請求項2所述之解決方案搜尋系統,其中該運算伺服器係根據每一第二問題描述檔案中複數個關鍵欄位之文字產生每一第二問題描述檔案所對應之該第二解決方案,每一第二解決方案包含該第二解決方案代碼、一解決方案欄位及一成因說明欄位,該解決方案欄位係存放一解決步驟文件所存放之一位址。 The solution search system of claim 2, wherein the computing server generates the second solution corresponding to each second problem description file according to the text of the plurality of key fields in each second problem description file. Each second solution includes the second solution code, a solution field, and a cause description field, and the solution field stores one address stored in the solution step file. 如請求項1所述之解決方案搜尋系統,另包含一網頁伺服器,用以提供一網頁介面以接收該第一問題描述檔案,將該第一問題描述檔案傳送之該中樞伺服器,及於該網頁介面上顯示該中樞伺服器所輸出之該第一解決方案。 The solution search system of claim 1, further comprising a webpage server for providing a webpage interface for receiving the first problem description file, transmitting the first problem description file to the hub server, and The webpage interface displays the first solution output by the hub server. 一種解決方案搜尋系統之操作方法,該解決方案搜尋系統包含一運算 伺服器、一模型伺服器、一巨量資料庫、一資料庫伺服器及一中樞伺服器,該方法包含:當該中樞伺服器接收到一第一問題描述檔案時,該中樞伺服器將該第一問題描述檔案傳送至該運算伺服器;該運算伺服器利用一標準詞對照表與一第一問題描述檔案之文字對照以產生一關鍵詞描述檔案;該運算伺服器根據該關鍵詞描述檔案產生一預測因子檔案;該運算伺服器根據該預測因子檔案產生一第一模型輸入檔案;該中樞伺服器將該第一模型輸入檔案傳送至該模型伺服器;該模型伺服器根據該第一模型輸入檔案及一預測模型取得一第一解決方案代碼;該中樞伺服器將該第一解決方案代碼傳送至該資料庫伺服器;該資料庫伺服器根據該第一解決方案代碼讀取儲存於該巨量資料庫之一第一解決方案;及該中樞伺服器輸出由該巨量資料庫讀取之該第一解決方案。 A method of operating a solution search system that includes an operation a server, a model server, a huge database, a database server, and a hub server, the method includes: when the hub server receives a first problem description file, the hub server The first problem description file is transmitted to the computing server; the computing server compares the text of a first problem description file with a standard word comparison table to generate a keyword description file; the computing server describes the file according to the keyword Generating a predictive factor file; the computing server generates a first model input file according to the predictive factor file; the hub server transmits the first model input file to the model server; the model server is based on the first model Entering a file and a prediction model to obtain a first solution code; the hub server transmits the first solution code to the database server; the database server reads and stores the first solution code according to the first solution code One of the first solutions of the huge database; and the hub server outputs the first solution read by the huge database 如請求項6所述之方法,該解決方案搜尋系統另包含一建模伺服器,該方法另包含:當該中樞伺服器接收到複數個已解決之第二問題描述檔案時,該中樞伺服器將該些已解決之第二問題描述檔案傳送至該運算伺服器;該運算伺服器根據該些已解決之第二問題描述檔案產生每一已解決之第二問題描述檔案所對應之一第二模型輸入檔案及一第二解決方案;該資料庫伺服器根據每一第二解決方案所包含之一第二解決方案代碼儲存每一第二解決方案;將每一已解決之第二問題描述檔案所對應之該第二模型輸入檔案及該第二解決方案代碼傳送至該建模伺服器;及 該建模伺服器根據每一已解決之第二問題描述檔案所對應之該第二模型輸入檔案、該第二解決方案代碼及一資料探勘演算法建立該預測模型;其中該資料庫伺服器由該巨量資料庫讀取之該第一解決方案係為該些第二解決方案中,具有與該第一解決方案代碼相符之一第二解決方案代碼之一第二解決方案。 The method of claim 6, the solution search system further comprising a modeling server, the method further comprising: when the hub server receives the plurality of solved second problem description files, the hub server Transmitting the solved second problem description file to the computing server; the computing server generates a second file corresponding to each of the solved second problem description files according to the solved second problem description file a model input file and a second solution; the database server stores each second solution according to one of the second solution codes included in each second solution; and each of the solved second problem description files Corresponding the second model input file and the second solution code are transmitted to the modeling server; and The modeling server establishes the prediction model according to the second model input file corresponding to each of the solved second problem description files, the second solution code, and a data exploration algorithm; wherein the database server is configured by The first solution read by the massive database is one of the second solutions in the second solution having one of the second solution codes in accordance with the first solution code. 如請求項7所述之方法,其中該第一解決方案代碼及每一第二解決方案代碼各包含至少一子代碼,且與該第一解決方案代碼相符之該第二解決方案代碼所包含之子代碼的數目不少於該第一解決方案代碼所包含之子代碼的數目。 The method of claim 7, wherein the first solution code and each of the second solution codes each include at least one subcode, and the second solution code conforms to the first solution code The number of codes is not less than the number of subcodes included in the first solution code. 如請求項7所述之方法,其中使該運算伺服器根據該些已解決之第二問題描述檔案產生每一已解決之第二問題描述檔案所對應之該第二解決方案係為使該運算伺服器根據每一第二問題描述檔案中複數個關鍵欄位之文字產生每一第二問題描述檔案所對應之該第二解決方案,其中每一第二解決方案包含該第二解決方案代碼、一解決方案欄位及一成因說明欄位,該解決方案欄位存放一解決步驟文件所存放之一位址。 The method of claim 7, wherein the computing server generates the second solution corresponding to each of the solved second problem description files according to the solved second problem description file to make the operation The server generates the second solution corresponding to each second problem description file according to the text of the plurality of key fields in the second problem description file, wherein each second solution includes the second solution code, A solution field and a cause description field, the solution field stores an address stored in a solution step file. 如請求項6所述之解決方案搜尋系統之操作方法,該解決方案搜尋系統另包含一網路伺服器,該方法另包含:使該網路伺服器提供一網頁介面以接收該第一問題描述檔案;使該網路伺服器將該第一問題描述檔案傳送之該中樞伺服器;及使該網路伺服器於該網頁介面上顯示該中樞伺服器所輸出之該第一解決方案。 The method for operating a solution search system according to claim 6, wherein the solution search system further comprises a network server, the method further comprising: causing the network server to provide a webpage interface to receive the first problem description Archive; causing the network server to transmit the first problem description file to the hub server; and causing the network server to display the first solution output by the hub server on the web interface.
TW103142674A 2014-12-08 2014-12-08 Method of operating a solution searching system and solution searching system TWI563402B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW103142674A TWI563402B (en) 2014-12-08 2014-12-08 Method of operating a solution searching system and solution searching system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW103142674A TWI563402B (en) 2014-12-08 2014-12-08 Method of operating a solution searching system and solution searching system

Publications (2)

Publication Number Publication Date
TW201621712A true TW201621712A (en) 2016-06-16
TWI563402B TWI563402B (en) 2016-12-21

Family

ID=56755502

Family Applications (1)

Application Number Title Priority Date Filing Date
TW103142674A TWI563402B (en) 2014-12-08 2014-12-08 Method of operating a solution searching system and solution searching system

Country Status (1)

Country Link
TW (1) TWI563402B (en)

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW359778B (en) * 1997-11-04 1999-06-01 Inventec Corp Expert-assisted problem solving system
TW200620024A (en) * 2004-12-10 2006-06-16 Hon Hai Prec Ind Co Ltd System for managing problems
TWI449002B (en) * 2008-01-04 2014-08-11 Yen Wu Hsieh Answer search system and method
US8010477B2 (en) * 2008-03-14 2011-08-30 Caterpillar Inc. Integrated problem solving system
TWI419071B (en) * 2010-03-05 2013-12-11 Ceci Engineering Consultants Inc Active knowledge management system, method and computer program product for problem solving
TW201421385A (en) * 2012-11-28 2014-06-01 Univ Nat Changhua Education Community intellectual problem-solving system and method thereof

Also Published As

Publication number Publication date
TWI563402B (en) 2016-12-21

Similar Documents

Publication Publication Date Title
US11030230B2 (en) System and method for providing technology assisted data review with optimizing features
US10360277B2 (en) Controlling data migration
US10162550B2 (en) Large-scale, dynamic graph storage and processing system
US10353874B2 (en) Method and apparatus for associating information
US20140129912A1 (en) System and Method for Express Spreadsheet Visualization for Building Information Modeling
US10936645B2 (en) Method and apparatus for generating to-be-played multimedia content
US11403303B2 (en) Method and device for generating ranking model
CN108958959B (en) Method and device for detecting hive data table
US20180322200A1 (en) Analytics based on pipes programming model
WO2019019647A1 (en) Method and system for determining application program testing range, server and storage medium
CN112463991B (en) Historical behavior data processing method and device, computer equipment and storage medium
US20150379112A1 (en) Creating an on-line job function ontology
CN111046085B (en) Data tracing processing method and device, medium and equipment
WO2018171289A1 (en) Method and device for storing data to database, middleware device, and server
US20170124214A1 (en) Determining data field offsets using a document object model representation
US8458205B2 (en) Identifying a group of products relevant to data provided by a user
TWI574169B (en) Method of operating a solution searching system and solution searching system
TW201621712A (en) Method of operating a solution searching system and solution searching system
TWI604322B (en) Solution searching system and method for operating a solution searching system
TWI579719B (en) Solution searching system and method for operating a solution searching system
US20180293315A1 (en) Device for multiple condition search based on knowledge points
US20220114189A1 (en) Extraction of structured information from unstructured documents
CN113032469B (en) Text structured model training and medical text structuring method and device
CN106503176B (en) Solution searching system and operation method thereof
US11675838B2 (en) Automatically completing a pipeline graph in an internet of things network