JP2007094884A - Data search method and system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system, which records and stores a query sentence to a database and a search result to the query in a request source, compares a new query with the data, and retrieves the stored search result when correspondence is obtained, for reducing a processing period. <P>SOLUTION: In this data search method for sending a query sentence to the database 23 and acquiring a search result corresponding to the query sentence from the database 23, the query sentence and the search result acquiring according to the query sentence are stored in a data storage cache 14. When a new query sentence is inputted, an inquiry means 12 refers to the cache 14 for determining whether a query sentence stored in the past and having the meaning equal to that of the new query sentence and a search result corresponding to the query sentence in the past are stored in the cache 14. When such query sentence and search result are stored, the stored search result is retrieved to be offered to a query source 16. If such a query result is not stored, the query sentence is sent to the database 23 to request a search result. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a data search method and a data search system for sending an inquiry sentence to a database and obtaining a search result corresponding to the inquiry sentence from the database.

  In general, when processing related to a program is performed, for example, what a code number used in the program represents may be confirmed. In such a case, what each code number represents is inquired of a database stored in association with the code number, and a search result for this inquiry is obtained.

  In this way, in the so-called data search method in which a query is made to a database and a search result is obtained, conventionally, a query is sent from the client to the server after connecting to the server that manages the data from the client via the network unit. Sending out. Then, the retrieved result is returned from the server to the client, and the processing is realized.

  In this case, the inquiry text is always sent to the server, and the inquiry result is also sent to the client. For this reason, even if the same query as the previously issued query is required again in the series of processing, the query is issued from the client to the server via the network every time, and the retrieval result can be retrieved. Has been done.

  In this way, even when the same inquiry text is included in the repeated search processing, the inquiry text and the search result are transmitted and received through the network unit. Usually, since the time cost for passing through the network unit is high, there is a problem that the processing performance is lowered in consideration of this.

  In connection with such technical contents, there is a proposal related to a system in which a server holds shared data for a plurality of clients, and the shared data is transferred to the client and used in response to a request from the client (for example, Patent Documents). 1).

In this proposal, in order to eliminate unnecessary transfer of shared data and to suppress the occurrence of a bottleneck problem in the network bandwidth, whenever shared data is required, update information on the shared data temporarily stored in the client is obtained from the server and new updates are made. If it is done, it receives the updated shared data from the server.
Japanese Patent Application Laid-Open No. 2000-137689

  As described above, in handling data, it is necessary to reduce as much as possible to send and receive duplicate data through a network, including time costs.

  The object of the present invention is to record and save a query statement to the database side and a search result for this query in the request source, and when a new query is made, if the query statement matches the saved query statement, the query statement is sent out. First, it is an object to provide a data search method and a data search system that can reduce the entire processing time by taking out a search result stored in association with this inquiry sentence.

  The data search method of the present invention is a data search method for sending an inquiry sentence to a database and obtaining a search result corresponding to the inquiry sentence from the database, wherein the inquiry sentence and the search result obtained by the inquiry sentence are obtained. When a new inquiry sentence is input after being stored in a data storage cache, a past inquiry sentence having the same meaning as the new inquiry sentence and a past search result corresponding to the inquiry sentence are stored in the cache. If it is stored, retrieve the stored search result and provide it to the query source. If it is not stored, send the new query statement to the database to obtain the search result. It is characterized by.

  The data retrieval method of the present invention stores an inquiry sentence, a retrieval result obtained from the inquiry sentence, and an expiration date attached to the retrieval result in a data storage cache, and inputs a new inquiry sentence. The cache is inquired whether the past query sentence having the same meaning as the new query sentence and the past search result corresponding thereto are stored, and if stored, the stored search result is stored in the cache. It is determined whether it is within the expiration date, and if it is within the expiration date, the stored search result is provided to the inquiry source. If the expiration date has passed or has not been stored, the new inquiry is made. A sentence may be sent to a database to obtain a search result.

  The data search system of the present invention is a data search system for sending an inquiry sentence to a database and obtaining a search result corresponding to the inquiry sentence from the database, wherein the inquiry sentence and the search result obtained from the inquiry sentence are obtained. When a cache for storing data to be stored and an inquiry sentence for the database are input, a past inquiry sentence having the same meaning as the inquiry sentence and a past search result obtained by the past inquiry sentence are stored in the cache. If it is stored, it retrieves the past search result and provides it to the query source. If it is not stored, it sends the query statement to the database side and searches for this query statement. When the result is obtained from the database side, the obtained search result is inquired. Along with providing the, characterized in that a query means for storing in said cache in association with the query statement.

  In addition, the data retrieval system of the present invention, when an inquiry sentence and a data storage cache for storing a retrieval result obtained by the inquiry sentence and an inquiry sentence for the database are input, a past having the same meaning as the inquiry sentence. Inquiries and past search results obtained from this past inquiry sentence are inquired in the cache, and if so, refer to the expiration date attached to the past search results. If it is within the expiration date, this past search result is provided to the inquiry source.If this expiration date has passed or has not been stored, the inquiry statement is sent to the database side, and this inquiry statement is sent. When the search result for is obtained from the database side, the obtained search result is provided to the inquiry source and this Results may be configured with a query means for storing in the cache along with the expiration date in correspondence with the query statement.

  Further, the data search system of the present invention has a database in which search results are stored corresponding to a query sentence, and when the query sentence is received, the database system searches the database and outputs a corresponding search result; When the query text and the data storage cache for storing the search results obtained from the query text and the query text for the database are input, the past query text having the same meaning as the query text and the past query Inquires whether past search results obtained from the database are stored in the cache by sentence, and if stored, retrieves the past search results and provides them to the query source. , Send the query to the database system, and send the query When obtaining a search result from the database system against, as well as providing the source query search results obtained or may be configured as a query means for storing in said cache in association with the query statement.

  Furthermore, the data search system of the present invention includes a database in which search results are stored corresponding to a query statement and an expiration date table in which expiration dates for the search results are set, and when the query statement is received, A database system that searches a database and outputs a corresponding search result with the expiration date, a cache for storing data that stores the query and the search result obtained by the query, and queries to the database When a sentence is entered, it is inquired whether a past inquiry sentence having the same meaning as this inquiry sentence and a past search result obtained by this past inquiry sentence are stored in the cache. Refers to the expiration date attached to the past search results and is within the expiration date. If the past search result is provided to the inquiry source and the expiration date has passed or is not stored, the inquiry sentence is transmitted to the database system, and the search result for the inquiry sentence is sent to the database. When obtained from the system, the obtained search result may be provided to an inquiry source, and the obtained search result may be associated with the inquiry sentence and stored in the cache together with an expiration date.

  According to the present invention, instead of traversing a network unit that requires a long time to issue a query statement having the same content as a query statement issued in the past and to retrieve a search result, the high-speed cache is replaced. Since access is made, the entire processing time can be shortened, and efficient data retrieval becomes possible. Also, the search results held in the cache may differ from the contents on the database side as time passes. However, if past results are given an expiration date and discarded after a predetermined time, data It is possible to perform an accurate data search that maintains the consistency of data.

  Hereinafter, an embodiment of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing the overall configuration according to this embodiment. In FIG. 1, in this system, one client 10 and a server 20 are connected to each other via a network 30. In this data retrieval system, an inquiry sentence is sent from the client 10 to the database 23 provided in the server 20, and the client 10 obtains a retrieval result corresponding to the inquiry sentence from the database 23.

  The client 10 includes a network unit 11, an inquiry unit 12, an inquiry sentence / result recording unit 13, a data storage cache (hereinafter described as a local cache) 14, an application interface 15, and a client application 16.

  The application interface 15 is arranged to provide a unified interface to the client application 16 that is a data request source (also an inquiry source). Therefore, it has a function of receiving an inquiry request from the client application 16 and transmitting it to the inquiry means 12, and a function of taking out the search result from the inquiry means 12 and returning it to the client application 16 that is the data request source.

  The inquiry means 12 has a function of accepting an inquiry request from the application interface 15 and a function of inquiring the inquiry / result recording means 13 for an inquiry sentence included in the inquiry request. If there is a search result in the local cache 14 corresponding to a past inquiry sentence that has the same content as the inquiry sentence (same meaning) as a result of this inquiry, the search result is retrieved and returned to the application interface 15. It has a function to be provided to the client application 16 that is a request source.

  The inquiry unit 12 has a function of transmitting an inquiry sentence to the server 20 via the network 30 when the inquiry sentence does not match by the inquiry. When the search result for the query text is received from the server 20 via the network 30, the query / result recording unit 13 records the search result in the local cache 14 and returns the search result to the application interface 15. It also has a function to be provided to the client application 16 that is the request source.

  As described above, the inquiry / result recording unit 13 searches the local cache 14 when receiving the inquiry request from the inquiry unit 12 and extracts the matched past inquiry sentence, and searches that are recorded in association with each other. Has the function of retrieving the results. Further, if they do not match, it has a function of recording an inquiry sentence in the local cache 14. Further, the search result (data searched by the server 20) sent from the inquiry unit 12 is recorded in the local cache 14 in association with the inquiry sentence recorded immediately before.

  The local cache 14 records and holds an inquiry sentence and a search result corresponding to the inquiry sentence. Preparing this on a memory device is an example.

  The network unit 11 controls transmission / reception with respect to the network 30 between its own client 10 and the network 30.

  On the other hand, the server 20 includes a network unit 21, a database system 22, and a database 23.

  The network unit 21 controls transmission / reception with respect to the network 30 between its own server 20 and the network 30. The database system 22 has a function of interpreting a query sentence received by the network unit 21, extracting corresponding data from the database 23, and returning a search result to the client 10 via the network unit 21. The database 23 records and holds various data necessary for the database system 22, that is, search results corresponding to the inquiry sentence.

  Next, the operation will be described. First, as an example of data search in this embodiment, for example, a search for confirming what a code number used in a program represents will be described. Therefore, as shown in FIG. 2, the database 23 stores a code table in which the code number is associated with what the code number represents (name of organization in the example in the figure).

  In the flowchart of FIG. 3, in the client 10, when a query sentence is input via the application interface 15 from the client application 16 that is a data request source (inquiry source), the query unit 12 displays the query sentence / result recording unit 13. The inquiry is inquired to the local cache 14 via (ST1).

  This inquiry sentence is based on, for example, SQL, and is created as follows.

“SELECT name FROM code table WHERE code value =“ 00 ””
This query means that the name corresponding to the code value “00” (“head office” in the example of FIG. 2) is extracted from the code table.

  The inquiry means 12 determines whether or not a past inquiry sentence matching the inquiry sentence exists in the local cache 14 by this inquiry (ST2). If the inquiry sentences match (similar meaning sentences exist), it is determined that the corresponding search result (in this case, the name “head office”) is held in the local cache 14 by the past search. Therefore, the inquiry unit 12 retrieves the stored search result (name “head office”) from the local cache 14 through the inquiry sentence / result recording unit 13 (ST3).

  On the other hand, if it is determined in ST2 that the inquiry sentences do not match (similar sentence does not exist), the inquiry unit 12 issues an inquiry sentence to the server 20 via the network 30 by the network unit 11 (ST4). In the server 20, when the inquiry is received by the network unit 21, the database system 22 searches the database 23, retrieves a search result (name “head office”) corresponding to the inquiry, and the search result is obtained by the network unit 21. Return to the client 10 via the network 30.

  The query unit 12 retrieves the search result returned from the server 20 to the network unit 11 (ST5). The retrieved search result is recorded in the local cache 14 by the inquiry means 12 through the inquiry sentence / result recording unit 13 in preparation for reuse (ST6). Further, the inquiry unit 12 returns the search result retrieved from the server 20 or the local cache 14 to the client application 16 that is the data request source via the application interface 15 and provides it (ST7).

  As described above, in the client 10, when an inquiry sentence to the database 23 on the server 20 side is input from the client application 16 that is a data request source to the inquiry means 12 through the application interface 15, the meaning of the inquiry sentence is the same. It is inquired via the inquiry sentence / result recording means 13 whether the past inquiry sentence and the past search result obtained by this past inquiry sentence are stored in the local cache 14. If it is stored by this inquiry, the past search result is extracted and provided to the client application 16 side that is the inquiry source, and if it is not stored, an inquiry sentence is transmitted to the server 20 side having the database 23. To do. When the search result for the query sentence is obtained from the database 23 on the server 20 side, the obtained search result is provided to the client application 16 side as the query source, and stored in the local cache 14 in correspondence with the query sentence. I am letting.

  According to the above embodiment, not all of the issuance of query statements and retrieval of search results that occurred in the search process in the client 10 are made via the network 30, but only unqueried sentences are inquired to the server 20 by the network 30. Therefore, it is possible to reduce the time for data that is expensive in terms of time to travel through the network and to improve the processing efficiency. In addition, since past inquiry sentences are inquired using the inquiry sentence itself as a key, the inquiry function is simplified, and the effect is improved as the system repeats many similar inquiry sentences.

  Next, the embodiment shown in FIG. 4 will be described. In this embodiment, the server and client shown in FIG. 1 are realized on the same computer 10. That is, in the example of FIG. 1, the server 10 and the client 20 are realized by separate computers, and these are connected by the external network 30, but in FIG. 4, on the same computer 10 Both of these functions have been realized. Specifically, the client side inquiry unit 12 and the server side database system 22 are directly linked via the network unit 11 without going through the external network 30.

  In this case, based on a request from the client application 16, the inquiry unit 12 directly sends an inquiry statement that does not exist in the local cache 14 to the database system 22 via the network unit 11, and the search result is sent to the database system 22. Via the network unit 11. The other functions are all the same as those shown in FIG.

  In the case of the embodiment of FIG. 4, the network unit 11 receives an inquiry sentence from another client (not shown) by the external network 30, and sends the search result by the database system 22 to another client (not shown) via the network 30. You can also answer.

  Next, the embodiment shown in FIG. 5 will be described. In this embodiment, an expiration date is attached to the search result obtained by the inquiry statement in the embodiment of FIG. 1, and the consistency of data is improved by discarding the search result after the expiration date. Yes. That is, the data held in the database is not always constant, and may be changed by updating or the like. For this reason, after a long period of time, there is a discrepancy between the data in the database and the data stored in the cache of the client, and there is a problem that the consistency of the data cannot be maintained.

  As described above, the search result held in the local cache may be different from the contents on the database side as time passes. Therefore, in the embodiment of FIG. 5, the search result held in the local cache is attached to the search result. When the specified valid period is exceeded, this data is discarded to improve the consistency of data as a system.

  Note that FIG. 5 has many parts that are common to the configuration of FIG. 1 described above.

  In this system as well, one client 40 and server 20 are connected to each other via a network 30, and an inquiry sentence is sent from the client 40 to the database 23 provided in the server 20, and this inquiry sentence is dealt with. This is a data search system in which a client 40 obtains search results from a database 23.

  The client 40 includes a network unit 41, an inquiry unit 42, an inquiry sentence / result recording unit 43, a data storage cache (hereinafter referred to as a local cache) 44, an application interface 45, and a client application 46.

  The application interface 45 and the client application 46 have the same functions as those in FIG. 1. The application interface 45 accepts an inquiry request from the client application 46 and transmits it to the inquiry means 42, and the search result from the inquiry means 42. It has a function of taking out and returning it to the client application 16.

  The inquiry means 42 has a function of receiving an inquiry request from the application interface 45 and a function of inquiring the inquiry / result recording means 43 for an inquiry sentence included in the inquiry request. If the search result corresponding to the past inquiry sentence (which has the same meaning) matches the contents of the inquiry sentence exists in the local cache 14 as a result of this inquiry, the local cache 14 has a function of retrieving the search result.

  Here, an expiration date is attached to the search result as will be described later, and only when the expiration date is within the expiration date, the search result is returned to the application interface 45 and provided to the client application 46 that is the request source. To do.

  Further, the inquiry means 42 sends an inquiry sentence via the network 30 when the inquiry sentence does not match due to the inquiry, and when it matches but the expiration date attached to the search result has passed. Is transmitted to the server 20. When a search result for the query text is received from the server 20 via the network 30, the query / result recording unit 43 records the search result together with the expiration date in the local cache 44. Further, it has a function of returning the search result to the application interface 45 and providing it to the client application 46 that is a request source.

  When the inquiry / result recording unit 43 receives the inquiry request from the inquiry unit 42, the inquiry / result recording unit 43 searches the local cache 44 and extracts the matched past inquiry sentence. Then, the inquiry / result recording unit 43 displays the associated search result together with the expiration date. Has the function of taking out. Further, if they do not match, it has a function of recording an inquiry sentence in the local cache 44. Further, the search result (data searched by the server 20) sent from the inquiry means 42 and its expiration date are recorded in the local cache 44 in association with the inquiry sentence recorded immediately before.

  The local cache 44 records and holds an inquiry sentence, a search result corresponding to the inquiry sentence, and an expiration date. Preparing this on a memory device is an example.

  The network unit 41 controls transmission / reception with respect to the network 30 between its own client 40 and the network 30.

  On the other hand, the server 20 includes a network unit 21, a database system 22, and a database 23.

  The network unit 21 controls transmission / reception with respect to the network 30 between its own server 20 and the network 30. The database system 22 has a function of interpreting an inquiry sentence received by the network unit 21, extracting corresponding data from the database 23, and returning a search result to the client 40 via the network unit 21. The database 23 records and holds various data necessary for the database system 22, that is, search results corresponding to the inquiry sentence. In addition, an expiration date table 24 is included therein, and the expiration date of the inquiry search result is held.

  Next, the operation will be described. The database 23 in this embodiment also stores the equivalent of the code table shown in FIG. 2 that associates the code number with what the code number represents (name of organization in the example in the figure). It shall be. Further, the name for each code number is given an expiration date by the expiration date table 24 shown in FIG. Usually, the name of the organization shown in FIG. 2 is not changed so much, but the name of the product may be changed relatively frequently. For example, “September” Each term is given an expiration date, such as “Valid until 30 days”. In other words, it may be used to guarantee that it will not be changed until the expiration date.

  In the flowchart of FIG. 6, when the client 40 receives a query sentence from the client application 46 that is a data query source via the application interface 45, the query means 42 is connected locally via the query sentence / result recording unit 43. An inquiry is inquired to the cache 44 (ST11).

  The inquiry means 42 determines whether a past inquiry sentence matching the inquiry sentence exists in the local cache 44 by this inquiry (ST12). If the inquiry texts match (consent texts exist), it is determined that the corresponding result is retained in the local cache 44 by the past search. With reference to the time limit, it is determined whether it is within the time limit (ST13). If it is within the expiration date, it is determined that a valid search result is held in the local cache 44. Therefore, the held valid search result is extracted from the local cache 44 through the query / result recording means 43. Perform (ST14).

  On the other hand, if it is determined in ST12 that the inquiry sentence does not match (no agreement sentence exists), or if the expiration date has expired in ST13, the inquiry means 42 is sent from the server 30 via the network 30 by the network unit 41. An inquiry statement and an expiration date inquiry statement are issued (ST15). In the server 20, when the query sentence is received by the network unit 21, the database system 22 searches the database 23, retrieves a search result corresponding to the query sentence together with its expiration date, and the network part 21 retrieves the result by the network 30. To the client 40 via

  The query means 42 retrieves the search results returned from the server 20 to the network unit 41 (ST16). The retrieved search result is overwritten and recorded in the local cache 44 by the inquiry means 42 through the inquiry sentence / result recording unit 43 in preparation for reuse, together with its expiration date (ST17). Therefore, search result data that has expired is automatically discarded.

  Further, the inquiry means 42 returns the search result retrieved from the server 20 or the local cache 44 to the client application 46 that is the data inquiry source via the application interface 45 and provides it (ST18).

  As described above, in the client 40, when an inquiry sentence to the database 23 on the server 20 side is input from the client application 46 that is a data request source to the inquiry means 42 through the application interface 45, the meaning of the inquiry sentence is the same. It is inquired via the inquiry sentence / result recording means 43 whether the past inquiry sentence and the past search result obtained by this past inquiry sentence are stored in the local cache 44. If it is stored by this inquiry, the expiration date attached to the past search result is referred to, and if it is within the expiration date, this past search result is provided to the client application 46 side that is the inquiry source. On the other hand, when the expiration date has passed or it has not been stored, an inquiry sentence is transmitted to the server 20 side having the database 23. When the search result for the query sentence is obtained from the database 23 on the server 20 side, the obtained search result is provided to the client application 46 side as the query source, and the local cache is associated with the query sentence together with an expiration date. 44.

  According to the embodiment of FIG. 5 described above, as in the embodiment of FIG. 1, all of the issuance of query statements generated in the search process in the client 40 and the retrieved search results are not transmitted via the network 30. Therefore, it is possible to reduce the time for data that is expensive in time to travel through the network, and to improve the processing efficiency. In addition, since past inquiry sentences are inquired using the inquiry sentence itself as a key, the inquiry function is simplified, and the effect is improved as the system repeats many similar inquiry sentences. Further, in the embodiment of FIG. 5, by using the expiration date, it becomes possible to reduce the staleness of the local cache 44 and improve the consistency of data as a system.

  Next, the embodiment shown in FIG. 7 will be described. In this embodiment, the server and the client shown in FIG. 5 are realized on the same computer 40. That is, the client-side inquiry means 42 and the server-side database system 22 are directly connected via the network unit 41 without going through the external network 30.

  In this case, based on the request from the client application 46, the inquiry means 42 displays the inquiry sentence when the inquiry sentence does not exist in the local cache 44 or when the validity period of the search result has exceeded even if it exists. The data is directly sent to the database system 22 via the network unit 41, and the search result is obtained from the database system 22 via the network unit 41 together with the expiration date. The other functions are all the same as those shown in FIG.

  In the case of the embodiment of FIG. 7, the network unit 41 accepts an inquiry sentence from another client (not shown) by the external network 30, and retrieves the search result by the database system 22 and its expiration date via the network 30. It is possible to reply to a client (not shown).

It is a block diagram which shows one Embodiment of the data search system by this invention. It is a figure explaining the code table preserve | saved in the database in one Embodiment same as the above. It is a flowchart explaining the effect | action of one Embodiment same as the above. It is a block diagram which shows the example which implement | achieved the system configuration | structure shown in FIG. 1 with the same computer. It is a block diagram which shows other embodiment of this invention. It is a flowchart explaining the effect | action of other embodiment same as the above. FIG. 6 is a block diagram showing an example in which the system configuration shown in FIG. 5 is realized by the same computer.

Explanation of symbols

12 Inquiry means 14 Cache for data storage 16 Client application as inquiry source 22 Database system 23 Database

Claims (6)

A data search method for sending an inquiry sentence to a database and obtaining a search result corresponding to the inquiry sentence from the database,
Store the inquiry sentence and the search result obtained by this inquiry sentence in a cache for data storage,
When a new inquiry sentence is input, it is inquired whether a past inquiry sentence having the same meaning as the new inquiry sentence and a past search result corresponding to the inquiry sentence are stored in the cache,
If stored, this stored search result is retrieved and provided to the query source. If not stored, the new query is sent to the database to obtain the search result. retrieval method. A data search method for sending an inquiry sentence to a database and obtaining a search result corresponding to the inquiry sentence from the database,
The inquiry sentence, the search result obtained by this inquiry sentence, and the expiration date attached to the search result are stored in a cache for data storage,
When a new inquiry sentence is input, an inquiry is made as to whether a past inquiry sentence having the same meaning as the new inquiry sentence and a past search result corresponding thereto are stored in the cache,
If it is stored, it is determined whether the stored search result is within the expiration date, and if it is within the expiration date, the stored search result is provided to the inquiry source, and the expiration date is set. A data search method characterized in that if it has passed or has not been stored, the new query is sent to a database to obtain a search result. A data search system that sends an inquiry sentence to a database and obtains a search result corresponding to the inquiry sentence from the database,
A cache for storing data that stores the query and search results obtained by the query;
When an inquiry sentence for the database is input, it is inquired whether a past inquiry sentence having the same meaning as the inquiry sentence and a past search result obtained by the past inquiry sentence are stored in the cache, and stored. If it is, the past search results are extracted and provided to the query source.If the search results are not stored, the query is sent to the database, and the search results for the query are obtained from the database. Inquiry means for providing the obtained search result to a query source and storing the obtained search result in the cache in correspondence with the query statement;
A data search system characterized by comprising: A data search system that sends an inquiry sentence to a database and obtains a search result corresponding to the inquiry sentence from the database,
A cache for storing data for storing the query and search results obtained by the query;
When an inquiry sentence for the database is input, it is inquired whether a past inquiry sentence having the same meaning as the inquiry sentence and a past search result obtained by the past inquiry sentence are stored in the cache, and stored. If it is within the expiration date with reference to the expiration date attached to the past search result, the past search result is provided to the inquiry source, and if this expiration date has passed or is stored If not, send the inquiry sentence to the database side, and when the search result for the inquiry sentence is obtained from the database side, the obtained search result is provided to the inquiry source, and the obtained result is referred to as the inquiry sentence. Inquiry means correspondingly stored in the cache together with an expiration date;
A data search system characterized by comprising: A database system that has a database in which search results are stored corresponding to a query, and that receives the query and searches the database and outputs a corresponding search result;
A cache for storing data that stores the query and search results obtained by the query;
When an inquiry sentence for the database is input, a past inquiry sentence having the same meaning as the inquiry sentence and a past search result obtained from the database by the past inquiry sentence are inquired about in the cache, If it is stored, the past search result is retrieved and provided to the inquiry source. If it is not stored, the query is sent to the database system, and the search result for the query is sent from the database system. When obtained, inquiry means for providing the obtained search result to the inquiry source, and storing it in the cache in correspondence with the inquiry sentence;
A data search system characterized by comprising: A database in which search results are stored corresponding to a query sentence, and an expiration date table in which expiration dates for the search results are respectively set. When the query sentence is received, the database is searched and the corresponding search results are displayed. A database system for outputting with the expiration date;
A cache for storing data for storing the query and search results obtained by the query;
When an inquiry sentence for the database is input, it is inquired whether a past inquiry sentence having the same meaning as the inquiry sentence and a past search result obtained by the past inquiry sentence are stored in the cache, and stored. If it is within the expiration date with reference to the expiration date attached to the past search result, the past search result is provided to the inquiry source, and if this expiration date has passed or is stored If not, send the inquiry sentence to the database system, and obtain the search result for the inquiry sentence from the database system, and provide the obtained search result to the inquiry source. Query means associated with a statement and stored in the cache with an expiration date;
A data search system characterized by comprising:

Images