200947241 九、發明說明: 【發明所屬之技術領域】 本發明係關於一種資料庫搜尋,尤指一種資料庫之索 引建立方法,以及應用此索引建立方法之資料庫搜尋方法 與系統。 【先前技術】 數位科技將各種資料數位化為位元形式儲存於資料庫 内,藉由電腦系統來協助管理。由於資料庫中儲存著大量 資料,因此資料庫搜尋模式將影響使用者進行資料擷取與 修訂的便捷性。 請參閱第一圖,該圖係為一習知之資料庫搜尋示意 圖。如第一圖所示,電腦系統10具有一顯示介面11以及 一設定介面12,此圖之電腦系統10係以手機作為圖例, 顯示介面11為手機螢幕,而設定介面12為手機的九宮格 式按鍵,這些按鍵包括有數字鍵”9”、米字鍵"*n與 井字鍵π #",每一數字鍵分別對應一組注音符號以及英文 字母,設定特定注音符號或英文字母時,必須按照預定規 則致動按鍵。舉例來說,數字鍵"0"對應注音符號π勹女门 匚11,則按壓此按鍵一次時,可設定注音符號”勹”;按壓此 按鍵兩次時,可設定注音符號"女”;按壓此按鍵三次時, 可設定注音符號”门π ;按壓此按鍵四次時,可設定注音符 號"匚"。 通訊錄為手機主要的資料庫類型,也是現代人生活中 6 200947241 取^接觸到的資料庫種類。當使用通訊錄資料庫搜尋功能 時^顯示介面门將顯示出一選單列出每一筆資料,ϋ通常 顯不一查詢攔】]0,讓使用者確認查詢條件的設定是否止 確[國人的通訊錄資料大多是以漢語作為資料名稱,這個 f無便是通訊錄資料的查詢關鍵字,而資料的查詢索引通 吊為查詢關鍵字的注音符號拼音組合。使用者想從資料庫 中查=所需資料時,必須使用注音符號組合來設定查詢條 ❹200947241 IX. Description of the invention: [Technical field to which the invention pertains] The present invention relates to a database search, and more particularly to a method for establishing an index of a database, and a database search method and system using the index creation method. [Prior Art] Digital technology digitizes various data into a bit form and stores it in a database, which is assisted by a computer system. Due to the large amount of data stored in the database, the database search mode will affect the convenience of users in data retrieval and revision. Please refer to the first figure, which is a schematic diagram of a conventional database search. As shown in the first figure, the computer system 10 has a display interface 11 and a setting interface 12. The computer system 10 of the figure is a mobile phone as a legend, the display interface 11 is a mobile phone screen, and the setting interface 12 is a mobile phone's nine-square format button. These buttons include a number key "9", a rice key "*n and a well key π #", each numeric key corresponds to a set of phonetic symbols and English letters, and when a specific phonetic symbol or English letter is set, The button must be actuated in accordance with the predetermined rules. For example, if the number key "0" corresponds to the phonetic symbol π勹女匚11, the phonetic symbol “勹” can be set when the button is pressed once; when the button is pressed twice, the phonetic symbol "女" can be set. ; When you press this button three times, you can set the phonetic symbol "gate π; when you press this button four times, you can set the phonetic symbol "匚". The address book is the main type of database for mobile phones, and it is also the type of database that comes into contact with modern people's life 6 200947241. When using the address book database search function, the display interface will display a menu listing each item, which is usually not the same as the query block]]0, let the user confirm whether the setting of the query condition is correct [national communication] Most of the recorded data is in Chinese as the data name. This f is the query keyword of the address book data, and the query index of the data is hanged as the phonetic symbol pinyin combination of the query keyword. When the user wants to check the required data from the database, the phonetic symbol combination must be used to set the query bar.
牛負料庫搜号系統則將查詢條件與查詢索引作比對,過 濾出匹配的資料清單。 , 隹第 、 圖的圖例中,當使用者想在電腦系統10内部的 通訊錄身料庫巾查詢"邱小安"這筆資 詢欄 m中設定”邱小安”的注音符號拼音I,〈一 //=一弓"。 件妓過程中,當設定”〈π時,必須連續兩次致動 〜子鍵士4,當設定"一”時,須致動一次數字鍵;當設 疋又# ’則必須連續四次致動數字鍵,,8"。為完整拼出" <又丁么弓,按鍵累計致動次數將高達十五次。 f由此可見,f用的資料搜尋因查詢條件的設定繁瑣, :w成使用者的操作負擔’並在無形中個過長的資料查 詢時間。對現代人而言,資料處理效率為決定工作效率與 曰常事務處理效率的關鍵因素,面臨日錢大的資料庫, 必須發展更智慧化的資料庫搜尋方式,以便獅使用者快 速便捷地從龐大的資料庫中取得所需資料。 【發明内容】 7 200947241 立方、=及ί:!Γ之目的係在於提供一種資料庫之索引建 庫搜尋系統與方法,其係將闕鍵字中每一 於資科搜:百序組合作為查詢索引,以建立索引表用 捷地從資料騎搜尋到所需資料。 用者决連便 本發明_示—㈣料庫之索引建立方法 於 複數筆資料的資料庫建立索引: ㈣關鍵* 步驟為首先,分析該等資料個別之 的拼立首—=取得每―筆資料之查詢關鍵字中每-字元 詢旁弓曰卜以及Γ依序組合,進而產生每一筆資料的查 索引。及,建立一索引表,記錄該等資料個別之查詢 本發料揭示—师料庫搜尋方法,係適用於〆電腦 對儲存有複數筆資料的資料庫作搜尋。戶斤述之資 ^搜哥方法的步驟為競,分析該等資料個別之參詢關 ❹:以取得每一筆資料之查詢關鍵字中每一字元的拼音 並加以依序組合,進而產生每__筆資料的查詢#5ί。 建立索弓丨表,記錄該等資料個別之查詢素弓I。其 ''接收一查詢條件,並根據此查詢條件查找該素5丨表, =過遽出匹配該查詢條件的查詢索引所對應^料,進而 生一匹配結果。最後,輸出匹配結果至二顯示介面。 ,絲本t:t揭示一種資料庫搜尋系統,係適用於,電躺 設定入而、 /自系统具有一儲存有複數筆資料的資科康、〆 口又’丨1及—顯示介面。所述之資料庫搜尋系統包栝〆 200947241 „、-檢索弓丨擎以及一控制/處理模 —答次刺 係刀析該等貧料個別之查詢關鍵字,取尸— 貝;:、之查詢關鍵字中每一字元的拼音首、、,于母 序組合,以違&立 並力π以依 -索财, _之查詢索引。轉換模組並建立 4 、以5己錄該等資料個別之查詢索引。於去t % 鲁 :於資料庫,係根據-查詢條件,查找該令弓丨:擎耦 ==查詢條件之查詢索引所對應之資料ί而=濾 — 控制7處理模組耦接於設定介面、 顯示介面。枇钿/走„ 坛索引擎以及 制檢㈣科Hi係自^介面^查詢條件,控 示介面。 匹配結果,並取純配結果輪出至顯 其應=資明所揭示之資料庫之幻丨建立方法及 者快速便捷地從資料庠中取得所需資 處理效=幅減少資料查詢所耗f的時間,提昇資料 與接下來的詳細說明及_,皆是為了能 明本發明為達成預定目的所採取 < 方式、手段及 巴=有i|本發明的其他目的及優點,將在後續的說明 久圖式中加以闡述。 【實施方式】 -¾、,本毛明將&供一種資料庫之索引建立方法及其應用之 貝料庫搜尋系統及方法,將使得查詢條件的設定更為簡 9 200947241 易,讓使用者快速便捷地從資料庫中搜尋到所需資料。 首先,請參閱第二圖,該圖係為本發明之資料庫搜尋 糸統之系統架構系思、圖。如弟—圖所示,電腦系統2 〇具有 一資料庫21、一設定介面22以及一顯示介面23。所述之 電腦系統20可為一桌上型電腦、筆記型電腦、可攜式通訊 裝置、個人數位助理或一電子辭典。資料庫21内部^存有 複數筆資料;設定介面22係指外部使用者與電腦系統 的溝通介面,例如:鍵盤、觸控螢幕等裝置,用來>接、’ Γΐ:者所設定的查詢條件;顯示介面23為電腦系統20 電腦系統20另具有-資料庫搜尋系統3〇 料庫21作搜尋。資料庫搜尋系、统3◦包括一轉換模H -儲存模組33、一控制/處理模組34以及—檢索引擎邪。 ,換模組31 _於資料庫21,係用以對資料庫Μ建 索引。轉_組31建立索㈣步驟係先分 中所有資料的查詢關鍵字,取得每—筆資料之— 一 子兀的拼曰百子,亚加以依序組合,以產决叙一签 貧料的查詢索引;其次,建立一 母一筆 内部,以纪料答次W 系I表储存於储存模組33 丨以°己錄母一筆資料個別的查詢索引。 據外= ’可根 ί^} jM, ^ ^ ^^ ’慮出匹配該 m 耗接於設定介面22、檢索引擎35 一介面23’可從設定介面22 :引擎: 10 200947241 檢索引擎35運作產生匹配結果,並取得匹配結果輸出至顯 ' 示介面23。 • 按,第二圖之電腦系統20係為一簡明圖例,藉以闡明 本發明的運作機制。熟習電腦系統者應當知悉,所述之電 腦系統20具有中央處理單元、記憶體與顯示器等硬體元 件,並搭載有作業系統、應用軟體以及硬體驅動程式。所 述之資料庫搜尋系統30的各個模組是應用電腦系統20的 運算、儲存與其他資源,來達成其預定機能。而所述之索 © 引表可為一檔案形式。 請參閱第三圖,該圖係為本發明之索引表之一具體實 施例之示意圖,藉以闡明本案之索引建立模式。第三圖中, 索引表320是由複數列資訊所組成,以記錄每筆資料的資 訊’每列貢訊(也就是每筆資料的資訊)包括有二個棚位 321、322、323,分別對應著這筆資料的查詢關鍵字、查詢 索引以及這筆資料所指向的存取位置。 舉例來說,查詢關鍵字為”白老師"的這筆資料中,查 ® 詢關鍵字是由”白”、”老”、”師”等三個漢字字元所組成。” 白”的注音符號拼音為"勹巧11,拼音首字為11勹11 ; ”老π的注 音符號拼音為π力幺π,拼音首字為”力";”師11的注音符號 拼音為"尸11,拼音首字為”尸"。因此這筆資料的查詢索引 為每一字元拼音首字的組合"勹力尸"。 這樣一來,將使得查詢條件的設定更為簡易,消弭習 知技術中查詢條件設定繁瑣的缺點。 附帶說明的是,一筆資料可能會彈性具有多組查詢關 200947241 ^此ΐ同—筆資料具有多组查詢關鍵字時,則可分別祀 ”詢關鍵字來建立多组查詢索引,指向 : ”與”手機,,也是這筆資料的杳、讀中’邱媽媽 步具有”< 门门,,與,,尸兩組 ;^貝制進一 詢條件符合其中-㈣财㈣外崎定的查 —j家?I時’均會搜尋到這一筆資料。 接著,請參閱第四圖,該圖係為本 ❹ :二立方法暨資料搜尋方法之步驟流程圖。 統架構請同時參閱第二圖。 中相關之糸 法係先進行索引建立階段,包括下列步斤=此資料搜尋方 得每首=析!料庫21中每筆資料的查詢關鍵字,以取 传母輕料之查詢關鍵字中每—字, 以依序組合,進^產生每—筆么日百子,亚加 S100); 聿貝科的查詢索引(步驟 以及,建立一索引表320 (步驟S102); ❹ 驟^;,將每-削的查物鱗物請(步 其中,步驟S100至步驟S104為索引建立階段; 其後,從設定介面22接收一查詢條件, 條件查找索引表32。,過濾出匹酉7此查詢件;;;; 所對應之資料,進而產生一匹配結果(步 最後,輸出匹配結果至顯示介面23(步驟测)。 請同時參閱第五圖以及第六圖’第五圖係為本發明之 12 200947241 資料庫搜尋方法之一具體實施例之步驟流程圖,第六圖係 為本發明之資料庫搜尋方法之第一應用示意圖。第六圖係 - 以個人數位助理作為電腦系統40的圖例。電腦系統40具 有一顯示介面41以及一設定介面42。顯示介面41為個人 數位助理的螢幕,搜尋資料時,將顯示一查詢欄410,以 輔助使用者確認查詢條件。設定介面42為個人數位助理的 觸控螢幕。 此應用實例中,使用者欲查詢資料庫中"邱小安”的資 © 料内容,”邱”的拼音為n〈一 5T,拼音首字為π < "; ”小” 的拼音為” 丁一幺π,拼音首字為”丁";"安”的拼音為"弓", 因此查詢索引為"〈丁弓”,使用者欲查詢這筆資料,須將 查詢條件設定為”〈丁弓”。 啟動資料庫搜尋後的第一個步驟為建立索引表320 (步驟 S200 ); 其次,接收外部所設定的查詢條件"<π (步驟S202 ); φ 之後,查找索引表320,過濾匹配查詢條件"< π的查 詢索引所對應的資料,將產生一匹配結果,包括所有查詢 索引符合此查詢條件的資料,匹配結果包括”邱媽媽”” 邱媽媽手機"、"邱喜η、"邱小白”、Μ邱小東”(步驟S204); 之後,電腦系統40便將匹配結果,包括Μ邱媽媽”、" 邱媽媽手機"、Μ邱喜π、”邱小白”、''邱小東”、π邱小安π 以選單的形式,輸出至顯示介面41 (步驟S206 ); 之後,判斷是否修正查詢條件(步驟S208 ); 此實例中,在設定查詢條件為11 < π之後,係進一步設 13 200947241 定” 丁”,將查詢條件修正為”〈丁”,因此將回到步驟 S204,查找索引表或直接查找匹配結果,進一步過濾出查 . 詢索引符合查詢條件為”〈丁π的資料,匹配結果包括"邱喜 ”、”邱小白”、”邱小東”、"邱小安"(步驟S204); 之後,電腦系統40便將匹配結果,包括"邱喜"、”邱 小白"、”邱小東””邱小安"以選單的形式,輸出至顯示介 面41 (步驟S206); 之後,判斷是否修正查詢條件(步驟S208 ); 此實例中,在設定查詢條件為"< 丁”之後,係進一步 設定π弓",將查詢條件修正為11〈丁弓”,因此將再次回到 步驟S204,查找索引表或直接查找匹配結果,進一步過濾 出符合查詢條件為”〈丁弓π的資料,匹配結果為"邱小安" 這一筆資料(步驟S204); 之後,便將匹配結果,包括Μ邱喜”、’1邱小白π、"邱小 東11、”邱小安”輸出至顯示介面41 (步驟S206 ); ❹ 之後,判斷是否修正查詢條件(步驟S208),由於已 查詢到所需資料,未再修正查詢條件,便結束資料搜尋。 根據以上實例,查詢條件的設定過程中,僅須先後致 動”〈”、"丁"、”弓”等注音符號鍵,明顯可見本案的便捷 性。對於查號台等以資料查找為主要工作内容的服務人 員,將可大幅減少資料查詢時間,提昇工作與服務效率。 請參閱第七圖,該圖係為本發明之資料庫搜尋方法之 第二應用示意圖,圖中係以手機作為電腦系統50的圖例。 電腦系統5 0具有一顯示介面51以及一設定介面5 2。顯示 14 200947241 介面51為手機的螢幕,搜 -以輔助使用者確認查詢條件Jit將顯示一查詢欄510, ,式按鍵,這些按鍵包括有財面52為手機的九宮格 井字鍅丨丨*丨丨 > 本 鍵0〜丨丨9"'米字鍵丨丨*丨丨與 英文字母。’母字鍵個別對應—組特定注音符號以及 -符的文字類型除了注音符號之外,亦可為盘注 曰付唬,、軚準鍵盤對應關係的數 中,數字鍵τ對應注音符號" 機的九呂才。按鍵 ❹注音符號”勺六,力",數字鍵”3”對雇〔立數字鍵,,2·,對應 數字鍵,'4"對應注音符號”叭=音符號"《5厂,’’ 號”生㈣",數字鍵,,6”對2音^^^應=符 \ =字鍵”8,'對應注音符號” 鍵"〇”對應注音符號请△几”,數字 辑二應用Γ列中’使用者欲查詢資料庫中”邱小安”的資 ❹内谷,逆•貢料的查詢索引為·, < TV,注 、”、 "丁”、"弓"分別對應數字鍵"4"、”4”、"9” i曰田二儿、 條件設定為” 449,’,便可查詢到”邱小安•,這 f查δ句 習知技術中設定查詢條件必須致動按键+貝’。相較於 本發明對查詢條件設定的簡化。 —人’明顯可見 藉由以上實例詳述,當可知悉 ^建立方法及其應用之資料庫搜尋系 查珣條件的設定更為簡易,讓使 係使侍 料庫中查詢到所需資料,從而、車月匕° ’、速便捷地從資 U而貝料《而連帶地大幅減少資料查詢所 15 200947241 耗費的時間,提昇資料處理效率。 — 惟,以上所述,僅為本發明的具體實施例之詳細說明 - 及圖式而已,並非用以限制本發明,本發明之所有範圍應 以下述之申請專利範圍為準,任何熟悉該項技藝者在本發 明之領域内,可輕易思及之變化或修飾皆可涵蓋在以下本 案所界定之專利範圍。 A 【圖式簡單說明】 ◎ 第一圖係為一習知之資料庫搜尋示意圖; 第二圖係為本發明之資料庫搜尋系統之系統架構示意 圖, 第三圖係為本發明之索引表之一具體實施例之示意圖 第四圖係為本發明之資料庫之查詢索引建立方法暨資 料庫搜尋方法之步驟流程圖; 第五圖係為本發明之資料庫搜尋方法之一具體實施例 ❹ 之步驟流程圖; 第六圖係為使用本發明之資料庫搜尋方法之第一應用 示意圖;以及 第七圖係為使用本發明之資料庫搜尋方法之第二應用 示意圖。 【圖式符號說明】 10、 20、40、50 .電腦糸統 11、 23、41、51 :顯示介面 16 200947241 110、410、510 :查詢攔 - 12、22、42、52 :設定介面 - 21 :資料庫 30 :資料庫搜尋系統 31 :轉換模組 320 :索引表 321、322、323 :欄位 33 :儲存模組 〇 34 :控制/處理模組 35 :檢索引擎 S100〜S208 :各個步驟流程 17The cattle negative database search system compares the query conditions with the query index and filters out the matching data list. In the legend of the figure and figure, when the user wants to query the address book "Qiu Xiao'an" in the address book of the computer system 10, "Qiu Xiao'an" <一//=一弓". During the process, when "<π" is set, it must be actuated twice in a row ~ subkey 4, when setting "one, the number key must be actuated; when set to #', it must be four times in succession Actuate the number keys, 8". In order to completely spell out "<<">, the cumulative number of actuations of the button will be up to fifteen times. f It can be seen that the data search for f is cumbersome due to the setting of the query conditions, :w becomes the user's operational burden' and in the invisible long data query time. For modern people, data processing efficiency is a key factor in determining work efficiency and efficiency of transaction processing. Faced with a large database of daily money, it is necessary to develop a more intelligent database search method so that lion users can quickly and easily Get the information you need in a huge database. [Summary of the Invention] 7 200947241 The purpose of the cube, =, and ί:!Γ is to provide a database search system and method for indexing, which is to use the 搜 字 字Index to build an index table and use the land to search for the required data from the data ride. The user decides to make the invention _ Show - (4) The index establishment method of the database is to index the database of the plurality of data: (4) The key * The steps are first, analyze the individual data of each of the pieces - = get each pen Each query of the data in the query keyword is combined with the next order, and then the index of each data is generated. And, establish an index table to record the individual queries of the data. This publication reveals that the teacher database search method is applicable to the computer to search for a database storing multiple data. The steps of the method of searching for the brothers are the competition, and the individual inquiry of the data is analyzed. The pinyin of each character in the query keyword of each data is obtained and combined in order, thereby generating each __ pen data query #5ί. Establish a slinging table and record the individual quotations of the information. The ''receives a query condition, and finds the prime 5 table according to the query condition, and = matches the query index matching the query condition, and then generates a matching result. Finally, the matching result is output to the second display interface. , silk text t: t reveals a database search system, which is suitable for the electric lie setting, / the system has a sci-tech, sputum and 丨1 and - display interface for storing multiple pieces of data. The database search system package 200947241 „,-search for the bow engine and a control/processing module—the answer to the thorn knife to analyze the individual query keywords of the poor materials, take the corpse-be; The pinyin of each character in the keyword, and the combination of the parent sequence, to violate the & set the force π to rely on - Suo Cai, _ query index. Conversion module and establish 4, record 5 Information on the individual query index. In the t% Lu: In the database, according to the - query conditions, find the command: the target corresponding to the query index of the query condition = 滤 = filter - control 7 processing mode The group is coupled to the setting interface and the display interface. 枇钿/走„ The altar engine and the inspection (4) Section Hi are from the ^ interface ^ query conditions, control interface. Match the results, and take the results of the pure match to the display of the illusion of the database revealed by Qualified and the quick and convenient way to obtain the required processing from the data = The time, the enhancement of the information and the following detailed description and _ are all in order to be able to demonstrate that the invention has achieved the intended purpose of <methods, means and other purposes and advantages of the invention, which will be followed Explain the long-term diagram. [Embodiment] -3⁄4,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Quickly and easily search for the required information from the database. First, please refer to the second figure, which is a system architecture diagram and diagram of the database search system of the present invention. As shown in the figure, the computer system 2 has a database 21, a setting interface 22 and a display interface 23. The computer system 20 can be a desktop computer, a notebook computer, a portable communication device, a personal digital assistant or an electronic dictionary. The database 21 has a plurality of data stored therein; the setting interface 22 refers to a communication interface between an external user and a computer system, for example, a keyboard, a touch screen, etc., and is used for > The condition; the display interface 23 is a computer system 20, and the computer system 20 has a database search system 3 for searching. The database search system includes a conversion module H-storage module 33, a control/processing module 34, and a search engine. The change module 31_ is used in the database 21 to build an index into the database. Turn _ group 31 to establish the cable (four) step is to first divide all the query keywords of the data, to obtain each of the data - one child 兀 曰 曰 , , 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚 亚Index; Secondly, establish a parental internal, and store the data in the storage module 33 by the data sheet, and the individual query index of the data. According to the outer = 'root ί^} jM, ^ ^ ^^ 'consider the m is consumed in the setting interface 22, the search engine 35 interface 23' can be generated from the setting interface 22: engine: 10 200947241 retrieval engine 35 Match the result and get the matching result output to the display interface 23. • The computer system 20 of Figure 2 is a simplified illustration to illustrate the operational mechanism of the present invention. Those familiar with computer systems should be aware that the computer system 20 has hardware components such as a central processing unit, a memory and a display, and is equipped with an operating system, an application software, and a hardware driver. The various modules of the database search system 30 are computing, storage, and other resources of the application computer system 20 to achieve its intended function. And the reference to the © can be a file form. Please refer to the third figure, which is a schematic diagram of a specific embodiment of the index table of the present invention, to clarify the index establishment mode of the present case. In the third figure, the index table 320 is composed of a plurality of columns of information to record the information of each piece of information. [Each column of information (that is, information for each piece of information) includes two booths 321, 322, 323, respectively. The query keyword, the query index, and the access location pointed to by the data. For example, in the information that the query keyword is "White Teacher", the search keyword is composed of three Chinese characters such as "white", "old", "teacher", etc. "White" The phonetic symbol of Pinyin is "勹巧11, the first word of Pinyin is 11勹11; ” The phonetic symbol of the old π is π force 幺π, the first word of Pinyin is “force";” The phonetic symbol of Teacher 11 is " The corpse 11, the first word of Pinyin is "corpse". Therefore, the query index of this data is the combination of the first word of each character pinyin "勹力尸". This will make the setting of the query conditions easier. In addition, the shortcomings of the query conditions in the conventional technology are cumbersome. It is noted that a piece of information may be flexible with multiple sets of queries. 200947241 ^This same--when the data has multiple sets of query keywords, you can separately query Keywords to create multiple sets of query indexes, pointing to: "and" mobile phone, is also the shackles of this information, reading 'Qiu mother step has" &[; door,, and, corpse two groups; ^ shell system into a query The conditions are in line with the - (four) financial (four) outside the Qiqiding investigation - j home? I This information will be searched. Next, please refer to the fourth figure, which is a flow chart of the steps of the second method and data search method. Please refer to the second figure at the same time. First, the index establishment phase, including the following steps = this data search side of each query = analysis of each data query keyword in the repository 21, in order to take the parent-light material query keyword in each word, to The order combination, the input ^ generates every pen, the Japanese, the sub-S100); the query index of the 聿 科 ( (step and, an index table 320 is established (step S102); ❹ ^ ^; Scales please (steps, step S100 to step S104 is an index establishment phase; thereafter, a query condition is received from the setting interface 22, the conditional lookup index table 32., filtering out the query item 7;;;; The data, in turn, produces a matching result (at the end, the output matching result is output to the display interface 23 (step measurement). Please refer to the fifth and sixth figures simultaneously. The fifth figure is the 12 200947241 database search method of the present invention. Step flow of a specific embodiment Figure 6 is a first application diagram of the database search method of the present invention. Figure 6 is a diagram of a personal digital assistant as a computer system 40. The computer system 40 has a display interface 41 and a setting interface 42. The display interface 41 is a screen of the personal digital assistant. When searching for information, a query bar 410 is displayed to assist the user in confirming the query condition. The setting interface 42 is a touch screen of the personal digital assistant. In this application example, the user wants to query In the database, the content of "Qiu Xiao'an" is the material content. The pinyin of "Qiu" is n<5T, the first word of Pinyin is π <"; The pinyin of "small" is "Ding Yizhen π, Pinyin first word The pinyin for "Ding" "" Ann is "bow", so the query index is "Ding bow." To query this information, the user must set the query condition to "Ding Gong". The first step after starting the database search is to build the index table 320 (step S200); secondly, receiving the externally set query condition "<π (step S202); φ, looking up the index table 320, filtering the matching query The data corresponding to the query index of the condition "< π will produce a matching result, including all the indexes whose query index meets the query conditions, and the matching results include "Qiu Mama" "Qiu Mama Mobile Phone", "" Qiu Xiyi , "Qiu Xiaobai, Μ Qiu Xiaodong" (step S204); After that, the computer system 40 will match the results, including the mother of Qiu Qiu, "Qi mother mobile phone", Qiu Qixi π, "Qiu Xiaobai" , ''Qiu Xiaodong'', π Qiu Xiao'an π is output to the display interface 41 in the form of a menu (step S206); thereafter, it is judged whether or not the query condition is corrected (step S208); in this example, the query condition is set to 11 < π After that, the system further sets 13 200947241 to "d", and the query condition is corrected to "dec", so it will return to step S204 to search the index table or directly find the matching result, and further filter out the query index. The query condition is "decimal π data, and the matching results include "Qiu Xi", "Qiu Xiaobai", "Qiu Xiaodong", "Qiu Xiaoan" (step S204); after that, the computer system 40 will match the result. , including "Qiu Xi", "Qiu Xiaobai", "Qiu Xiaodong", "Qiu Xiaoan", in the form of a menu, output to the display interface 41 (step S206); thereafter, determining whether to correct the query condition (step S208) In this example, after setting the query condition to "<", the π bow" is further set, and the query condition is corrected to 11<丁弓", so it will return to step S204 again to look up the index table or directly Find the matching result, and further filter out the data that meets the query condition as "Ding Gong π, the matching result is "Qiu Xiaoan" this data (step S204); after that, the matching result, including Qiu Qixi," 1 Qiu Xiaobai π, "Qiu Xiaodong 11, "Qiu Xiao'an" is output to the display interface 41 (step S206); ❹, after determining whether to correct the query condition (step S208), since the required data has been queried, no further correction is performed. After the conditions are met, the data search is ended. According to the above example, in the setting process of the query conditions, only the phonetic symbol keys such as "<", "Ding", "Bow" have been activated successively, and the convenience of the case is obvious. Service personnel who use the data search as the main work content will greatly reduce the data query time and improve the efficiency of work and service. Please refer to the seventh figure, which is the second application of the database search method of the present invention. In the figure, a mobile phone is taken as a legend of the computer system 50. The computer system 50 has a display interface 51 and a setting interface 52. Display 14 200947241 Interface 51 is the screen of the mobile phone, search - to assist the user to confirm the query condition Jit will display a query bar 510, the type button, these buttons include the Jiugong Gejing 鍅丨丨*丨丨 with the face 52 as the mobile phone > This key 0~丨丨9"'m word key 丨丨*丨丨 with English letters. 'The mother key corresponds to each other—the group-specific phonetic symbol and the character type of the - character are in addition to the phonetic symbol, and can also be the number of the phonetic notes, and the numeric key τ corresponds to the phonetic symbol " Ji Lu of the machine. Button ❹ phonetic symbol "spoon six, force ", number key "3" on the employment [standing number keys, 2, corresponding to the number keys, '4" corresponding phonetic symbols" '号号生(四)", numeric keys,, 6" to 2 sounds ^^^ should be = character \ = word key "8, 'corresponding to phonetic symbols" key "〇" corresponding to phonetic symbols please △ a few, number two In the application list, the user wants to query the database of Qiu Xiao'an, and the index of the counter-tribute is ·, < TV, Note, ", " Ding", "Bow" Corresponding to the number keys "4","4", "9" i 曰田二儿, the condition is set to "449,", you can query "Qiu Xiaoan," The query condition must be actuated by the button +Bei'. Compared with the simplification of the query condition setting of the present invention. - The person's obviously can be seen by the above example, when the database search system can be known to establish the method and its application. The setting of the conditions is more simple, so that the department can query the information in the store, so that the car is 匕°, fast and convenient. From the perspective of the U and the materials, the cost of data processing is greatly reduced, and the data processing efficiency is improved. However, the above description is only a detailed description of the specific embodiments of the present invention - and the drawings. The invention is not intended to limit the scope of the invention, and the scope of the invention is to be determined by the following claims. Any person skilled in the art in the field of the invention can be easily changed or modified to cover the following cases. The scope of the defined patents. A [Simplified description of the schema] ◎ The first diagram is a schematic diagram of a database search; the second diagram is a system architecture diagram of the database search system of the present invention, and the third diagram is BRIEF DESCRIPTION OF THE DRAWINGS FIG. 4 is a flow chart showing steps of a query index establishment method and a database search method for a database of the present invention; FIG. 5 is one of the database search methods of the present invention. A flowchart of the steps of the specific embodiment ;; the sixth diagram is a first application schematic diagram of the database searching method using the present invention; and the seventh diagram is A schematic diagram of a second application using the database search method of the present invention. [Description of Symbols] 10, 20, 40, 50. Computer System 11, 23, 41, 51: Display Interface 16 200947241 110, 410, 510: Query Block - 12, 22, 42, 52: Set Interface - 21: Library 30: Database Search System 31: Conversion Module 320: Index Table 321, 322, 323: Field 33: Storage Module 〇 34: Control / Processing module 35: search engines S100~S208: each step flow 17