4 4 6 8 9 - 五、發明說明（i) 本發明係有關於一種資料庫管理系統，特別是應用於 WWW環境中之全文同異質資料庫，提供主從式架構進行檢 索’可依檢索内容與條件對一個或多個資料庫進行平行處 理以快速地傳回檢索結果。 全球資訊網（World Wide Web)提供網際網路 (Internet)上任何節點上的電腦，利用互動式的文件格 式或是網頁（Web Page)進行資訊的交換或存取（Access )。例如在網頁中’結合許多超文連結（Hypertext Link )可提供使用者包括圖像、聲音、影像、以及純文字的資 料。此類超文連結可利用如熟知的超文整合語言 (HyperText Make-up Language, HTML)加以撰寫。 一般而言，網站或網頁儲存於網站伺服器（Web Server )中。在瀏觉器用戶端（Web Browser Client )的 使用者可經由網際網路其他型式的網路系統，根據如超文 傳輸協定（HyperText transport Protocol, HTTP)等傳 輸協定存取網頁上的資料》 如前所述，網頁與網站是架設在網站伺服器中，但網 頁或網站中超文連結所指向的聲音、圖像、影像、或是文 字資料所在之資料庠並不一定存在於網頁與網站所架設的 網站伺服器内。換言之，此類網頁或網站中的資料可為分 散式（distributed)儲存於網路上其他伺服器或電腦 中’甚至其間可能必須經過其他網站或網頁的超文連結而 取得即時性的資訊。 在傳統的網站伺服器對於資料檢索搜尋的處理方式4 4 6 8 9-V. Description of the invention (i) The present invention relates to a database management system, especially a full-text homogeneous database used in the WWW environment, providing a master-slave architecture for searching. Process one or more databases in parallel with conditions to quickly return search results. The World Wide Web provides computers at any node on the Internet, using interactive document formats or Web pages to exchange or access information (Access). For example, in a webpage, 'combining many Hypertext Links can provide users with information including images, sounds, images, and plain text. Such hypertext links can be written using the well-known HyperText Make-up Language (HTML). Generally speaking, websites or web pages are stored in a web server (Web Server). Users in the Web Browser Client can access data on web pages through other types of Internet systems such as the HyperText Transport Protocol (HTTP). As mentioned above, web pages and websites are hosted on web servers, but the sound, images, images, or text data pointed to by hypertext links on web pages or websites do not necessarily exist on the web pages and websites. On the web server. In other words, the data on such webpages or websites can be distributed and stored on other servers or computers on the network ’or even have to go through hypertext links of other websites or webpages to obtain real-time information. Data retrieval searches on traditional web servers
第4頁 446892 五、發明說明（2) 中’可針對由瀏覽器用戶端指定欲搜尋檢索之資料庫進行 處理’亦即根據使用者選取的一個或多個資料庫進行檢索 搜尋’最後將總搜尋結果彙整後透過網站伺服器傳送回瀏 覽器用戶端。其中，在針對多個資料庫進行搜尋時，網站 伺服器是依序以一對一的方式對資料庫所在之伺服器或電 腦進行搜尋’處理速度相當緩慢。此外，由於未對此類搜 尋限定時間，當某一次搜尋處理相當耗時時，網路伺服器 並無法終止此處理，且並需分享系統資源等待搜尋結果。 此缺點對網站拜訪人數龐大之網站伺服器造成相當大的負 擔’除瀏覽器用戶端無法快速地取得搜尋結果之外，亦會 減慢網站伺服器的處理效能。 因此’本發明之一目的，在於提供一種應用於WWW環 境中之資料庫管理系統，利用主從式架構經由相同平台或 不同平台進行資料檢索。當位於主端（Master)之網站伺 服器接收檢索指令後’交由從端（Siaver )同時分派指令 搜尋各資料庫。此時，此系統可由使用者選擇欲搜尋之資 料庫’亦可對多目的的資料庫進行平行處理，並由使用者 自行設定搜尋等待時間，增加網站伺服器之處理效率。 本發明所提供之一種應用於WWW環境中之全文同異質 資料庫管理系統，包括提供一網路；提供一電腦系統，該 電滕系統耦接該網路且有一顯示裝置，並可發送複數搜尋 才B令’提供一網站伺服器，其有複數資料庫，還包括：一 輸入端，用以耦接該網路，與該等資料庫相對應之該等搜 尋指令由該網路經該輸入端傳送入該網站伺服器中；一第 HHHH ΙΗΗ» 第5頁 446892 五、發明說明（3) 一資料傳輪埠，用 埠，耦接該第一資 一分送器，依該等 搜尋指令；且當任 時間時’中斷該搜 傳輸蜂傳回一錯誤 庫於該預設時間内 輸埠傳回該對應資 該網站伺服器經該 置顯示。 以傳送 料傳送 搜尋指 一搜尋 尋指令 訊息； 搜尋得 料；以 網路傳 該等搜尋 琿，並接 令所對應 指令搜尋 之處理動 而當任一 對應資料 及將該錯 送至該電 指令； 收該等 之資料 對應資 作，並 搜尋指 時，經 誤訊息 腦系統 一第二資 料傳輸 :以及 送該等 搜尋指令 庫同時發 料庫超過一預設 經該第二與第一 令搜尋對應資料 該第二與第—傳 與該對應資料由 ，並於該顯示裝 此外’本發明提供另一種應用於WWff環境中之全文同 異質資料庫管理系統’包括提供一網路；提供一電腦系 統，該電腦系統耦接該網路且有一顯示裝置，並可發送複 數搜尋指令·，提供—網站伺服器，包括：一輸入端，用以 耗接該網路’與該等資料庫相對應之該等搜尋指令由該網 路經該輸入端傳送入該網站伺服器中；以及一第一資料傳 輸缚’用以傳送該等搜尋指令；提供一發送伺服器，耦接 複數資料庫儲存裝置，每—該等搜尋指令對應儲存於該等 資料庫儲存裝置中一或複數個該等資料庫進行資料搜尋， 包括：一第二資料傳輸埠，耦接該第一資料傳送埠，並接 收該等搜尋指令；以及一分送器，依該等搜尋指令所對應 之該一或該等資料庫同時發送該等搜尋指令；且當任一搜 尋指令搜尋對應資料庫超過一預設時間時，中斷該搜尋指 令之處理動作，並經該第二與第一傳輸埠傳回一錯誤訊Page 4 446892 5. In the description of the invention (2), 'can be processed for the database specified by the browser client to be searched and searched', that is, the search is performed based on one or more databases selected by the user. The search results are aggregated and sent back to the browser client via the web server. Among them, when searching for multiple databases, the website server sequentially searches the server or computer where the database is located in a one-to-one manner. The processing speed is quite slow. In addition, since there is no time limit for such searches, when a certain search process takes a long time, the web server cannot terminate the process and needs to share system resources and wait for search results. This disadvantage causes a considerable burden on a web server with a large number of website visitors. In addition to the inability of the browser client to obtain search results quickly, it also slows down the processing performance of the web server. Therefore, one of the objectives of the present invention is to provide a database management system applied in the WWW environment, which uses a master-slave architecture to perform data retrieval via the same platform or different platforms. When the web server at the master receives the search command, it will send the command to the slave (Siaver) to search each database at the same time. At this time, the system can select the database to be searched by the user ', and can also process the multi-purpose database in parallel, and the user can set the search waiting time to increase the processing efficiency of the web server. The present invention provides a full-text homogeneous database management system applied in the WWW environment, including providing a network; providing a computer system, the electric system is coupled to the network and has a display device, and can send multiple searches Order B 'provides a web server which has a plurality of databases and further includes: an input terminal for coupling the network, and the search commands corresponding to the databases are input by the network through the network. End into the web server; a first HHHH Ι ΗΗ »page 5 446892 5. Description of the invention (3) A data transmission port, using the port, is coupled to the first data one distributor, according to these search instructions And when it is in office, 'interrupt the search and transmission bee, return an error database, and return the corresponding data to the port server within the preset time. Send search by transmission means a search and search command message; find the search; transmit these searches through the network, and then make the corresponding command search processing act as any corresponding data and send the error to the electric command ; Receive the corresponding information of the data, and search the pointer, the second data transmission of the brain system through the misinformation: and send these search instructions to the database while sending more than one preset search by the second and first orders Corresponding data The second and first-passing and corresponding data sources are installed on the display. In addition, the present invention provides another full-text homogeneous database management system for WWff environment, including providing a network; providing a computer System, the computer system is coupled to the network and has a display device, and can send multiple search instructions, providing-a web server, including: an input terminal to consume the network 'corresponding to these databases The search instructions are transmitted from the network to the web server via the input terminal; and a first data transmission link is used to transmit the search instructions; a transmission is provided A server, coupled to a plurality of database storage devices, each of the search instructions corresponding to one or more of the databases stored in the database storage devices for data search, including: a second data transmission port, coupled The first data transmission port, and receives the search instructions; and a distributor, according to the one or more databases corresponding to the search instructions, simultaneously sends the search instructions; and when any search instruction searches for a corresponding When the database exceeds a preset time, the processing action of the search command is interrupted, and an error message is returned through the second and first transmission ports.
44SS92 一_ ------------------ ----.__ 五、發明說明（4) 息；而當任一搜尋指令搜尋對應資料庫於該預設時間内搜 尋得對應資料時’經該第二與第一傳輸埠傳回該對應資 料；以及將該錯誤訊息與該對應資料由該網站伺服器經該 網路傳送至該電腦系統，並於該顯示裝置顯示。 為讓本發明之上述和其他目的、特徵、和優點能更明 顯易懂’下文特舉一較佳實施例，並配合所附圖式，作詳 細說明如下： 圖示之簡單說明： 第1圏係顯示根據本發明所揭示之第一實施例之系統 架構示意圖； 第2圖係顯示根據本發明所揭示之第二實施例之系統 架構示意圈。 ' 符號說明： 10〜使用者；20、20’〜網站伺服器；22、22，〜輸入 /出端；24、24’ 、26、26’〜傳輸埠；28、28,〜分送^ . DBl-DBN、DB1’ -DBN’〜資料庫；I〜網際網路。 實施例： 本發明之第一實施例係說明利用平行處理與主從 構的資料庫管理系統完成WWW網站之搜尋。 》架 本實施例中雖應用於網際網路，但其他類型夕_ 土 網路 構同樣可依據本發明之精神與專利範疇加以推廣% 如第1圈所示為根據本發明所揭示之第一實施_ ° 統架構示意圖。使用者10透過網際網路I與網站仞之系 m w服器？ η 相連接，此連接方式可利用如HTTP或FTP等網路柏 關傳輪44SS92 A _ ------------------ ----.__ 5. Description of the invention (4) information; and when any search command searches the corresponding database in the preset When the corresponding data is searched within the time, 'the corresponding data is returned via the second and first transmission ports; and the error message and the corresponding data are transmitted from the web server to the computer system via the network, and The display device displays. In order to make the above and other objects, features, and advantages of the present invention more comprehensible, a preferred embodiment is given below, and in conjunction with the accompanying drawings, the detailed description is as follows: Brief description of the diagram: Section 1 圏FIG. 2 is a schematic diagram showing a system architecture according to a first embodiment disclosed in the present invention; FIG. 2 is a schematic circle showing a system architecture according to a second embodiment disclosed in the present invention. 'Explanation of symbols: 10 ~ users; 20, 20' ~ web server; 22, 22, ~ input / output; 24, 24 ', 26, 26' ~ transmission ports; 28, 28, ~ distribution ^. DBl-DBN, DB1 '-DBN' ~ Database; I ~ Internet. Embodiments: The first embodiment of the present invention is to illustrate the use of parallel processing and the master-slave database management system to complete the WWW website search. "Although it is applied to the Internet in this embodiment, other types of earth network structures can also be promoted in accordance with the spirit and patent scope of the present invention. As shown in the first circle, the first disclosure according to the present invention Implementation _ ° system architecture diagram. Is the user 10 connected to the website through the Internet? η connection, this connection method can use network gateways such as HTTP or FTP
446892 五、發明說明（5) 協定加以完成。使用者端1 0可為一電腦系統，此電腦系統 連接網際網路I且有一顯示裝置，並可發送複數搜尋指 令。在網站伺服器20中至少包括複數儲存資料之資料庫 DB1〜DBN ; —輸入/出端22，用以耦接網際網路I，且與資 料庫DB1〜DBN相對應之搜尋指令由網際網路I經輸入/出端 22傳送入網站伺服器20中；一第一資料傳輸埠24，用以傳 送搜尋指令；一第二資料傳輸埠26，耦接第一資料傳送埠 24，並接收搜尋指令；以及一分送器28，依據搜尋指令所 對應之資料庫DB1〜DBN同時發送搜尋指令。 當使用者端10發出搜尋指令時，利用網路協定將搜尋 指令依據 URL (Uniform Resource Location)透過網際網 路I與網站伺服器20連通，搜尋指令由網站伺服器2〇之輸 入/出端22接收並由傳輸槔24與26傳送至分送器28。分送 器將依照搜尋指令對應之資料庫DB1〜DBN，同時發送7搜尋 指令進行搜尋。在第一實施例中，資料庫〜DBN與分送 器28存在網站伺服器20中，其中分送器28可由軟體模擬產 生，資料庫DB1〜DBN則儲存於單一儲存裝置或是分散儲存 於數個儲存裝置中。 在此實施例中，有幾點值得注意： 第一’由發送器28是以平行處理的模式發送搜尋指 令’換言之’此時在資料庫DB1〜DBN中凡是對應到搜尋指 令的資料庫在同一個時間進行搜尋，相較習知技術中僅能 按搜尋指令依序對各個對應資料庫搜尋，本發明所揭示之 實施例搜尋處理的方式較為快速。 第8頁 ^46892 五、發明說明（6) 第二，每一對應搜尋資料庫的搜尋時間可由系統自行 決定》在習知技術中，由於搜尋時間過長往往會影響整合 搜尋結果並傳送回使用者之效率。因此’在本發明中對搜 尋時間可加以限定。若某一資料庫處理搜尋指令超過一預 設時間，由分送器2 8傳回錯誤訊息並結束搜尋，此錯誤訊 息將隨最後搜尋結果透過網際網路I傳送至使用者端10。 第三，利用CGI (Common Gateway Interface )等整 合介面技術，使用者端之電腦系統所使用之作業平台 (0S)可異於網站伺服器20所使用之作業平台。因此，本 發明所提供之資料庫系統可以跨作業平台處理資料搜尋的 工作。 最後’網路伺服器20將搜尋結果，包括自各資料庫 DB1〜DBN搜尋之符合搜尋指令之資料，以及超過此預定搜 尋時間之錯誤訊息’經由傳輸埠24與26以及輸入/出端 22，透過網際網路I傳送至使用者1〇。 第2困所示為根據本發明所揭示之第二實施例之系統 架構示意®。與第一實施例相同的包括：使用者透過網 際網路I與網站伺服器20’相連接，此連接方式可利用如 HTTP或FTP等網路相關傳輪協定加以完成β使用者端1〇可 為一電腦系統’此電腦系統連接網際網路I且有一顯示裝 置’並可發送複數搜尋指令。在網站伺服器中至少包 括一輸入/出端22 ’用以耦接網際網路I，搜尋指令由網 際網路I經輸入/出端22，傳送入網站伺服器2〇中；以及一 第一資料傳輸埠24，用以傳送搜尋指令。 446P G ： 五 '發明說明（7) 一 本實施例與第一實施例不同的是，網站词服器2〇，中 並未包括分送器28’以及資料庫DB1，〜DBM，^如前所述， 當連接網站词服器20’的使用者10越多時，網站二服器\〇, 需要提供更多的系統資源處理更多的搜尋指令。因此>需 分散式的主從架構分擔網站伺服器2 〇 ’的作業。 本發明第二實施例即揭示此類架構。前述第一實施 中傳輸埠26,與分送器28,由後級的發送伺服器3〇提供。 時，網站伺服器20’與發送伺服器3 〇分別負責不同的作 業。網站伺服器20’接收來自使用者10之搜尋指令，'並 此搜尋指令整合後經傳輸埠24,傳送至發送伺服^3〇之傳 輸埠26,》接著，網站伺服器20,可將此搜尋指令移除作 系統，以提供更多的系統資源處理其他使用者之搜尋指令 或疋其他例行作業。另一方面，在發送伺服器3〇中， 器28,可依據搜尋指令平行處理’對所對應之資料庫⑽丨，、 〜DBN’進行搜尋。相同地，分送器28可由軟體模擬產生’ 資料庫DB1〜DBN則儲存於單一儲存裝置或是分散儲存於數 個儲存裝置中’而此資料儲存裝置可同於一後級的資料飼 服器中’或是分散於複數個資料伺服器内。 同樣地，本發明之第二實施例亦包含於第一實施例中 所述三點特色，亦即發送器28,是以平行處理的模式發送 搜尋指令，每一對應搜尋資料庫的搜尋時間可由系統自行 決疋，且使用者端10之電腦系統所使用之作業平台（〇S) 可異於網站伺服器20’所使用之作業平台。 σ 因此，利用本發明所述之應用於ffffff環境之資料庫管446892 V. Description of invention (5) The agreement is completed. The user terminal 10 can be a computer system. The computer system is connected to the Internet I and has a display device, and can send plural search instructions. The web server 20 includes at least a plurality of databases DB1 to DBN for storing data; an input / output terminal 22 for coupling to the Internet I, and a search command corresponding to the database DB1 to DBN is provided by the Internet I is transmitted to the web server 20 via the input / output terminal 22; a first data transmission port 24 is used for transmitting a search command; a second data transmission port 26 is coupled to the first data transmission port 24 and receives the search command ; And a distributor 28, which simultaneously sends a search instruction according to the databases DB1 to DBN corresponding to the search instruction. When the user terminal 10 issues a search instruction, the search instruction is connected to the web server 20 through the Internet I according to a URL (Uniform Resource Location) using a network protocol. The search instruction is input / output 22 by the web server 20 Received and transmitted to transmitter 28 by transmissions 24 and 26. The distributor will send 7 search instructions to search in accordance with the database DB1 ~ DBN corresponding to the search instructions. In the first embodiment, the database ~ DBN and the distributor 28 are stored in the web server 20, wherein the distributor 28 can be generated by software simulation, and the databases DB1 to DBN are stored in a single storage device or distributed in a digital storage device. Storage devices. In this embodiment, there are several points worth noting: First, the search command is sent by the sender 28 in a parallel processing mode. In other words, at this time, in the databases DB1 to DBN, all the databases corresponding to the search command are in the same Searching at one time, compared with the conventional technology, which can only search each corresponding database sequentially according to the search instruction, the search processing method of the embodiment disclosed by the present invention is faster. Page 8 ^ 46892 V. Description of the invention (6) Second, the search time of each corresponding search database can be determined by the system. In the conventional technology, the long search time often affects the integration of search results and sends them back to use. Efficiency. Therefore, 'the search time can be limited in the present invention. If a database processes a search command for more than a preset time, the distributor 28 returns an error message and ends the search. This error message will be transmitted to the user terminal 10 through the Internet I with the final search result. Third, using integrated interface technologies such as CGI (Common Gateway Interface), the operating platform (OS) used by the client computer system can be different from the operating platform used by the web server 20. Therefore, the database system provided by the present invention can process data search work across operating platforms. Finally, the "web server 20 will search the results, including data that matches the search instructions from each database DB1 ~ DBN, and error messages exceeding this predetermined search time" via transmission ports 24 and 26 and input / output 22 through Internet I sends to user 10. The second stage is a schematic diagram of the system architecture according to the second embodiment of the present invention. The same as the first embodiment includes: the user is connected to the web server 20 'through the Internet I, and this connection method can be completed by using a network-related transfer protocol such as HTTP or FTP. A computer system 'this computer system is connected to the Internet I and has a display device' and can send plural search commands. The web server includes at least an input / output 22 'for coupling to the Internet I, and the search command is transmitted from the Internet I to the web server 20 through the input / output 22; and a first Data transmission port 24 is used for transmitting search commands. 446P G: Five 'Description of the Invention (7) One difference between this embodiment and the first embodiment is that the website word server 20 does not include the distributor 28' and the database DB1, DBM, ^ as before As mentioned above, when there are more users 10 connected to the web server server 20 ', the web server server needs to provide more system resources to process more search instructions. Therefore, a decentralized master-slave architecture is required to share the operations of the web server 20 '. The second embodiment of the present invention discloses such an architecture. In the aforementioned first embodiment, the transmission port 26 and the distributor 28 are provided by the transmission server 30 at the subsequent stage. At that time, the web server 20 'and the sending server 30 are respectively responsible for different operations. The web server 20 'receives a search command from the user 10,' and integrates this search command via transmission port 24 and transmits it to transmission port 26 of the sending server ^ 30. Then, the web server 20 can perform this search The instruction removal system is provided to provide more system resources to handle other users' search instructions or other routine operations. On the other hand, in the sending server 30, the server 28 can perform a parallel processing of the search command according to the search command to search the corresponding database ⑽ ,, ~ DBN '. Similarly, the distributor 28 can be generated by software simulation. 'Databases DB1 to DBN are stored in a single storage device or distributed in several storage devices', and this data storage device can be the same as a subsequent data feeder. Medium 'or spread across multiple data servers. Similarly, the second embodiment of the present invention also includes the three-point feature described in the first embodiment, that is, the transmitter 28 sends a search instruction in a parallel processing mode. The search time of each corresponding search database can be determined by The system decides on its own, and the operating platform (OS) used by the computer system of the client 10 may be different from the operating platform used by the web server 20 '. σ Therefore, the database management applied to the ffffff environment described in the present invention is used.
第10頁Page 10