JP2006127123A - Application server, database server, web retrieval system, retrieval result acquisition method, retrieval result response method, retrieval result acquisition program and retrieval result response program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To perform retrieval and display of latest data, and to reduce access to a database, in a Web retrieval system. <P>SOLUTION: In this application server 130, a cache management part 132 associates, stores and manages a page ID of a retrieving Web page, inputted retrieval condition data, and retrieval result data, and a change information reception part 134 receives a table ID of a changed table from a DB server 140, and deletes the related retrieval result data from the cache management part 132 on the basis of association of the table ID and the page ID stored in an AP property storage part 133. In the DB server 140, a change detection part 142 detects the change of the data table, and outputs the table ID of the data table to the database 141, and a change information transmission part 144 transmits the table ID of the changed data table to each application server 130 in each time interval stored by a DB property storage part 143. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to an application server, a database server, a web search system, a search result acquisition method, a search result response method, a search result acquisition program, and a search result response program in web search.

With the spread of the Internet or Intranet in recent years and the advancement of Java (registered trademark) technology, the construction of a WWW (World Wide Web) multi-tier system using an application server has become common.
That is, as shown in FIG. 1, the system includes a WWW server 120, an application server 130, and a DB (database) server 140.
Middleware such as the WWW server 120, application server 130, and DB server 140 with RDBMS that make up each layer of the presentation layer, business logic layer, and database layer has a cache function to reduce response time and network traffic. keeping. The individual cache function provided by each middleware is described in detail in a manual provided by each middleware vendor.
In addition, there is a proxy server that caches accumulated data and notifies the proxy server of the changed accumulated data by the server having the accumulated data (Patent Document 1).
JP-A-11-249950

The above conventional techniques have the following problems.
The cache function provided by each middleware (WWW server 120, application server 130, DB server 140) is transparent to the application in consideration of usability, and the cache function can be explicitly controlled from the application. Absent.
The cache function provided by each middleware (WWW server 120, application server 130, DB server 140) mainly targets static data.
Some middleware has a function to manage and control dynamically generated data as cache data, but the lifetime of cache data is controlled based on time and the number of accesses to the cache data. In some situations, invalid data may be returned to the client.

As described above, since the cache functions provided by each middleware operate independently and do not operate in cooperation with each other, they are not consistent when viewed as a system.
In general, in a WWW multi-tier system, in order to improve the scalability and availability of the entire system, a medium to large-scale system has a cluster configuration, but session information can be shared among servers constituting each layer. Data sharing is not possible.
When the WWW multi-tier system is applied to an information system or a monitoring system, access to the server side occurs from all connectable clients at regular and relatively short intervals (30 seconds to 1 minute intervals).
For example, aircraft tracking / display systems and auction monitoring systems.
In the case of such a system, if all accesses are started up to the DB server each time, an expensive server with high processing performance is required.
Also, cache data cannot be managed for each search web page for acquiring information.

Based on the above problems, for example, in the WWW multi-tier system, the present data is always searched and displayed when there is access from all clients that can be connected to the system regularly and in a relatively short cycle. The purpose is to make it possible to greatly reduce access to the database layer.
Another object is to enable cache data to be managed for each search web page.

  An application server of the present invention includes a search result acquisition unit that acquires search result data from a database server based on a page ID (IDentification) for identifying a search web page and search condition data specified on the search web page; A cache management unit that stores and manages the page ID, the search condition data, and the search result data acquired by the search result acquisition unit, a page ID, the search condition data, and a table included in the database managed by the database server. An AP (application) property storage unit that associates and stores a table ID to be identified, a table ID of a table that has been changed from the database server, and a page ID and search condition data associated with the received table ID. AP property description And a change information receiving unit that outputs a command signal for deleting the search result data associated with the page ID and the search condition data acquired from the AP property storage unit to the cache management unit. To do.

According to the present invention, for example, in a WWW multi-tier system, when access is constantly made from all clients that can be connected to the system in a relatively short cycle, it is guaranteed that the latest data is always searched and displayed. At the same time, access to the database layer can be greatly reduced.
That is, it is possible to provide a WWW multi-tier system having a push-type cache management mechanism that can shorten a response time to a client, use a relatively inexpensive server for a database layer, and enable a cost-effective system construction. Etc.
Also, for example, cache data can be managed for each search web page.

Embodiment 1 FIG.
FIG. 2 is a diagram illustrating an appearance of each device included in the web search system according to the first embodiment.
2, a user terminal 100, a WWW server 120, an application server 130, and a DB server 140 are a system unit 910, a CRT (Cathode Ray Tube) display device 901, a keyboard (K / B) 902, a mouse 903, a compact disk device ( CDD) 905, a printer device 906, and a scanner device 907, which are connected by a cable.
Further, the user terminal 100, the WWW server 120, the application server 130, and the DB server 140 are connected to the FAX machine 932 and the telephone 931 with a cable, and are also provided with a local area network (LAN) 942 such as an intranet and a proxy server 941. Via the Internet 940.

FIG. 3 is a hardware configuration diagram of each device included in the web search system according to the first embodiment.
In FIG. 3, the user terminal 100, the WWW server 120, the application server 130, and the DB server 140 include a CPU (Central Processing Unit) 911 that executes a program. The CPU 911 includes a ROM 913, a RAM 914, a communication board 915, a CRT display device 901, a K / B 902, a mouse 903, an FDD (Flexible Disk Drive) 904, a magnetic disk device 920, a CDD 905, a printer device 906, and a scanner device 907 via a bus 912. Connected with.
The RAM 914 is an example of a volatile memory. The ROM 913, the FDD 904, the CDD 905, the magnetic disk device 920, and the optical disk device are examples of nonvolatile memories. These are examples of a storage device or a storage unit.
The communication board 915 is connected to a FAX machine 932, a telephone 931, a LAN 942, and the like.
For example, the communication board 915, the K / B 902, the scanner device 907, the FDD 904, and the like are examples of the information input unit.
Further, for example, the communication board 915, the CRT display device 901, and the like are examples of the output unit.

Here, the communication board 915 is not limited to the LAN 942 and may be directly connected to the Internet 940 or a WAN (Wide Area Network) such as ISDN. When directly connected to the Internet 940 or a WAN such as ISDN, the user terminal 100, the WWW server 120, the application server 130, and the DB server 140 are connected to the Internet 940 or a WAN such as ISDN, and the proxy server 941 It becomes useless.
The magnetic disk device 920 stores an operating system (OS) 921, a window system 922, a program group 923, and a file group 924. The program group 923 is executed by the CPU 911, the OS 921, and the window system 922.

The program group 923 stores programs that execute functions described as “˜units” in the description of the embodiments described below. The program is read and executed by the CPU 911.
In the file group 924, what is described as “determination result of”, “calculation result of”, and “processing result of” in the description of the embodiment described below is stored as “˜file”. Yes.
In addition, the arrow portion of the flowchart described in the description of the embodiment described below mainly indicates input / output of data, and for the input / output of the data, the data is the magnetic disk device 920, FD (Flexible Disk cartridge), It is recorded on other recording media such as an optical disc, CD (compact disc), MD (mini disc), and DVD (Digital Versatile Disk). Alternatively, it is transmitted through a signal line or other transmission medium.

  In addition, what is described as “unit” in the description of the embodiment described below may be realized by firmware stored in the ROM 913. Alternatively, it may be implemented by software alone, hardware alone, a combination of software and hardware, or a combination of firmware.

  In addition, a program that implements the embodiment described below may be stored using a recording device using another recording medium such as a magnetic disk device 920, FD, optical disk, CD, MD, or DVD.

FIG. 4 is a configuration diagram of the web search system in the first embodiment.
4, in the web search system, a user terminal 100, a WWW server 120, an application server 130, and a DB server 140 are connected to a network 110.
The user terminal 100 includes a WWW browser, a Java (registered trademark) applet, a Java (registered trademark) application, and the like.
The user terminal 100 is positioned in the presentation layer of the web search system, which is a WWW multi-tier system, and issues a request to the server, receives a response from the server, and displays the result.
For example, search condition data is input on a search web page to request a search from the server, and search result data is received from the server and displayed as a search result web page.
The network 110 is the Internet, an intranet, or the like, and provides a communication path between the client and the server.
The WWW server 120 is positioned in the presentation layer together with the user terminal 100, receives a request from a client, passes the request to the application server 130, and returns the result processed by the application server 130 to the user terminal 100 as a response.
For example, the page data of the search web page is output to the user terminal 100, the search condition data input using the search web page indicated by the output page data, and the page ID (IDentification) of the search web page , The input page ID and the search condition data are transmitted to the application server 130, the search result data is received from the application server 130, and the page data of the search result web page based on the received search result data is transmitted to the user terminal 100. Output to.

The application server 130 includes the following, and acquires search result data from the DB server 140.
A search result acquisition unit 131 that acquires search result data from the DB server 140 based on a page ID for identifying a search web page and search condition data specified on the search web page.
A cache management unit 132 that stores and manages the page ID, the search condition data, and the search result data acquired by the search result acquisition unit in association with each other.
An AP (application) property storage unit 133 that stores a page ID, search condition data, and a table ID for identifying a table included in a database managed by the DB server 140 in association with each other.
The table ID of the changed table is received from the DB server 140, the page ID and the search condition data associated with the received table ID are acquired from the property storage unit, and the page ID and the search condition acquired from the property storage unit A change information receiving unit 134 that outputs a command signal for deleting search result data associated with data to the cache management unit.

The DB server 140 includes the following, and outputs search result data to the application server 130.
A database 141 that stores a data table that holds various types of data searched from the application server 130 and a management table that holds a table ID for identifying the changed data table.
A search result transmission unit 145 that receives a search request from the application server 130, acquires search result data from the database 141, and transmits the search result data to the application server 130.
A change detection unit 142 that detects a change in the data table stored in the database and outputs the table ID of the changed data table to the management table stored in the database.
A DB property storage unit 143 that stores a time interval for monitoring the management table and an application server address indicating the location of the application server.
A change information transmission unit 144 that transmits the table ID indicated by the management table to the application server indicated by the application server address stored in the property storage unit for each time interval stored in the property storage unit.

  Here, the WWW server 120, the application server 130, and the DB server 140 may be separately provided in separate cases, or may be provided in a single case. The WWW server 120 and the application server 130 may be deployed in the same casing, and the DB server 140 may be deployed in a separate casing.

FIG. 5 is a flowchart showing the flow of processing of the application server 130 in the first embodiment.
A flow of processing in which the application server 130 according to the first embodiment transmits search result data to the WWW server 120 based on the page ID and search condition data received from the WWW server 120 will be described with reference to FIG.

  The search result acquisition unit 131 receives the page ID and search condition data from the WWW server 120, and outputs the received page ID and search condition data to the cache management unit 132 (S101).

  The cache management unit 132 searches whether the search result data corresponding to the received page ID and search condition data is stored, that is, searches for the corresponding cache data (S102).

FIG. 6 is a diagram illustrating a data format stored and managed by the cache management unit 132 according to the first embodiment.
The process of S102 will be described with reference to FIG.
The cache management unit 132 stores an address indicating the storage position of the search result data corresponding to the page ID, the search condition name, and the keyword, and stores the search result data at the storage position indicated by the address.
The search condition name is format name data that identifies the format of the search condition. For example, the search web page has search conditions of “price”, “size”, and “color”. In this case, a format in which "Price", "Size" and "Color" are specified, a format in which "Price" and "Size" are specified, and a format in which "Price" and "Color" are specified There are a total of seven formats: a format in which “size” and “color” are designated, and a format in which any one of “price”, “size”, and “color” is designated. The format name data for identifying these formats is the search condition name.
A keyword is condition data specified as a search condition. For example, data indicating the 10000 yen range that is the “price” condition and data indicating the M size that is the “size” condition are keywords.
The search condition data includes a keyword and a search condition name.
The cache management unit 132 searches the corresponding search result data using the page ID, the keyword included in the search condition data, and the search condition name as search keys.
By using the page ID as a search key, the cache for each search web page can be managed.

FIG. 7 is a diagram illustrating a cache log stored by the cache management unit 132 according to the first embodiment.
The cache management unit 132 may store and manage a cache log as shown in FIG. By storing and managing the cache log, the system administrator can grasp the cache status.
For example, the date and time when the cache was accessed, the page ID and search condition name when accessed, and the access result may be stored and managed.
By including the page ID, it is possible to grasp the cache status for each search web page.
The access result is identified by hit indicating that a valid cache exists, miss indicating that no valid cache exists, register indicating that the cache has been registered, clear indicating that the cache has been cleared, and the like. Good.

In FIG. 5, when it is determined that the cache management unit 132 stores the corresponding search result data, the cache management unit 132 acquires the corresponding search result data from the storage unit and outputs it to the search result acquisition unit 131. That is, the cache data is extracted (S103).
The search result acquisition unit 131 transmits search result data to the WWW server 120, that is, returns cache data (S104).

When the cache management unit 132 determines that the corresponding search result data is not stored, the search result acquisition unit 131 transmits the keyword included in the search condition data to the search result transmission unit 145 of the DB server 140. A search request is made, and search result data is received from the search result transmission unit 145 of the DB server 140 (S105).
The search result acquisition unit 131 outputs the received search result data, the search condition data for the search result data, and the page ID to the cache management unit 132. The cache management unit 132 outputs the page ID and the search condition name included in the search condition data. The search result data is stored in association with the keywords, that is, the search result data is registered as cache data (S106).
The search result acquisition unit 131 transmits the search result data to the WWW server 120 (S104).

  In addition, when registering the search result data as cache data, the cache management unit 132 stores the registration time together with the search result data, and if it is determined that the corresponding search result data is stored in S102, The registration time of data may be determined. If the registration time is old, the search result data may be determined as invalid cache data and deleted, and new search result data may be acquired from the DB server 140 (S105, S106). . Thereby, the consistency of cache data can be improved.

  In the above description, in response to a request from the user terminal 100, the application server 130 returns the cache data to the user terminal 100 via the WWW server 120 when the cache management unit 132 holds the cache data. If the data does not exist, the DB server 140 is inquired to retrieve the data, register it as cache data, and return it to the user terminal 100.

  Next, transmission of change information related to the change of the data table in the DB server 140 and cache management based on the change information in the application server 130 will be described.

  In the DB server 140, when any change, for example, addition, change, or deletion of a record occurs in the data table of the database 141, the change detection unit 142 detects it and stores it in the management table of the database 141. The management table is monitored, and if there is a change, the change information transmission unit 144 is notified. The change information transmission unit 144 transmits the change contents to each application server indicated by the application server address stored in the DB property storage unit 143.

FIG. 8 is a diagram illustrating a trigger definition sentence that stores information of the data table changed to the management table in the first embodiment.
When a relational database is used as the database 141, a trigger is generated when the data table is changed by a definition statement as shown in FIG. 8, and the information of the changed data table is added to the management table identified by TBL_UPDATE_TIME. Can be stored.

FIG. 9 is a diagram showing a table format of the management table in the first embodiment.
The management table identified by TBL_UPDATE_TIME may have a table format as shown in FIG. 9, for example.
TBL_ID indicates a table ID for identifying the changed data table, UPDATE_TIME indicates the time when the data is changed, and ACTION indicates the contents of the change.

FIG. 10 is a flowchart showing the flow of processing of the DB server 140 in the first embodiment.
Processing for transmitting the data table change information performed by the DB server 140 in the first embodiment to the application server 130 will be described with reference to FIG.

The change information transmission unit 144 refers to the management table stored in the database 141 for each monitoring time interval stored in the DB property storage unit 143, and determines whether the content of the management table has been changed (S201).
A change in the management table indicates that there is a new change in the data table.
If it is determined that the contents of the management table have not been changed, the contents of the management table are again determined when the monitoring time elapses.

  When it is determined that the contents of the management table have been changed, the change information transmission unit 144 refers to the management table stored in the database 141 and acquires the changed table ID (S202).

  The change information transmission unit 144 transmits the change information including the acquired table ID addressed to the application server address stored in the DB property storage unit 143 (S203).

FIG. 11 is a diagram showing the contents stored in the DB property storage unit 143 according to the first embodiment.
In FIG. 11, 172.16.192.50 and 172.16.192.51 are IP (Internet Protocol) addresses of application servers that send change information, and APP01 and APP02 are host names of application servers that send change information. is there. The interval is a time interval for monitoring the management table.
When the DB server 140 includes the DB property storage unit 143 having the storage content illustrated in FIG. 11, the change information transmission unit 144 determines whether the content of the management table is changed every 30 seconds (S201), and 172.16.192. Change information including the changed table ID is transmitted to the application server identified by APP01 having an address of 50 and the application server identified by APP02 having an address of 172.16.192.51 (S202, S203). .
By adjusting the monitoring time interval indicated by the interval, the lifetime of the cache data stored on the application server 130 can be adjusted.

FIG. 12 is a diagram illustrating change information that the DB server 140 according to the first embodiment transmits to the application server 130.
In step S <b> 203, the change information transmission unit 144 generates change information as illustrated in FIG. 12 and transmits the change information to the application server 130, for example.
The change information shown in FIG. 12 is described in XML (extensible Markup Language).
The upd_time tag indicates the date and time when the change occurred, the tbl_id tag indicates the table ID of the changed data table, the action tag indicates the change contents, and the serial_num tag indicates the serial number.
The change information transmission unit 144 acquires the date and time when the change occurred, the table ID, and the change contents from the management table. The management table shown in FIG. 9 corresponds to UPDATE_TIME, TBL_ID, and ACTION, respectively.
Further, the change information transmission unit 144 may store the number of times the change information has been transmitted to the application server 130, and may be included in the change information as a serial_num tag serial number as shown in FIG.
By including the serial number in the change information, the application server 130 can determine whether all the change information transmitted by the DB server has been received, and the consistency of the cache data can be improved.

FIG. 13 is a flowchart showing a process flow of the application server 130 in the first embodiment.
Processing of the application server 130 that has received the change information from the change information transmission unit 144 of the DB server 140 in Embodiment 1 will be described with reference to FIG.

The change information receiving unit 134 of the application server 130 receives the data table change information transmitted by the DB server 140 (S301).
For example, assume that change information as shown in FIG. 12 is received.
The change information receiving unit 134 compares the serial number indicated by the serial_num tag included in the received change information with the stored serial number (S302).
The change information receiving unit 134 stores the serial number when the change information is received. By comparing this serial number with the serial number included in the next received change information, the consistency of the cache data can be improved.
As a result of the comparison, if the serial number included in the received change information is not a consecutive number with the stored serial number, that is, if it is determined that there is change information that has not been received, the changed data is stored as cache data. Therefore, the change information receiving unit 134 activates the cache management unit 132, and the cache management unit 132 deletes all stored cache data (S303).
As a result of comparison, if the serial number included in the received change information is a continuous number with the stored serial number, that is, if it is determined that all the change information transmitted by the DB server 140 has been received, the change The cache data related to the changed table indicated by the table ID included in the information is searched and deleted. Search and delete are performed as follows.
The change information receiving unit 134 refers to the storage information in the AP property storage unit 133, acquires the page ID and search condition name related to the table ID included in the received change information, and acquires the acquired page ID and search condition name. Is output to the cache management unit 132, and the cache management unit 132 searches the cache data related to the page ID and the search condition name (S304).

14, FIG. 15, FIG. 16, and FIG. 17 are diagrams showing storage information of the AP property storage unit 133 in the first embodiment.
FIG. 14 is a table that stores search condition names related to the page ID using the page ID as a key.
FIG. 15 is a table that stores a table ID related to a search condition name using the search condition name as a key.
FIG. 16 is a table that stores search condition names related to the table ID using the table ID as a key.
FIG. 17 is a table that stores page IDs related to the search condition name using the search condition name as a key.
The change information receiving unit 134 refers to these tables stored in the AP property storage unit 133 and acquires a page ID and a search condition name related to the table ID included in the received change information. However, the format of the stored information in the AP property storage unit 133 may not be the above table.

  The cache management unit 132 uses the page ID and the search condition name acquired by the change information receiving unit 134 from the cache data stored in the format shown in FIG. Search cache data you have.

  In FIG. 13, as a result of the search, the cache management unit 132 deletes the cache data having the page ID and the search condition name as a key, that is, cache data related to the changed data table (S303).

FIG. 18 is a diagram showing change information transmitted from the DB server 140 to the application server 130 in the first embodiment.
In the above description, the change information transmission unit 144 of the DB server 140 transmits the change information as shown in FIG. 12 to the application server 130, and the change information reception unit 134 and the cache management unit 132 of the application server 130 change the change information into the change information. The case where the cache data related to the data table indicated by the included table ID is deleted has been described.
In addition, the change information transmission unit 144 of the DB server 140 transmits the change information as shown in FIG. 18 to the application server 130, and the change information reception unit 134 and the cache management unit 132 of the application server 130 respond to this change information. And deleting all cache data.
In FIG. 18, CACHE_ALL_CLEAR of the tbl_id tag means deletion of all cache data.
For example, when the DB server 140 detects a failure in the database 141, the change information as shown in FIG. 18 is transmitted to the application server 130, and the application server 130 deletes all the cache data and is stored in the database 141. It is possible to prevent cache data different from the stored data from being stored and to improve the consistency of the cache data.

Embodiment 2. FIG.
FIG. 19 is a configuration diagram of the web search system in the second embodiment.
As shown in FIG. 19, the web search system includes a plurality of WWW servers 120 and a plurality of application servers 130, and further includes a load distribution device 150 that distributes a processing load to each WWW server 120 and each application server 130. Good. Further, the load balancer 150 may be arranged between the WWW server 120 and the application server 130.
By providing the plurality of WWW servers 120, the plurality of application servers 130, and the load distribution apparatus 150, advantages such as distribution of search request processing from the user terminal 100 and shortening of response time can be obtained.

Embodiment 3 FIG.
FIG. 20 is a configuration diagram of the web search system in the third embodiment.
As shown in FIG. 20, the web search system may include a plurality of DB servers 140 and distribute data tables stored in the database 141. Further, the load balancer 150 may be arranged between the application server 130 and the DB server 140.
Since the data table can be distributed and the processing load can be distributed, advantages such as a reduction in response time for processing of a search request from the user terminal 100 can be obtained.

Embodiment 4 FIG.
FIG. 21 is a configuration diagram of the web search system in the fourth embodiment.
As shown in FIG. 21, a plurality of web search systems may be used.
Thereby, even if a failure occurs in one web search system, the search request from the user terminal 100 can be processed by another web search system.

  The web search system is not limited to the configurations of the first to fourth embodiments, and can take various configurations. This provides advantages such as improved system performance.

  Further, the web search system is not limited to a system that performs only a search, but is a system that involves a search.

The block diagram of the WWW multi-tier system in a prior art. FIG. 2 is a diagram illustrating an appearance of each device included in the web search system according to the first embodiment. FIG. 2 is a hardware configuration diagram of each device included in the web search system according to the first embodiment. 1 is a configuration diagram of a web search system according to Embodiment 1. FIG. 4 is a flowchart showing a process flow of an application server 130 according to the first embodiment. FIG. 3 is a diagram illustrating a data format stored and managed by the cache management unit 132 according to the first embodiment. The figure which shows the cache log which the cache management part 132 in Embodiment 1 memorize | stores. The figure which shows the definition sentence of the trigger which stores the information of the data table changed into the management table in Embodiment 1. FIG. FIG. 5 is a diagram showing a table format of a management table in the first embodiment. 3 is a flowchart showing a processing flow of a DB server 140 according to the first embodiment. The figure which shows the memory content of DB property memory | storage part 143 in Embodiment 1. FIG. The figure which shows the change information which DB server 140 in Embodiment 1 transmits to the application server 130. 4 is a flowchart showing a process flow of an application server 130 according to the first embodiment. FIG. 6 is a diagram showing storage information in an AP property storage unit 133 in the first embodiment. FIG. 6 is a diagram showing storage information in an AP property storage unit 133 in the first embodiment. FIG. 6 is a diagram showing storage information in an AP property storage unit 133 in the first embodiment. FIG. 6 is a diagram showing storage information in an AP property storage unit 133 in the first embodiment. The figure which shows the change information which DB server 140 in Embodiment 1 transmits to the application server 130. The block diagram of the web search system in Embodiment 2. FIG. FIG. 6 is a configuration diagram of a web search system in a third embodiment. The block diagram of the web search system in Embodiment 4. FIG.

Explanation of symbols

  100 user terminal, 110 network, 120 WWW server, 130 application server, 131 search result acquisition unit, 132 cache management unit, 133 AP property storage unit, 134 change information reception unit, 140 DB server, 141 database, 142 change detection unit, 143 DB property storage unit, 144 change information transmission unit, 145 search result transmission unit, 150 load distribution device, 901 CRT display device, 902 K / B, 903 mouse, 904 FDD, 905 CDD, 906 printer device, 907 scanner device, 910 system unit, 911 CPU, 912 bus, 913 ROM, 914 RAM, 915 communication board, 920 magnetic disk unit, 921 OS, 922 window system, 923 program Group, 924 file group, 931 telephone, 932 FAX machine, 940 Internet, 941 proxy server, 942 LAN.

Claims (11)

In an application server that acquires search result data corresponding to a search request using a search web page from a database server,
A search result acquisition unit that acquires search result data from a database server based on a page ID (IDentification) for identifying a search web page and search condition data specified in the search web page;
A cache management unit that stores and manages the page ID, the search condition data, and the search result data acquired by the search result acquisition unit;
An AP (application) property storage unit that stores a page ID, search condition data, and a table ID for identifying a table included in a database managed by the database server in association with each other;
The table ID of the changed table is received from the database server, the page ID and search condition data associated with the received table ID are acquired from the AP property storage unit, and the page ID and search acquired from the AP property storage unit An application server comprising: a change information receiving unit that outputs a command signal for deleting search result data associated with condition data to a cache management unit. In the database server that returns search result data to the application server that makes the search request,
A database that stores a data table that holds various data retrieved from the application server, and a management table that holds a table ID (IDentification) for identifying the changed data table;
A change detection unit that detects a change in the data table stored in the database and outputs the table ID of the changed data table to the management table stored in the database;
A DB (database) property storage unit for storing a time interval for monitoring the management table and an application server address indicating the location of the application server;
A change information transmission unit that transmits a table ID indicated by the management table to the application server indicated by the application server address stored in the DB property storage unit for each time interval stored in the DB property storage unit. A database server. In a web search system comprising an application server and a database server and acquiring search result data for a search request using a search web page,
Application server
A search result acquisition unit that acquires search result data from a database server based on a page ID (IDentification) for identifying a search web page and search condition data specified in the search web page;
A cache management unit that stores and manages the page ID, the search condition data, and the search result data acquired by the search result acquisition unit;
An AP (application) property storage unit that stores a page ID and a table ID that identifies a table included in the database managed by the database server in association with each other;
The table ID of the changed table is received from the database server, the page ID and the search condition data associated with the received table ID are acquired from the AP property storage unit, and the page ID acquired from the AP property storage unit A change information receiving unit that outputs a command signal for deleting the search result data associated with the search condition data to the cache management unit;
The database server
A database that stores a data table that holds various data retrieved from the application server, and a management table that holds a table ID for identifying the changed data table;
A change detection unit that detects a change in the data table stored in the database and outputs the table ID of the changed data table to the management table stored in the database;
A DB (database) property storage unit for storing a time interval for monitoring the management table and an application server address indicating the location of the application server;
A change information transmission unit that transmits a table ID indicated by the management table to the application server indicated by the application server address stored in the DB property storage unit for each time interval stored in the DB property storage unit. Web search system. The web search system further includes:
Output page data of search web page, input search condition data input using search web page indicated by output page data, input page ID and input of search web page indicated by output page data And a search server that transmits the search condition data to the application server, receives the search result data from the application server, and outputs page data of the search result web page based on the received search result data. Item 4. The web search system according to Item 3.   The web search system according to claim 3 or 4, comprising a plurality of at least one of the web server, the application server, and the database server.   6. The web search system according to claim 5, further comprising a load balancer for load balancing the processing.   The web search system according to claim 3, comprising a plurality of the web search systems. In the search result acquisition method of the application server that acquires the search result data corresponding to the search request using the search web page from the database server,
A search result acquisition step of acquiring search result data from the database server based on a page ID (IDentification) for identifying the search web page and search condition data specified in the search web page;
A cache management process for storing and managing the page ID, the search condition data, and the search result data acquired in the search result acquisition process;
An AP (application) property storage step for storing a page ID, search condition data, and a table ID for identifying a table included in the database managed by the database server;
The table ID of the changed table is received from the database server, and the page ID and search condition data associated with the received table ID are associated with the page ID and search condition data stored in the AP property storage step. A search result acquisition method comprising: executing a change information receiving step of deleting search result data by a cache management step. In the search result response method of the database server that returns search result data to the application server that makes the search request,
A data storage step for storing a data table for holding various data retrieved from the application server and a management table for holding a table ID (IDentification) for identifying the changed data table;
A change detection unit that detects a change in the data table stored in the data storage step and outputs the table ID of the changed data table to the management table stored in the data storage step;
A DB (database) property storage step for storing a time interval for monitoring the management table and an application server address indicating the location of the application server;
For each time interval stored in the DB property storage step, a change information transmission step of transmitting the table ID indicated by the management table stored in the data storage step to the application server indicated by the application server address stored in the DB property storage step And executing a search result response method.   A search result acquisition program for causing a computer to execute the search result acquisition method according to claim 8.   A search result response program for causing a computer to execute the search result response method according to claim 9.

Images