TWI567577B - 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
TWI567577B
TWI567577B TW104136427A TW104136427A TWI567577B TW I567577 B TWI567577 B TW I567577B TW 104136427 A TW104136427 A TW 104136427A TW 104136427 A TW104136427 A TW 104136427A TW I567577 B TWI567577 B TW I567577B
Authority
TW
Taiwan
Prior art keywords
solution
server
category
description file
file
Prior art date
Application number
TW104136427A
Other languages
Chinese (zh)
Other versions
TW201717063A (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 TW104136427A priority Critical patent/TWI567577B/en
Application granted granted Critical
Publication of TWI567577B publication Critical patent/TWI567577B/en
Publication of TW201717063A publication Critical patent/TW201717063A/en

Links

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 the product requires a large number of tests to ensure the stability of the product, especially for high-stability, high-reliability technology products such as industrial instruments, mobile devices, workstations, personal computers. Or products such as servers, etc., the standards for quality control testing are more stringent. When a product is detected, it must be done by copying the problem, collecting and analyzing the relevant information, identifying the cause of the problem, suggesting possible solutions, and verifying the proposed solution... to ensure that the detected problem is Properly resolved, these processes may not only be very time consuming, but may even lead to missed opportunities for the product to enter the market, and implementation must rely on the personal experience and professionalism of the engineer; that is, whether the engineer's experience and professionalism are sufficient will be greatly It affects the time required to propose a solution, and it 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 Engineers may not be able to describe the problem in a way that is inconsistent, so it is difficult to systematically store it. Therefore, in practice, engineers are still not easy to find relevant solutions, 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.

本發明之實施例提供一種解決方案搜尋系統。解決方案搜尋系統包含巨量資料庫、關聯式資料庫、運算伺服器、模型伺服器、資料庫伺服器及中樞伺服器。運算伺服器用以根據標準詞對照表與問題描述檔案之文字對照以產生關鍵詞描述檔案,根據關鍵詞描述檔案產生預測因子檔案,及根據預測因子檔案產生模型輸入檔案。模型伺服器用以根據模型輸入檔案及資料探勘預測模型產生預測解決方案類別。資料庫伺服器用以根據問題描述檔案所對應之解決方案類別自巨量資料庫讀取至少一解決方案。中樞伺服器用以當接收到問題描述檔案時,將問題描述檔案傳送至運算伺服器,將運算伺服器所產生之模型輸入檔案傳送至模型伺服器,當關聯式資料庫儲存有問題描述檔案所對應之至少一自選方案類別時,選擇至少一自選方案類別中權重最高之第一自選方案類別作為解決方案類別,將解決方案類別傳送至資料庫伺服器,及根據關聯式資料庫中每一解決方案對應於解決方案類別之權重,依序輸出至少一解決方案。Embodiments of the present invention provide a solution search system. The solution search system includes a huge database, an associated database, a computing server, a model server, a database server, and a hub server. The computing server is configured to generate a keyword description file according to the standard word comparison table and the text of the problem description file, generate a prediction factor file according to the keyword description file, and generate a model input file according to the prediction factor file. The model server is used to generate a prediction solution category based on the model input file and the data mining prediction model. The database server is configured to read at least one solution from the huge database according to the solution category corresponding to the problem description file. The central server is configured to transmit the problem description file to the computing server when receiving the problem description file, and transmit the model input file generated by the computing server to the model server, and store the problem description file in the associated database. Corresponding to at least one option category, selecting at least one of the at least one option category having the highest weight of the first option category as the solution category, transmitting the solution category to the database server, and each solution according to the associated database The solution corresponds to the weight of the solution category, and at least one solution is sequentially output.

本發明之另一實施例提供一種解決方案搜尋系統之操作方法。解決方案搜尋系統包含運算伺服器、模型伺服器、關聯式資料庫、巨量資料庫、資料庫伺服器及中樞伺服器。方法包含:當中樞伺服器接收到問題描述檔案時,中樞伺服器將問題描述檔案傳送至運算伺服器,運算伺服器利用標準詞對照表與問題描述檔案之文字對照以產生關鍵詞描述檔案,運算伺服器根據關鍵詞描述檔案產生預測因子檔案,運算伺服器根據預測因子檔案產生模型輸入檔案,中樞伺服器將模型輸入檔案傳送至模型伺服器,模型伺服器根據模型輸入檔案及資料探勘預測模型產生預測解決方案類別,當關聯式資料庫儲存有問題描述檔案所對應之至少一自選方案類別時,中樞伺服器選擇至少一自選方案類別中權重最高之第一自選方案類別作為解決方案類別,中樞伺服器將解決方案類別傳送至資料庫伺服器,資料庫伺服器根據解決方案類別讀取儲存於巨量資料庫之至少一解決方案,及中樞伺服器根據關聯式資料庫中每一解決方案對應於解決方案類別之權重,依序輸出由巨量資料庫讀取之至少一解決方案。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, an associated database, a huge database, a database server, and a hub server. The method includes: when the hub server receives the problem description file, the hub server transmits the problem description file to the operation server, and the operation server compares the text of the standard word comparison table with the problem description file to generate a keyword description file, and the operation The server generates a predictive factor file according to the keyword description file, and the computing server generates a model input file according to the predictive factor file, and the hub server transmits the model input file to the model server, and the model server generates the model input file and the data exploration prediction model according to the model input file. The predictive solution category, when the associated database stores at least one option category corresponding to the problem description file, the hub server selects the first option category with the highest weight among the at least one option category as the solution category, the central server Transmitting the solution category to the database server, the database server reads at least one solution stored in the huge database according to the solution category, and the central server corresponds to each solution according to the associated database Solution category Weights, output sequentially read by a massive library of at least a solution.

第1圖為本發明一實施例之解決方案搜尋系統100的示意圖。解決方案搜尋系統100包含運算伺服器110、模型伺服器120、巨量資料庫130、資料庫伺服器140、中樞伺服器150及關連式資料庫160。資料庫伺服器140及巨量資料庫130可為支援Hadoop Distribute File System (HDFS)、Hadoop Map/Reduce及Hive…等系統之資料庫伺服器及巨量資料庫,或可支援其他適合處理巨量資料的資料庫系統,以符合解決方案搜尋系統100對於快速處理、儲存大量資料的需求。而關聯式資料庫160(如MySql、PostgreSql…等關聯式資料庫)則可為一般檔案系統,並用以提供儲存中樞伺服器150在運算時所需的小量或暫時性的資料。1 is a schematic diagram of a solution search system 100 in accordance with an embodiment of the present invention. The solution search system 100 includes a computing server 110, a model server 120, a huge database 130, a database server 140, a hub server 150, and a connected database 160. The database server 140 and the huge database 130 can be used as a database server and a huge database for supporting systems such as Hadoop Distribute File System (HDFS), Hadoop Map/Reduce, and Hive..., or can support other suitable processing. The database system of the data is in compliance with the need for the solution search system 100 to quickly process and store large amounts of data. The associated database 160 (such as MySql, PostgreSql, etc.) can be a general file system, and is used to provide a small amount or temporary data required for the storage of the hub server 150.

當使用者欲利用方案搜尋系統100來搜尋解決方案時,使用者可將問題描述檔案A1輸入至解決方案搜尋系統100。當中樞伺服器150接受到問題描述檔案A1時,即可將問題描述檔案A1傳送至運算伺服器110。問題描述檔案A1中可透過文字描述與產品系統問題相關的資訊,內容可包含系統問題及現象之描述、系統問題所屬之子系統及發生問題的經過(亦即,可說明如何複製問題),但不限於上述資訊。在本發明之一實施例中,問題描述檔案A1可利用固定格式(例如但不限於csv、 json、xml等文字檔案格式)條列與系統問題相關的資訊,以使運算伺服器110能夠較為精確地判讀問題描述檔案A1的內容。When the user wants to use the solution search system 100 to search for a solution, the user can input the problem description file A1 to the solution search system 100. When the hub server 150 receives the problem description file A1, the problem description file A1 can be transmitted to the computing server 110. The problem description file A1 can describe the information related to the product system problem through text description. The content can include the description of the system problem and the phenomenon, the subsystem to which the system problem belongs, and the process of the problem (that is, how to copy the problem), but not Limited to the above information. In an embodiment of the present invention, the 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 be more accurate. The interpretation of the problem description file A1 content.

在本發明之一實施例中,運算伺服器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 generate an attribute description file according to the text of the problem description file A1. 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 problem description file A1 uses information related to the system problem in the non-fixed format text bar, the arithmetic server 110 can also use the regular expression to identify the word of the keyword and obtain the value of the keyword. Moreover, the computing server 110 can use the standard word comparison table to compare the text of the 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 correctly presented. 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.

表1 <TABLE border="1" borderColor="#000000" width="_0001"><TBODY><tr><td> “chip set” </td><td> “cs” </td></tr><tr><td> “chipset” </td><td> “cs” </td></tr><tr><td> “operation system” </td><td> “os” </td></tr><tr><td> “operation systems” </td><td> “os” </td></tr><tr><td> “system board” </td><td> “sb” </td></tr><tr><td> “mother board” </td><td> “sb” </td></tr><tr><td> “basic input output system”         </td><td> “bios” </td></tr><tr><td> “memory reference code” </td><td> “mrc” </td></tr><tr><td> “inter-integrated circuit”, “i2c” </td><td> “i2c” </td></tr></TBODY></TABLE>Table 1         <TABLE border="1" borderColor="#000000" width="_0001"><TBODY><tr><td> "chip set" </td><td> "cs" </td></tr> <tr><td> “chipset” </td><td> “cs” </td></tr><tr><td> “operation system” </td><td> “os” </td ></tr><tr><td> “operation systems” </td><td> “os” </td></tr><tr><td> “system board” </td><td> "sb" </td></tr><tr><td> "mother board" </td><td> "sb" </td></tr><tr><td> "basic input output system </td><td> “bios” </td></tr><tr><td> “memory reference code” </td><td> “mrc” </td></tr><tr ><td> “inter-integrated circuit”, “i2c” </td><td> “i2c” </td></tr></TBODY></TABLE>

由於關鍵詞的選擇可能會影響到解決方案搜尋系統100搜尋解決方案的精準度,因此在本發明的部分實施例中,中樞伺服器150亦可根據使用者的輸入內容來更新標準詞對照表,以增加解決方案搜尋系統100搜尋解決方案的精準度。In the embodiment of the present invention, the hub server 150 may also update the standard word comparison table according to the input content of the user, because the selection of the keyword may affect the accuracy of the solution search system 100 searching for the solution. To increase the accuracy of the solution search system 100 search solution.

完成關鍵詞描述檔案後,運算伺服器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 model input file B1 according to the predictive factor file and the predictive model. For example, the computing server 110 may adjust the predictor profile according to the characteristics of the predictive model (eg, the CBayes model), and delete the digital portion of the predictor file to generate the model input file B1, but different predictive models for the input file There are different requirements for the format, and the present invention is not limited to the above embodiments.

中樞伺服器150可將運算伺服器110所產生之模型輸入檔案B1傳送至模型伺服器120。模型伺服器120可根據模型輸入檔案B1及資料探勘預測模型M1產生預測解決方案類別P1。預測解決方案類別P1可用以預測問題描述檔案A1所屬的解決方案之類別。The hub server 150 can transmit the model input file B1 generated by the computing server 110 to the model server 120. The model server 120 can generate the prediction solution category P1 based on the model input file B1 and the data exploration prediction model M1. The predictive solution category P1 can be used to predict the category of the solution to which the problem description file A1 belongs.

在本發明的部分實施例中,解決方案類別可包含複數個子類別,舉例來說,若預測解決方案類別P1為bios.mrc.i2c,則其中bios表示問題描述檔案A1可能與基本輸入輸出系統(Basic Input/Output System,BIOS)相關,bios.mrc表示問題描述檔案A1可能與基本輸入輸出系統中的記憶體參照碼(memory reference code)相關,而bios.mrc.i2c則表示問題描述檔案A1可能與基本輸入輸出系統中記憶體參照碼的內部整合電路(Inter-integrated circuit, I2C)相關。In some embodiments of the present invention, the solution category may include a plurality of subcategories, for example, if the prediction solution category P1 is bios.mrc.i2c, where bios indicates that the problem description file A1 may be related to the basic input output system ( Basic Input/Output System, BIOS) related, bios.mrc indicates that the problem description file A1 may be related to the memory reference code in the basic input/output system, and bios.mrc.i2c indicates that the problem description file A1 may be It is related to the Inter-integrated Circuit (I2C) of the memory reference code in the basic input/output system.

由於模型伺服器120所產生的預測解決方案類別P1不一定正確,因此當使用者對自己提出的問題描述檔案A1已有相當程度的了解時,使用者也可以自行將對應於問題描述檔案A1的類別儲存在關聯式資料庫160中,即將使用者所選擇的自選方案類別儲存在關聯式資料庫160中,以增加搜尋到正確解決方案的機率。Since the prediction solution category P1 generated by the model server 120 is not necessarily correct, when the user has a considerable degree of understanding of the problem description file A1 proposed by the user, the user can also directly correspond to the problem description file A1. The categories are stored in the associated database 160, which stores the user selected option categories in the associated database 160 to increase the chances of finding the correct solution.

換言之,由於在實際利用解決方案搜尋系統100時,不同的使用者可能會遭遇到相同的問題而輸入相同的問題描述檔案,此時若能夠將每個使用者的經驗及看法加以整合,則應可進一步的增加解決方案搜尋系統100搜尋解決方案的精準度。為了讓不同使用者的意見和經驗能夠做為下一次搜尋的參考,解決方案搜尋系統100可讓使用者輸入對應於問題描述檔案的自選方案類別。另外考慮到每個使用者對於問題了解的程度可能不相同,因此不同使用者還可具有不同的身分權重。表2為本發明一實施例之使用者身分及其身分權重的對照表。In other words, since the different users may encounter the same problem and input the same problem description file when actually searching for the system 100, if the experience and opinions of each user can be integrated, then The accuracy of the solution search system 100 search solution can be further increased. In order to allow the opinions and experiences of different users to be used as a reference for the next search, the solution search system 100 allows the user to enter a self-selected program category corresponding to the problem description file. In addition, considering that each user may have different levels of understanding of the problem, different users may also have different identity weights. Table 2 is a comparison table of the user identity and the weight of the identity of an embodiment of the present invention.

表2 <TABLE border="1" borderColor="#000000" width="_0002"><TBODY><tr><td> 使用者身份 </td><td> 權重 </td></tr><tr><td> 專案管理者 </td><td> 5 </td></tr><tr><td> 技術經理 </td><td> 4 </td></tr><tr><td> 資深工程師 </td><td> 3 </td></tr><tr><td> 工程師 </td><td> 2 </td></tr><tr><td> 初階工程師 </td><td> 1 </td></tr><tr><td> 一般使用者 </td><td> 0 </td></tr></TBODY></TABLE>Table 2         <TABLE border="1" borderColor="#000000" width="_0002"><TBODY><tr><td> User Identity</td><td> Weight</td></tr><tr> <td> Project Manager</td><td> 5 </td></tr><tr><td> Technical Manager</td><td> 4 </td></tr><tr>< Td> Senior Engineer</td><td> 3 </td></tr><tr><td> Engineer</td><td> 2 </td></tr><tr><td> Engineer </td><td> 1 </td></tr><tr><td> General User</td><td> 0 </td></tr></TBODY></TABLE >

舉例來說,若使用者U1為專案管理者並具有身分權重為5,則當使用者U1輸入對應於問題描述檔案A1之自選方案類別,例如S1時,中樞伺服器150即可將自選方案類別S1與問題描述檔案A1間的對應關係儲存至關聯式資料庫160,並根據使用者U1之身分權重設定自選方案類別S1對應於問題描述檔案A1之權重。如果在使用者U1輸入自選方案類別S1之前,沒有其他使用者輸入過相同的類別,則中樞伺服器150可在關聯式資料庫160中,將對應於問題描述檔案A1之自選方案類別S1的權重設定為使用者U1的身分權重,例如依表2所示為5。For example, if the user U1 is a project manager and has an identity weight of 5, when the user U1 inputs a self-selection scheme category corresponding to the problem description file A1, for example, S1, the hub server 150 can select the option category. The correspondence between S1 and the problem description file A1 is stored in the relational database 160, and the weight of the self-selection scheme category S1 corresponding to the problem description file A1 is set according to the identity of the user U1. If no other user inputs the same category before the user U1 inputs the option category S1, the hub server 150 may, in the relational database 160, the weight of the option category S1 corresponding to the problem description file A1. The weight of the user U1 is set to be 5, as shown in Table 2.

在使用者U1輸入對應於問題描述檔案A1之自選方案類別S1後,若身分為初階工程師之使用者U2也同樣輸入對應於問題描述檔案A1之自選方案類別S1,則此時中樞伺服器150會根據使用者U2之身分權重,在表2中為1,增加在關聯式資料庫160中自選方案類別S1對應於問題描述檔案A1之權重,亦即將權重增加至6。換言之,解決方案搜尋系統100可根據使用者的身分不同,將每個使用者的經驗加以整合,以增加解決方案搜尋系統100搜尋對應解決方案的精準度。After the user U1 inputs the self-selection scheme category S1 corresponding to the problem description file A1, if the user U2 who is the initial engineer also inputs the option category S1 corresponding to the problem description file A1, then the hub server 150 is at this time. Based on the weight of the user U2, which is 1 in Table 2, the weight of the self-selection scheme category S1 corresponding to the problem description file A1 in the relational database 160 is increased, and the weight is increased to 6. In other words, the solution search system 100 can integrate the experience of each user according to the user's identity to increase the accuracy of the solution search system 100 searching for the corresponding solution.

如此一來,在選擇解決方案類別時,中樞伺服器150會先在關聯式資料庫160中搜尋是否儲存有對應於問題描述檔案A1之至少一自選方案類別。若關聯式資料庫160中並未儲存有對應於問題描述檔案A1之自選方案類別時,中樞伺服器150會選擇模型伺服器120所產生之預測解決方案類別P1作為解決方案類別。在第1圖的實施例中,由於關聯式資料庫160中儲存有問題描述檔案A1所對應之自選方案類別S1及S2,因此中樞伺服器150可選擇自選方案類別S1及S2中權重最高之自選方案類別作為解決方案類別C1。In this way, when selecting the solution category, the hub server 150 first searches the association database 160 for storing at least one option category corresponding to the problem description file A1. If the association type corresponding to the problem description file A1 is not stored in the relational database 160, the hub server 150 selects the prediction solution category P1 generated by the model server 120 as the solution category. In the embodiment of FIG. 1 , since the association database 160 stores the self-selection scheme categories S1 and S2 corresponding to the problem description file A1, the hub server 150 can select the self-selection with the highest weight among the option categories S1 and S2. The scenario category is the solution category C1.

此外,在部分實施例中,資料探勘預測模型M1可由解決方案搜尋系統100根據複數個已解決問題描述檔案及資料探勘演算法來建立。已解決問題描述檔案除了包含問題描述檔案A1所具有的項目之外,還包含問題成因欄位、配對方案類別以及對應的解決方案,因此除了自選方案類別之外,解決方案搜尋系統100也可利用已解決問題描述檔案中的資訊來增加解決方案搜尋系統100的精準度。Moreover, in some embodiments, the data mining prediction model M1 can be established by the solution search system 100 based on a plurality of resolved problem description files and data exploration algorithms. The solved problem description file includes the problem cause field, the pairing plan category, and the corresponding solution in addition to the item of the problem description file A1, so the solution search system 100 can be utilized in addition to the option type. The information in the problem description file has been resolved to increase the accuracy of the solution search system 100.

舉例來說,解決方案搜尋系統100可將已解決問題描述檔案中所記錄的配對方案類別與其對應之已解決問題描述檔案的對應關係儲存在關聯式資料庫160中,作為之後搜尋時的參考資料。配對方案類別可能是使用者原先所記錄的解決方案類別。然而在某些情況下,使用者所記錄的解決方案類別可能範圍過大,例如使用者若僅以bios作為已解決問題描述檔案之解決方案類別,則會導致搜尋出的解決方案過多,而喪失精準度。因此解決方案搜尋系統100亦可進一步將已解決問題描述檔案中的問題成因欄位與標準詞對照表比對來產生配對方案類別,如此即可提升配對方案類別的精準度。For example, the solution search system 100 may store the correspondence between the pairing scheme category recorded in the resolved problem description file and the corresponding solved problem description file in the associated database 160 as a reference material for subsequent searching. . The pairing plan category may be the solution category that the user originally recorded. However, in some cases, the type of solution recorded by the user may be too large. For example, if the user only uses bios as the solution type of the problem-solving description file, the search solution will be too much and the accuracy will be lost. degree. Therefore, the solution search system 100 can further compare the problem generative field in the solved problem description file with the standard word comparison table to generate a pairing scheme category, thereby improving the accuracy of the pairing scheme category.

在此情況下,當關聯式資料庫160中並未儲存有對應於問題描述檔案A1之自選方案類別,卻儲存有對應於問題描述檔案A1之配對方案類別時,中樞伺服器150即可選擇配對方案類別作為解決方案類別;而當關聯式資料庫160中並未儲存有對應於問題描述檔案A1之自選方案類別及配對方案類別時,中樞伺服器150才選擇模型伺服器120所產生的預測解決方案類別P1作為解決方案類別。In this case, when the association type database corresponding to the problem description file A1 is not stored in the relational database 160, but the pairing scheme category corresponding to the problem description file A1 is stored, the hub server 150 can select the pairing. The scheme category is used as the solution category; when the association database 160 does not store the option category and the pairing scheme category corresponding to the problem description file A1, the hub server 150 selects the prediction solution generated by the model server 120. The scenario category P1 is the solution category.

舉例來說,表3為本發明一實施例之關聯式資料庫160中問題描述檔案及其自選方案類別及配對方案類別間之對應關係。For example, Table 3 is a correspondence between the problem description file and its self-selection scheme category and pairing scheme category in the association database 160 according to an embodiment of the present invention.

表3 <TABLE border="1" borderColor="#000000" width="_0003"><TBODY><tr><td> 問題描述檔案代碼 </td><td> 自選方案類別 </td><td> 配對方案類別 </td></tr><tr><td> 01234 </td><td> S1: 6; S2 : 3 </td><td> T1 </td></tr><tr><td> 01235 </td><td>   </td><td> T2 </td></tr><tr><td> 01236 </td><td>   </td><td>   </td></tr></TBODY></TABLE>table 3         <TABLE border="1" borderColor="#000000" width="_0003"><TBODY><tr><td> Problem Description File Code</td><td> Option Category</td><td> Pairing Scheme Category</td></tr><tr><td> 01234 </td><td> S1: 6; S2: 3 </td><td> T1 </td></tr><tr> <td> 01235 </td><td> </td><td> T2 </td></tr><tr><td> 01236 </td><td> </td><td> </ Td></tr></TBODY></TABLE>

在表3中,每個問題描述檔案會以其問題描述檔案代碼作為代表,以方便搜尋管理,例如問題描述檔案A1的問題描述檔案代碼為01234,則中樞伺服器150即可根據代碼01234來搜尋問題描述檔案A1是否具有自選方案類別或配對方案類別。由於問題描述檔案A1會對應到解決方案搜尋系統100中的已解決問題描述檔案,因此在表3中,根據問題描述檔案A1之問題描述檔案代碼01234即可查找到對應的配對方案類別T1。再者,根據問題描述檔案A1之問題描述檔案代碼01234還可查找到對應於搜尋問題描述檔案A1的自選方案類別,即S1及S2,且權重分別為6及3。在此情況下,當中樞伺服器150要選擇問題描述檔案A1之解決方案類別時,將會優先選擇自選方案類別中權重較高的S1作為其解決方案類別。In Table 3, each problem description file is represented by its problem description file code to facilitate search management. For example, the problem description file code of the problem description file A1 is 01234, and the hub server 150 can search according to the code 01234. Question Description File A1 has a preference category or a pairing scheme category. Since the problem description file A1 corresponds to the resolved problem description file in the solution search system 100, in Table 3, the corresponding pairing plan category T1 can be found according to the problem description file code 01234 of the problem description file A1. Furthermore, according to the problem description file code 01234 of the problem description file A1, the self-selection scheme categories corresponding to the search problem description file A1, that is, S1 and S2, can be found, and the weights are 6 and 3, respectively. In this case, when the hub server 150 selects the solution category of the problem description file A1, the S1 with the higher weight in the option category will be preferentially selected as its solution category.

在本發明的其他實施例中,當中樞伺服器150要選擇問題描述檔案代碼為01235之解決方案類別時,則由於表3中並未儲存有對應於問題描述檔案代碼01235之自選方案類別,而僅有對應的配對方案類別T2,因此中樞伺服器150可選擇T2作為其問題描述檔案的解決方案類別。而當中樞伺服器150要選擇問題描述檔案代碼為01236之解決方案類別時,則由於表3中並未儲存有對應於問題描述檔案代碼01236之自選方案類別,也並未儲存對應於問題描述檔案代碼01236之配對方案類別;也就是說,具有問題描述檔案代碼01236之問題描述檔案之前並未被使用者輸入過,系統中也沒有相對應的已解決問題描述檔案可供參考,因此中樞伺服器150即會根據模型伺服器120所產生之預測解決方案類別作為其解決方案類別。In other embodiments of the present invention, when the hub server 150 selects the solution category whose problem description file code is 01235, since the option category corresponding to the problem description file code 01235 is not stored in Table 3, There is only a corresponding pairing scheme category T2, so the hub server 150 can select T2 as the solution category for its problem description file. When the hub server 150 selects the solution category whose problem description file code is 01236, since the option category corresponding to the problem description file code 01236 is not stored in Table 3, the file corresponding to the problem description file is not stored. The pairing scheme category of code 01236; that is, the problem description file with the problem description file code 01236 has not been input by the user before, and there is no corresponding solved problem description file in the system for reference, so the hub server 150 will be based on the prediction solution category generated by the model server 120 as its solution category.

決定解決方案類別C1之後,中樞伺服器150可將解決方案類別C1傳送至資料庫伺服器140,而資料庫伺服器140即可用以根據解決方案類別C1自巨量資料庫130讀取至少一解決方案。在第1圖的實施例中,巨量資料庫130中儲存了對應於解決方案類別C1之的解決方案D1 1至D1 3,而中樞伺服器150則會根據關聯式資料庫160中每一解決方案D1 1至D1 3對應於解決方案類別C1之權重,依序輸出解決方案D1 1至D1 3供使用者選擇。對於使用者來說,解決方案之權重越大表示其有較高之問題解決之可能性,因此使用者可根據解決方案權重由大至小,優先選擇權重較大的解決方案來嘗試解決其問題,以增加其問題解決之效率。 After determining the solution category C1, the hub server 150 can transmit the solution category C1 to the database server 140, and the database server 140 can be used to read at least one solution from the huge database 130 according to the solution category C1. Program. In the embodiment of FIG. 1, the solutions D1 1 to D1 3 corresponding to the solution category C1 are stored in the huge database 130, and the hub server 150 is solved according to each of the association databases 160. The schemes D1 1 to D1 3 correspond to the weights of the solution category C1, and the solutions D1 1 to D1 3 are sequentially output for the user to select. For the user, the greater the weight of the solution indicates that it has a higher probability of solving the problem, so the user can try to solve the problem according to the solution weight from large to small, giving priority to the solution with higher weight. To increase the efficiency of their problem solving.

在部分實施例中,每一解決方案D1 1至D1 3對應於解決方案類別C1之權重可以透過與解決方案搜尋系統100內部的資料比對自動設定,也可以透過與使用者的互動來設定。舉例來說,解決方案搜尋系統100可以儲存解決方案類別C1及對應於解決方案類別C1之各個已解決問題描述檔案之間的對應關係,亦即解決方案搜尋系統100可以記錄對應到解決方案類別C1的所有已解決問題描述檔案。由於對應到相同解決方案類別C1的各個已解決問題描述檔案可能會對應到不同的解決方案,且每個已解決問題描述檔案所包含的解決方案都有機會能夠用來解決問題描述檔案A1所描述的問題,因此當中樞伺服器選擇了適當的解決方案類別C1之後,解決方案搜尋系統100可以根據解決方案類別C1及與其對應之各個已解決問題描述檔案之間的對應關係搜尋出各個已解決問題描述檔案,並將各個已解決問題描述檔案所包含的解決方案視為可能的解決方案。 In some embodiments, the weight of each solution D1 1 to D1 3 corresponding to the solution category C1 can be automatically set through comparison with the data in the solution search system 100, or can be set by interaction with the user. For example, the solution search system 100 can store the correspondence between the solution category C1 and the respective problem description files corresponding to the solution category C1, that is, the solution search system 100 can record the corresponding to the solution category C1. All resolved problem description files. Since each of the resolved problem description files corresponding to the same solution category C1 may correspond to different solutions, and the solution included in each of the resolved problem description files has an opportunity to be used to solve the problem description file A1 described. The problem, therefore, after the central server selects the appropriate solution category C1, the solution search system 100 can search for each solved problem according to the correspondence between the solution category C1 and its corresponding resolved problem description file. Describe the files and consider the solutions included in each resolved problem description file as a possible solution.

再者,若已解決問題描述檔案的文字內容與問題描述檔案A1的文字內容越相近,則表示兩者所描述的問題可能越接近,而其已解決問題描述檔案所包含的解決方案也越有機會能夠解決問題描述檔案A1所描述的問題。因此解決方案搜尋系統100可將各個已解決問題描述檔案的文字內容與正在查詢中的問題描述檔案A1相比對,並依其比對結果的相似程度來排序各個已解決問題描述檔案所對應之解決方案的權重。Furthermore, the closer the text content of the resolved problem description file is to the text content of the problem description file A1, the closer the problem described by the two may be, and the more solutions the problem description file contains. The opportunity can solve the problem described in the problem description file A1. Therefore, the solution search system 100 can compare the text content of each solved problem description file with the problem description file A1 being queried, and sort the corresponding problem description files according to the degree of similarity of the comparison results. The weight of the solution.

而在中樞伺服器150根據上述方式所產生的權重來輸出解決方案D1 1至D1 3供使用者選擇後,使用者即可嘗試解決方案搜尋系統100所提供的解決方案D1 1至D1 3來解決問題。為了讓不同使用者間的經驗能夠互相整合以助於下一位使用者的搜尋,使用者還可透過解決方案搜尋系統100評估解決方案D1 1至D1 3之權重,根據使用者的評估結果,中樞伺服器150即可修改在關聯式資料庫160中使用者所評估之解決方案對應於解決方案類別C1之權重。 After the hub server 150 outputs the solutions D1 1 to D1 3 according to the weight generated by the above manner for the user to select, the user can try to solve the solutions D1 1 to D1 3 provided by the solution search system 100. problem. In order to allow the experience of different users to be integrated with each other to facilitate the search of the next user, the user can also evaluate the weights of the solutions D1 1 to D1 3 through the solution search system 100, according to the evaluation results of the user. The hub server 150 can modify the weight of the solution evaluated by the user in the associated database 160 corresponding to the solution category C1.

申言之,使用者可在實際嘗試一個解決方案對於問題之後,根據該已嘗試解決方案能夠解決問題的程度來給予對應的權重。舉例來說,表4為本發明一實施例之解決問題的程度與權重的對照表。In other words, the user can give a corresponding weight according to the extent to which the tried solution can solve the problem after actually trying a solution for the problem. For example, Table 4 is a comparison table of the degree and weight of the problem solving according to an embodiment of the present invention.

表4 <TABLE border="1" borderColor="#000000" width="_0004"><TBODY><tr><td> 權重 </td><td> 解決問題之程度 </td></tr><tr><td> 0 </td><td> 完全不能解決使用者之問題 </td></tr><tr><td> 1 </td><td> 能提供些許線索來解決使用者之問題 </td></tr><tr><td> 2 </td><td> 能提供部份線索來解決使用者之問題 </td></tr><tr><td> 3 </td><td> 能提供大部份線索來解決使用者之問題 </td></tr><tr><td> 4 </td><td> 幾乎能解決使用者之問題 </td></tr><tr><td> 5 </td><td> 完全能解決使用者之問題 </td></tr></TBODY></TABLE>Table 4         <TABLE border="1" borderColor="#000000" width="_0004"><TBODY><tr><td> Weight</td><td> Degree of problem resolution</td></tr><tr ><td> 0 </td><td> Can't solve the user's problem at all</td></tr><tr><td> 1 </td><td> can provide some clues to solve the user's problem Problem</td></tr><tr><td> 2 </td><td> can provide some clues to solve user problems</td></tr><tr><td> 3 < /td><td> can provide most of the clues to solve user problems</td></tr><tr><td> 4 </td><td> can solve user problems almost</td ></tr><tr><td> 5 </td><td> Solve user problems completely</td></tr></TBODY></TABLE>

在表4中,依據已嘗試解決方案能夠解決問題的程度為完全能解決使用者之問題到完全不能解決使用者之問題,可以分別對應到權重5至0。透過讓使用者在已嘗試解決方案之後,再給予權重的回饋機制,對應於解決方案類別C1之解決方案D1 1至D1 3之權重即可依不同使用者之評估而給定與累加,因此當下一個使用者查詢相同的系統問題時,依解決方案D1 1至D1 3之權重大小依序輸出給使用者,使用者依序嘗試解決方案,如此即可讓使用者更加快速地找到其問題之解決方案,進而增加解決方案搜尋系統100的精準度。 In Table 4, the degree to which the solution can be solved according to the tried solution is to completely solve the problem of the user to the problem that the user cannot be solved at all, and can correspond to the weights 5 to 0, respectively. By allowing the user to give a weighted feedback mechanism after trying the solution, the weights of the solutions D1 1 to D1 3 corresponding to the solution category C1 can be given and accumulated according to the evaluation of different users, so now When a user queries the same system problem, the weights of the solutions D1 1 to D1 3 are sequentially output to the user, and the user sequentially tries the solution, so that the user can find the solution to the problem more quickly. The solution, in turn, increases the accuracy of the solution search system 100.

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

透過上述本發明實施例之解決方案搜尋系統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. .

此外,為了能夠更有效地利用使用者所輸入的資訊,本發明之解決方案搜尋系統亦可根據使用者輸入的資訊來更新預測模型,進而增加解決方案搜尋系統的精準度,In addition, in order to more effectively utilize the information input by the user, the solution search system of the present invention can also update the prediction model according to the information input by the user, thereby increasing the accuracy of the solution search system.

第2圖為本發明一實施例之解決方案搜尋系統200的示意圖,解決方案搜尋系統200與解決方案搜尋系統100可根據相同原理運作,差別在於解決方案搜尋系統200還包含建模伺服器180,且當中樞伺服器150接收到之已解決之問題描述檔案A2 1至A2 X達一第一預定數量、標準詞對照表被更新及/或使用者輸入之自選方案類別達一第二預定數量時,中樞伺服器150可控制運算伺服器110及建模伺服器180來建立新的資料探勘預測模型M2。 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, with the difference that the solution search system 200 further includes a modeling server 180. And the problem that the resolved problem description files A2 1 to A2 X received by the hub server 150 reaches a first predetermined number, the standard word comparison table is updated, and/or the user input type of the option category reaches a second predetermined number. The hub server 150 can control the computing server 110 and the modeling server 180 to establish a new data mining prediction model M2.

在第2圖中,當解決方案搜尋系統200欲重新建立新的資料探勘預測模型時,中樞伺服器150可將已解決之問題描述檔案A2 1至A2 X傳送至運算伺服器110,運算伺服器110可根據更新後的標準詞對照表及已解決問題描述檔案A2 1至A2 X產生每一已解決問題描述檔案A2 1至A2 X所對應之模型輸入檔案B2 1至B2 X及解決方案D2 1至D2 XIn FIG. 2, when the solution search system 200 wants to re-establish a new data mining prediction model, the hub server 150 can transmit the resolved problem description files A2 1 to A2 X to the computing server 110, and the computing server file 110 may describe A2 1 A2 X to produce each problem has been described in Item A2 1 A2 X corresponding to the model input file B2 1 to B2 X and solution D2 1 from the updated word table and the criterion has been to solve the problem To D2 X.

中樞伺服器150可將問題描述檔案A2 1至A2 X所對應之解決方案D2 1至D2 X傳送至資料庫伺服器140,使資料庫伺服器140可根據解決方案D2 1至D2 X儲存在巨量資料庫130。同時,中樞伺服器150可將已解決之問題描述檔案A2 1至A2 X所對應之模型輸入檔案B2 1至B2 X及解決方案代碼D2 1至D2 X傳送至建模伺服器180,而建模伺服器180即可以根據資料探勘演算法、運算伺服器110產生之複數個模型輸入檔案B2 1至B2 X、解決方案代碼D2 1至D2 X以及關聯式資料庫160中各個問題描述檔案及其自選方案類別之間的對應關係來建立新的資料探勘預測模型M2。在本發明之一實施例中,建模伺服器180可以利用適用於資料探勘之演算法如Bayes、CBayes或SGD來建立預測模型。 The hub server 150 can transmit the solution D2 1 to D2 X corresponding to the problem description files A2 1 to A2 X to the database server 140, so that the database server 140 can be stored in the giant according to the solutions D2 1 to D2 X Volume database 130. At the same time, the hub server 150 can transmit the model input files B2 1 to B2 X and the solution codes D2 1 to D2 X corresponding to the solved problem description files A2 1 to A2 X to the modeling server 180, and model The server 180 can input the file B2 1 to B2 X , the solution codes D2 1 to D2 X, and the associated database description file in the relational database 160 and the selection according to the data exploration algorithm and the plurality of model input files B1 1 to B2 X generated by the computing server 110. The correspondence between the program categories is used to establish a new data mining prediction model M2. In one embodiment of the invention, modeling server 180 may utilize a algorithm suitable for data mining, such as Bayes, CBayes, or SGD, to build a predictive model.

由於建立資料探勘預測模型M2所需的時間一般會遠大於模型伺服器120轉換資料探勘預測模型所需的時間,因此中樞伺服器150可在資料探勘預測模型M2建立完成後,才使模型伺服器120以資料探勘預測模型M2代替資料探勘預測模型M1,如此即可避免在建立資料探勘預測模型M2的期間,使用者無法利用解決方案搜尋系統200的情況。此外,在模型伺服器120以資料探勘預測模型M2代替資料探勘預測模型M1的建立與轉換期間,網頁伺服器170亦可在網頁介面上輸出更新進度,以方便使用者知悉模型建立與轉換的進度。且解決方案搜尋系統200亦可在轉換過程當中提供部分與資料探勘預測模型無關的功能供使用者使用,以增加解決方案搜尋系統200的便利性。Since the time required to establish the data exploration prediction model M2 is generally much larger than the time required for the model server 120 to convert the data prediction prediction model, the hub server 150 can make the model server only after the data exploration prediction model M2 is established. 120 replaces the data exploration prediction model M1 with the data exploration prediction model M2, so that the user cannot search for the system 200 by using the solution during the establishment of the data prediction prediction model M2. In addition, during the establishment and conversion of the model exploration prediction model M1 by the model server 120, the web server 170 can also output the update progress on the web interface to facilitate the user to know the progress of the model establishment and conversion. . Moreover, the solution search system 200 can also provide a part of the function unrelated to the data mining prediction model for the user to use during the conversion process to increase the convenience of the solution search system 200.

由於資料探勘預測模型M2是根據先前使用者所輸入的內容所建立的,因此更新過後的解決方案搜尋系統200即能夠整合先前使用者的經驗進而提升精準度。透過持續性重建資料探勘預測模型方式,還可以逐漸提高本發明之解決方案搜尋系統所使用之預測模型的精準度,並達到理想之精準度。Since the data exploration prediction model M2 is established based on the content input by the previous user, the updated solution search system 200 can integrate the experience of the previous user to improve the accuracy. Through the continuous reconstruction of the data exploration prediction model, the accuracy of the prediction model used in the solution search system of the present invention can be gradually improved and the desired precision can be achieved.

第3A及3B圖為本發明一實施例中,解決方案搜尋系統100之操作方法300之流程圖。解決方案搜尋系統之操作方法300包含步驟S310至S380:3A and 3B are flow diagrams of a method 300 of operation 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 S380:

S310: 當中樞伺服器150接收到問題描述檔案時,中樞伺服器150將問題描述檔案傳送至運算伺服器110,並進入步驟S320;S310: When the hub server 150 receives the problem description file, the hub server 150 transmits the problem description file to the computing server 110, and proceeds to step S320;

S320: 運算伺服器110利用標準詞對照表與問題描述檔案之文字對照以產生關鍵詞描述檔案,並進入步驟S322;S320: The computing server 110 uses the standard word comparison table and the text of the problem description file to generate a keyword description file, and proceeds to step S322;

S322: 運算伺服器110根據關鍵詞描述檔案產生預測因子檔案,並進入步驟S324;S322: The computing server 110 generates a predictor file according to the keyword description file, and proceeds to step S324;

S324: 運算伺服器110根據預測因子檔案產生模型輸入檔案,並進入步驟S330;S324: The computing server 110 generates a model input file according to the predictive factor file, and proceeds to step S330;

S330︰ 中樞伺服器150將模型輸入檔案傳送至模型伺服器120,並進入步驟S340;S330. The hub server 150 transmits the model input file to the model server 120, and proceeds to step S340;

S340: 模型伺服器120根據模型輸入檔案及資料探勘預測模型M1產生預測解決方案類別,並進入步驟S350;S340: The model server 120 generates a prediction solution category according to the model input file and the data exploration prediction model M1, and proceeds to step S350;

S350: 若關聯式資料庫160儲存有問題描述檔案所對應之至少一自選方案類別,則進入步驟S352,否則進入步驟S354;S350: If the associated database 160 stores at least one option category corresponding to the problem description file, then proceeds to step S352, otherwise proceeds to step S354;

S352: 中樞伺服器150選擇至少一自選方案類別中權重最高之第一自選方案類別作為解決方案類別,並進入步驟S360;S352: The hub server 150 selects the first option category with the highest weight among the at least one option category as the solution category, and proceeds to step S360;

S354: 若關聯式資料庫160並未儲存有對應於問題描述檔案之自選方案類別,但儲存有對應於問題描述檔案之配對方案類別,則進入步驟S356,否則進入步驟S358;S354: If the association database 160 does not store the option category corresponding to the problem description file, but stores the pairing scheme category corresponding to the problem description file, then proceeds to step S356, otherwise proceeds to step S358;

S356: 中樞伺服器150選擇配對方案類別作為解決方案類別,並進入步驟S360;S356: The hub server 150 selects the pairing scheme category as the solution category, and proceeds to step S360;

S358: 中樞伺服器150選擇模型伺服器120產生之預測解決方案類別作為解決方案類別,並進入步驟S360;S358: The hub server 150 selects the prediction solution category generated by the model server 120 as the solution category, and proceeds to step S360;

S360: 中樞伺服器150將解決方案類別傳送至資料庫伺服器140,並進入步驟S370;S360: The hub server 150 transmits the solution category to the database server 140, and proceeds to step S370;

S370: 資料庫伺服器140根據解決方案類別讀取儲存於巨量資料庫130之至少一解決方案,並進入步驟S380;S370: The database server 140 reads at least one solution stored in the huge database 130 according to the solution category, and proceeds to step S380;

S380: 中樞伺服器150根據關聯式資料庫160中每一解決方案對應於解決方案類別之權重,依序輸出由巨量資料庫130讀取之至少一解決方案。S380: The hub server 150 sequentially outputs at least one solution read by the huge database 130 according to the weight of each solution in the association database 160 corresponding to the solution category.

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

100、200‧‧‧解決方案搜尋系統
110‧‧‧運算伺服器
120‧‧‧模型伺服器
130‧‧‧巨量資料庫
140‧‧‧資料庫伺服器
150‧‧‧中樞伺服器
160‧‧‧關聯式資料庫
170‧‧‧網頁伺服器
180‧‧‧建模伺服器
A1‧‧‧問題描述檔案
B1‧‧‧模型輸入檔案
C1‧‧‧解決方案類別
P1‧‧‧預測解決方案類別
S1、S2‧‧‧自選方案類別
T1‧‧‧配對方案類別
D11、D12、D13‧‧‧解決方案
A21、A2X‧‧‧已解決問題描述檔案
B21、B2X‧‧‧模型輸入檔案
D21、D2X‧‧‧解決方案
300‧‧‧方法
S310至S380‧‧‧步驟
100, 200‧‧‧ Solution Search System
110‧‧‧ Computing Server
120‧‧‧Model Server
130‧‧‧ huge database
140‧‧‧Database Server
150‧‧‧Central Server
160‧‧‧Related database
170‧‧‧Web server
180‧‧‧Modeling Server
A1‧‧‧ Problem Description File
B1‧‧‧Model input file
C1‧‧‧Solution category
P1‧‧‧ Forecast Solution Category
S1, S2‧‧‧ Optional category
T1‧‧‧ Matching scheme category
D1 1 , D1 2 , D1 3 ‧ ‧ solutions
A2 1 , A2 X ‧‧‧Resolved problem description file
B2 1 , B2 X ‧‧‧ model input file
D2 1 , D2 X ‧‧‧ solutions
300‧‧‧ method
S310 to S380‧‧‧ steps

第1圖為本發明一實施例之解決方案搜尋系統的示意圖。 第2圖為本發明另一實施例之解決方案搜尋系統的示意圖。 第3A及3B圖為第1圖之解決方案搜尋系統之操作方法流程圖。FIG. 1 is a schematic diagram of a solution search system according to an embodiment of the present invention. 2 is a schematic diagram of a solution searching system according to another embodiment of the present invention. Figures 3A and 3B are flow diagrams of the method of operation of the solution search system of Figure 1.

S350~S380‧‧‧步驟 S350~S380‧‧‧Steps

Claims (6)

一種解決方案搜尋系統,包含:一巨量資料庫;一關聯式資料庫;一運算伺服器,用以根據一標準詞對照表與一問題描述檔案之文字對照以產生一關鍵詞描述檔案,根據該關鍵詞描述檔案產生一預測因子檔案,根據該預測因子檔案產生一模型輸入檔案;一模型伺服器,用以根據該模型輸入檔案及一第一資料探勘預測模型產生一預測解決方案類別;一資料庫伺服器,用以根據該問題描述檔案所對應之一解決方案類別自該巨量資料庫讀取至少一解決方案;及一中樞伺服器,用以:當接收到該問題描述檔案時,將該問題描述檔案傳送至該運算伺服器;將該運算伺服器所產生之該模型輸入檔案傳送至該模型伺服器;當該關聯式資料庫儲存有該問題描述檔案所對應之至少一自選方案類別時,選擇該至少一自選方案類別中權重最高之一第一自選方案類別作為該解決方案類別;當該關聯式資料庫並未儲存有對應於該問題描述檔案之自選方案類別,但儲存有對應於該問題描述檔案之一配對方案類別時,選擇該配對方案類別作為該解決方案類別;當該關聯式資料庫並未儲存有對應於該問題描述檔案之自選方案類別及該配對方案類別時,選擇該預測解決方案類別作為該解決方案類別; 根據使用者的輸入內容更新該標準詞對照表;將該解決方案類別傳送至該資料庫伺服器;及根據該關聯式資料庫中每一解決方案對應於該解決方案類別之權重,依序輸出該資料庫伺服器由該巨量資料庫讀取之該至少一解決方案。 A solution search system, comprising: a huge database; an associated database; an operation server for comparing a text of a standard word with a problem description file to generate a keyword description file, according to The keyword description file generates a predictive factor file, and generates a model input file according to the predictive factor file; a model server is configured to generate a predictive solution category according to the model input file and a first data mining prediction model; a database server for reading at least one solution from the huge database according to the solution category corresponding to the problem description; and a hub server for: when receiving the problem description file, Transmitting the problem description file to the computing server; transmitting the model input file generated by the computing server to the model server; and storing, by the associated database, at least one option corresponding to the problem description file In the category, selecting one of the highest weights in the at least one option category as the first option category a solution category; when the associated database does not store an option category corresponding to the problem description file, but stores a pairing scheme category corresponding to the problem description file, the pairing scheme category is selected as the solution a category; when the associated database does not store the option category corresponding to the problem description file and the pairing scheme category, the prediction solution category is selected as the solution category; Updating the standard word comparison table according to the input content of the user; transmitting the solution category to the database server; and sequentially outputting according to the weight of each solution in the associated database corresponding to the solution category The database server reads the at least one solution from the huge database. 如請求項1所述之解決方案搜尋系統,其中該中樞伺服器另用以:根據一使用者所輸入之該至少一解決方案中一已嘗試解決方案的解決問題程度設定該已嘗試解決方案對應於該解決方案類別的權重。 The solution search system of claim 1, wherein the hub server is further configured to: set the tried solution according to a problem solving degree of an attempted solution of the at least one solution input by a user The weight of the solution category. 如請求項1所述之解決方案搜尋系統,其中該中樞伺服器另用以:當該中樞伺服器接收到一第一預定數量之已解決問題描述檔案、該標準詞對照表被更新及/或使用者輸入之自選方案類別達一第二預定數量時,控制該運算伺服器及一建模伺服器,以使該建模伺服器根據該運算伺服器所產生之檔案、一資料探勘演算法及該關聯式資料庫中該第一自選方案類別與該問題描述檔案間的對應關係,建立一第二資料探勘預測模型;及當該第二資料探勘預測模型建立完成後,使該模型伺服器以該第二資料探勘預測模型代替該第一資料探勘預測模型。 The solution search system of claim 1, wherein the hub server is further configured to: when the hub server receives a first predetermined number of resolved problem description files, the standard word comparison table is updated, and/or Controlling the computing server and a modeling server when the user input type of the option is up to a second predetermined number, so that the modeling server generates a file, a data exploration algorithm according to the computing server, and a correspondence between the first option category and the problem description file in the relational database, establishing a second data exploration prediction model; and when the second data exploration prediction model is established, causing the model server to The second data exploration prediction model replaces the first data exploration prediction model. 一種解決方案搜尋系統之操作方法,該解決方案搜尋系統包含一運算伺服器、一模型伺服器、一關聯式資料庫、一巨量資料庫、一資料庫伺服器及一中樞伺服器,該方法包含:當該中樞伺服器接收到一問題描述檔案時,該中樞伺服器將該問題描述檔 案傳送至該運算伺服器;該運算伺服器利用一標準詞對照表與該問題描述檔案之文字對照以產生一關鍵詞描述檔案;該運算伺服器根據該關鍵詞描述檔案產生一預測因子檔案;該運算伺服器根據該預測因子檔案產生一模型輸入檔案;該中樞伺服器將該模型輸入檔案傳送至該模型伺服器;該模型伺服器根據該模型輸入檔案及一第一資料探勘預測模型產生一預測解決方案類別;當該關聯式資料庫儲存有該問題描述檔案所對應之至少一自選方案類別時,該中樞伺服器選擇該至少一自選方案類別中權重最高之一第一自選方案類別作為一解決方案類別;該中樞伺服器將該解決方案類別傳送至該資料庫伺服器;該資料庫伺服器根據該解決方案類別讀取儲存於該巨量資料庫之至少一解決方案;該中樞伺服器根據該關聯式資料庫中每一解決方案對應於該解決方案類別之權重,依序輸出由該巨量資料庫讀取之該至少一解決方案;當一第一使用者輸入對應於該問題描述檔案之該第一自選方案類別時,該中樞伺服器將該第一自選方案類別與該問題描述檔案間的對應關係儲存至該關聯式資料庫,並根據該第一使用者之身分權重設定該第一自選方案類別對應於該問題描述檔案之權重;及在該第一使用者輸入對應於該問題描述檔案之該第一自選方案類別後,當一第二使用者輸入對應於該問題描述檔案之該第一自選方案類別時,該中樞伺服器根據該第二使用者之身分權重增加該關聯式資料庫中該第一自選方案類別對應於該問題描述檔案之權重。 An operation method of a solution search system, the solution search system comprising a computing server, a model server, an associated database, a huge database, a database server and a hub server, the method Include: when the hub server receives a problem description file, the hub server describes the problem file Transmitting to the computing server; the computing server uses a standard word comparison table to compare the text of the problem description file to generate a keyword description file; the computing server generates a prediction factor file according to the keyword description file; The computing server generates a model input file according to the predictive factor file; the hub server transmits the model input file to the model server; the model server generates a model according to the model input file and a first data mining prediction model Predicting a solution category; when the associated database stores at least one option category corresponding to the problem description file, the hub server selects one of the highest weights of the at least one option category as the first option category a solution category; the hub server transmits the solution category to the database server; the database server reads at least one solution stored in the huge database according to the solution category; the hub server According to each solution in the relational database, corresponding to the solution class The weight, sequentially outputting the at least one solution read by the huge database; when a first user inputs the first option category corresponding to the problem description file, the hub server Corresponding relationship between an option category and the problem description file is stored in the associated database, and the weight of the first option category corresponding to the problem description file is set according to the identity of the first user; and After the first user inputs the first option category corresponding to the problem description file, when a second user inputs the first option category corresponding to the problem description file, the hub server is configured according to the second The user's identity weight increases the weight of the first option category corresponding to the problem description file in the associated database. 如請求項4所述之方法,另包含:根據一使用者所輸入之該至少一解決方案中一已嘗試解決方案的解決問題程度設定該已嘗試解決方案對應於該解決方案類別的權重。 The method of claim 4, further comprising: setting a weight of the tried solution corresponding to the solution category according to a problem solving degree of an attempted solution of the at least one solution input by a user. 如請求項4所述之方法,該解決方案搜尋系統另包含一建模伺服器,該方法另包含:當該中樞伺服器接收到一第一預定數量之已解決問題描述檔案、該中樞伺服器更新該標準詞對照表及/或使用輸入之自選方案類別達一第二預定數量時,該中樞伺服器控制該運算伺服器及一建模伺服器,以使該建模伺服器根據該運算伺服器所產生之檔案、一資料探勘演算法及該關聯式資料庫中該第一自選方案類別與該問題描述檔案間的對應關係,建立一第二資料探勘預測模型;及當該第二資料探勘預測模型建立完成後,該中樞伺服器使該模型伺服器以該第二資料探勘預測模型代替該第一資料探勘預測模型。The method of claim 4, the solution search system further comprising a modeling server, the method further comprising: when the hub server receives a first predetermined number of resolved problem description files, the hub server Updating the standard word comparison table and/or using the input option category for a second predetermined number, the hub server controls the computing server and a modeling server to cause the modeling server to operate according to the operation a file generated by the device, a data exploration algorithm, and a correspondence between the first option category and the problem description file in the associated database, establishing a second data exploration prediction model; and when the second data exploration After the prediction model is established, the hub server causes the model server to replace the first data prediction prediction model with the second data exploration prediction model.
TW104136427A 2015-11-05 2015-11-05 Method of operating a solution searching system and solution searching system TWI567577B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW104136427A TWI567577B (en) 2015-11-05 2015-11-05 Method of operating a solution searching system and solution searching system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW104136427A TWI567577B (en) 2015-11-05 2015-11-05 Method of operating a solution searching system and solution searching system

Publications (2)

Publication Number Publication Date
TWI567577B true TWI567577B (en) 2017-01-21
TW201717063A TW201717063A (en) 2017-05-16

Family

ID=58407884

Family Applications (1)

Application Number Title Priority Date Filing Date
TW104136427A TWI567577B (en) 2015-11-05 2015-11-05 Method of operating a solution searching system and solution searching system

Country Status (1)

Country Link
TW (1) TWI567577B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW201126359A (en) * 2010-01-25 2011-08-01 Ind Tech Res Inst Keyword evaluation systems and methods
US20140025701A1 (en) * 2012-07-20 2014-01-23 Alibaba Group Holding Limited Query expansion
TW201523302A (en) * 2013-12-10 2015-06-16 Alibaba Group Services Ltd Data search processing
CN104765769A (en) * 2015-03-06 2015-07-08 大连理工大学 Short text query expansion and indexing method based on word vector

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW201126359A (en) * 2010-01-25 2011-08-01 Ind Tech Res Inst Keyword evaluation systems and methods
US20140025701A1 (en) * 2012-07-20 2014-01-23 Alibaba Group Holding Limited Query expansion
TW201523302A (en) * 2013-12-10 2015-06-16 Alibaba Group Services Ltd Data search processing
CN104765769A (en) * 2015-03-06 2015-07-08 大连理工大学 Short text query expansion and indexing method based on word vector

Also Published As

Publication number Publication date
TW201717063A (en) 2017-05-16

Similar Documents

Publication Publication Date Title
US11416268B2 (en) Aggregate features for machine learning
US11016996B2 (en) Dynamic clustering for streaming data
US10191977B2 (en) System and method for providing technology assisted data review with optimizing features
US10613962B1 (en) Server failure predictive model
JP6661768B2 (en) Classifying user behavior as abnormal
US9740738B1 (en) Data retrieval from datastores with different data storage formats
US20190362222A1 (en) Generating new machine learning models based on combinations of historical feature-extraction rules and historical machine-learning models
US20170109356A1 (en) User-specific customization for command interface
US20140379616A1 (en) System And Method Of Tuning Item Classification
US10331681B1 (en) Crowdsourced evaluation and refinement of search clusters
JP7267964B2 (en) Generation device, generation method and generation program
US11797565B2 (en) Data validation using encode values
US20180329873A1 (en) Automated data extraction system based on historical or related data
US9201967B1 (en) Rule based product classification
US20170337486A1 (en) Feature-set augmentation using knowledge engine
KR102153259B1 (en) Data domain recommendation method and method for constructing integrated data repository management system using recommended domain
US11934927B2 (en) Handling system-characteristics drift in machine learning applications
TWI567577B (en) Method of operating a solution searching system and solution searching system
US11675792B2 (en) Parallel operations relating to micro-models in a database system
US20170124088A1 (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
TWI574169B (en) Method of operating a solution searching system and solution searching system
US11710047B2 (en) Complex system for meta-graph facilitated event-action pairing
US20230060051A1 (en) Systems and methods for versioning a graph database
US20220138087A1 (en) System and method for risk-based testing