JP4251699B2 - Database search system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a database search system that realizes a high-speed cache in a network environment.
[0002]
[Prior art]
FIG. 7 is a diagram showing the configuration of a conventional database search system. In the figure, 1 is a client that transmits a service request, and 2 is a service request received from a client 1 via a network 5 using Internet technology. Web server. A database server 3 receives a data transfer request from the Web server 2, searches for the corresponding data from the disk 4 that holds the data, and transfers the data to the Web server 2 via the network 5. In general, the Web server 2 is held by a service provider on the network 5. In FIG. 7, it is assumed that a plurality of clients 1, Web servers 2, and database servers 3 exist on the network 5.
[0003]
Next, the operation will be described.
The client 1 sends a service request to the Web server 2 via the network 5 using a browser. Receiving the service request, the Web server 2 identifies the database server 3 that manages data necessary for realizing the service, and transmits a data transfer request via the network 5.
[0004]
Upon receiving the data transfer request, the database server 3 extracts the corresponding data from the disk 4 that holds the data, and transfers the extracted data to the Web server 2 that requested the request via the network 5. The Web server 2 processes the acquired data if necessary, and provides a service to the client 1 that has made a service request via the network 5.
[0005]
[Problems to be solved by the invention]
Since the conventional database search system is configured as described above, it must be searched through a low-speed interface to the disk 4, and when searching a large amount of data online via the network 5. There was a problem that it could not be searched at high speed.
[0006]
In order to solve the above problems, conventionally, when data retrieved from the disk 4 is stored in a data cache built in the database server 3 and a data transfer request is received from the Web server 2. Uses a method of transferring the corresponding data from the data cache to the Web server 2. However, in the database server 3, the memory constituting the data cache is mounted on a different LSI from the CPU in the database server 3, and in order to increase the speed, the data width between the CPU and the memory, that is, The bus width needs to be increased. As a result, the crosstalk increases with an increase in the bus length between the memory and the CPU, and it is necessary to lower the clock frequency of the CPU as a countermeasure. As a result, the processing is slowed and the speed is increased. There was a problem of difficulty.
[0007]
The present invention has been made to solve the above-described problems, and an object of the present invention is to provide a database search system that realizes a high-speed cache in a network environment and can search a database on the network 5 at high speed.
[0008]
[Means for Solving the Problems]
The database search system according to the present invention receives a service request from a client via a network, acquires necessary data and provides a service from the client, and sends a data transfer request from the Web server. And a database server that retrieves data from a stored database and transfers the data to the Web server, wherein the Web server stores the data transferred from the database server, and the data object If the data reference necessary to realize the service request is stored in the data object, the database reference that correlates the data stored in the database server and the data held by the database server, the data object If the data required for realizing the service request is not stored in the data object, the database server is referred to by referring to the database reference. A request processing unit for requesting transfer of necessary data, obtaining the necessary data, and providing the requested service to the client. The database server stores the data retrieved from the database. Data cache, data stored in the database, object reference that correlates data stored in the data cache and data stored in the data object, and necessary data from the request processing unit Upon receiving a transfer request, the above object When the necessary data is stored in the data cache, the data is acquired from the data cache and transferred to the request processing unit, and the necessary data is not stored in the data cache. A database management unit that obtains data from the database and stores the data in the data cache, and updates the object reference . The request processing unit, the data object, and the data reference in a Web server are stored in one chip. It is integrated in the system LSI .
[0013]
The database search system according to the present invention receives a service request from a client via a network, acquires necessary data and provides a service from the client, and sends a data transfer request from the Web server. In the database search system comprising: a database server that retrieves data from a stored database and transfers the data to the Web server, the Web server stores data transferred from the database server; and When the database reference that correlates the data stored in the data object and the data held by the database server and the data object stores data necessary to realize the service request, the data Data is obtained from the data object, the requested service is provided to the client, and if the data object does not contain the data necessary for realizing the service request, refer to the database reference, and A request processing unit that requests the database server to transfer necessary data, obtains the necessary data, and then provides the requested service to the client, and the database server retrieves the data retrieved from the database. A data cache that stores data, an object reference that correlates data stored in the database, data stored in the data cache, and data stored in the data object, and a request from the request processing unit Received a request for data transfer When the necessary data is stored in the data cache with reference to the object reference, the data is acquired from the data cache and transferred to the request processing unit, and the necessary data is stored in the data cache. A database management unit that obtains data from the database and stores the data in the data cache and updates the object reference, the database management unit in the database server, the database, the data cache, and the object A database management unit, a database, a data cache, and an object reference in a database server in which a reference is integrated in a one-chip system LSI are integrated in a one-chip system LSI. .
[0014]
DETAILED DESCRIPTION OF THE INVENTION
An embodiment of the present invention will be described below.
Embodiment 1 FIG.
FIG. 1 is a diagram showing a configuration of a database search system according to the first embodiment. In the figure, a client 1 and a network 5 are the same as the conventional configuration of FIG. A Web server 20 receives a service request from the client 1 via the network 5 and provides a service to the client 1. Reference numeral 30 denotes a database server, which receives a data transfer request from the Web server 20, searches for stored data, and transfers the data to the Web server 20 via the network 5.
[0015]
Further, in the Web server 20 of FIG. 1, reference numeral 21 denotes a request processing unit which receives a service request from the client 1 and, if necessary, receives data transfer from the database server 30 to provide the client 1 with a service. To do. The function of the request processing unit 21 is realized by a CPU and application software not shown. A data object 22 transferred from the database server 30 is stored in a RAM or the like.
[0016]
Further, in the Web server 20 of FIG. 1, reference numeral 23 denotes a database reference that associates the data object 22 with data held by the database server 30, and is stored in a RAM or the like.
[0017]
Further, in the Web server 20 of FIG. 1, the request processing unit 21, the data object 22, and the database reference 23 are integrated in a one-chip Web server chip 200 as a system LSI.
[0018]
Further, in the database server 30 of FIG. 1, reference numeral 31 denotes a database management unit, which receives a data transfer request from the request processing unit 21 of the Web server 20 and acquires and transfers the corresponding data. The functions of the database management unit 31 are realized by a CPU (not shown) and software such as a database management system. Reference numeral 32 denotes a database in which data for providing a service is stored in a large-capacity RAM exceeding 1 gigabyte. The data stored in the conventional disk 4 in FIG. 7 is stored in this database 32.
[0019]
Further, in the database server 30 of FIG. 1, reference numeral 33 denotes a data cache, which stores data acquired from the database 32 in response to a transfer request from the Web server 20. Reference numeral 34 denotes an object reference stored in a RAM or the like, which correlates the database 32, the data cache 33, and the data object 22 held by the Web server 20.
[0020]
Further, in the database server 30 of FIG. 1, a database management unit 31, a database 32, a data cache 33, and an object reference 34 are integrated as a system LSI in a one-chip database server chip 300.
[0021]
FIG. 2 is a diagram showing information held in the database reference 23. In the figure, reference numeral 231 denotes an index of data held by the database 32, and reference numeral 232 denotes URL (Universal Resource Locator) information of the database server holding the data, which is on the network 5 for accessing the requested data. The IP (Internet Protocol) address of the database server 30 in FIG. Here, the URL is a standard that defines means for accessing various information resources (database) on the network 5 and a method for specifying the name of the resource.
[0022]
In FIG. 2, reference numeral 233 denotes reference information to the data object 22, which indicates the address of the data object 22 in which data is stored. The database reference 23 holds each piece of information shown in FIG. 2 in a list format.
[0023]
FIG. 3 is a diagram showing information held by the object reference 34. In the figure, reference numeral 341 denotes reference information to the database 32, and an index of data in the database 32 is shown. Reference numeral 342 denotes reference information to the data cache 33, which indicates an address where data in the data cache 33 is stored. Reference numeral 343 denotes URL information of the Web server 20, which indicates the IP address of the Web server 20 on the network 5. The object reference 34 holds each piece of information shown in FIG. 3 in a list format.
[0024]
Next, the operation will be described.
4 and 5 are flowcharts showing database search processing. In step ST <b> 11 of FIG. 4, the request processing unit 21 of the Web server 20 receives a service request from the client 1. In step ST12, the request processing unit 21 refers to the database reference 23. In step ST13, the request processing unit 21 determines whether data for realizing a service request from the client 1 exists in the data object 22.
[0025]
In step ST13, when the data object 22 includes data for realizing a service request from the client 1, the request processing unit 21 acquires the corresponding data from the data object 22 in step ST14. In step ST15, the request processing unit 21 confirms whether more data is necessary to realize the service request from the client 1. If necessary, the request processing unit 21 returns to step ST12 and performs the processing after step ST12. Do. If no further data is required in step ST15, in step ST16, the request processing unit 21 provides the requested service to the client 1 via the network 5 using the acquired data.
[0026]
In step ST13, when the data object 22 does not contain data for realizing the service request from the client 1, in step ST17, the request processing unit 21 refers to the database reference 23 and holds the data. The database server 30 is requested to transfer necessary data.
[0027]
In step ST <b> 18 of FIG. 5, the database management unit 31 of the database server 30 receives the data transfer request from the request processing unit 21. In step ST19, the database management unit 31 refers to the object reference 34 from the index of the data for which the transfer request has been received, and confirms whether necessary data is stored in the data cache 33.
[0028]
If necessary data is stored in the data cache 33 in step ST19, the database management unit 31 acquires necessary data from the data cache 33 in step ST20.
[0029]
In step ST <b> 21, the database management unit 31 transfers the acquired data to the request processing unit 21 of the Web server 20. In step ST22, the request processing unit 21 stores the transferred data in the data object 22, and performs the processes after step ST14 in FIG.
[0030]
If the necessary data is not stored in the data cache 33 in step ST19, the database management unit 31 acquires necessary data from the database 32 in step ST23. In step ST24, the database management unit 31 stores the acquired data in the data cache 33. In step ST25, the database management unit 31 updates the object reference 34. That is, corresponding to the acquired data index 341, the cache address 342 storing the data and the IP address 343 of the Web server 20 that requested it are added.
[0031]
After the update processing of the object reference 34 in step ST25, the processing after step 20 is performed.
[0032]
FIG. 6 is a flowchart showing the update process of the database 32. In step ST31, when the database management unit 31 of the database server 30 receives an update request for the database 32 from the operator, the database management unit 31 locks data to be updated in the database 32 in step ST32.
[0033]
In step ST33, the database management unit 31 confirms whether the reference (index) of the update target data exists in the object reference 34. If the reference (index) of the update target data does not exist, in step ST34, The database management unit 31 updates the data in the database 32 and releases the lock.
[0034]
In step ST33, if there is a reference (index) of the data to be updated, in step ST35, the database management unit 31 locks the data to be updated in the data cache 33 and issues an update request for the database 32 from the operator. , Notify the Web server 20. In step ST36, the request processing unit 21 of the Web server 20 locks the data to be updated of the data object 22.
[0035]
In step ST37, the database management unit 31 of the database server 30 updates the data in the database 32 to release the lock. In step ST38, the database management unit 31 updates the data in the data cache 33 to release the lock. . In step ST39, the request processing unit 21 of the Web server 20 updates the data of the data object 22 and releases the lock.
[0036]
As described above, according to the first embodiment, the Web server 20 includes the data object 22 having a cache function, and the database reference 23 and the object reference 34 correlate the data held by the Web server 20 and the database server 30. As a result, it is possible to realize a high-speed cache in a network environment and to search a database on the network 5 at a high speed.
[0037]
In the Web server 20, the request processing unit 21, the data object 22, and the database reference 23 are integrated as a system LSI in the one-chip Web server chip 200, and the database server 30 has a database management unit. 31, the database 32, the data cache 33, and the object reference 34 are integrated as a system LSI in the one-chip database chip 300, so that the memory constituting the data cache is stored in the database as in the conventional case. The wiring between the memory and the CPU can be shortened as compared to the case where the CPU in the server 3 is mounted on a different LSI, that is, the request processing unit 21, the data object 22, and the database reference 23 in FIG. while In addition, the wiring between the database management unit 31 and the database 32, the data cache 33, and the object reference 34 can be shortened, crosstalk can be reduced, and the CPU clock for realizing the request processing unit 21 and the database management unit 31 can be reduced. There is no need to lower the frequency, and the effect of being able to perform high-speed processing is obtained.
[0038]
【The invention's effect】
As described above, according to the present invention, the Web server is provided with the data object for storing the data transferred from the database server, and the data held by the Web server and the database server is correlated by the database reference and the object reference. As a result, a high-speed cache is realized in the network environment, and the database can be searched at high speed on the network.
[0039]
According to the present invention, by integrating a request processing unit, a data object, and a data reference in a Web server in a one-chip system LSI, wiring can be shortened and crosstalk can be reduced. There is no need to lower the clock frequency of the CPU that realizes the unit 21, and there is an effect that high-speed processing can be performed.
[0040]
According to the present invention, by integrating the database management unit, database, data cache, and object reference in the database server in a one-chip system LSI, wiring can be shortened and crosstalk can be reduced. There is no need to lower the clock frequency of the CPU that implements the database management unit 31, and there is an effect that high-speed processing can be performed.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration of a database search system according to Embodiment 1 of the present invention.
FIG. 2 is a diagram showing information held in a database reference according to the first embodiment of the present invention.
FIG. 3 is a diagram showing information held by an object reference according to the first embodiment of the present invention.
FIG. 4 is a flowchart showing database search processing according to Embodiment 1 of the present invention;
FIG. 5 is a flowchart showing database search processing according to Embodiment 1 of the present invention;
FIG. 6 is a flowchart showing database update processing according to Embodiment 1 of the present invention;
FIG. 7 is a diagram showing a configuration of a conventional database search system.
[Explanation of symbols]
1 client, 5 network, 20 web server, 21 request processing unit, 22 data object, 23 database reference, 30 database server, 31 database management unit, 32 database, 33 data cache, 34 object reference.

Claims (2)

A web server that receives a service request from a client via a network, obtains necessary data, and provides a service from the client;
In a database search system comprising: a database server that receives a data transfer request from the Web server, searches data stored in the database, and transfers the data to the Web server;
The web server is
A data object for storing data transferred from the database server;
A database reference that correlates the data stored in the data object and the data held by the database server;
If the data object stores data necessary to realize the service request, the data object is obtained from the data object, the requested service is provided to the client, and the service request is sent to the data object. If the data required for implementation is not stored, refer to the database reference, request the database server to transfer the necessary data, acquire the necessary data, and then request the client. And a request processing unit for providing
The database server is
A data cache for storing data retrieved from the database;
An object reference that correlates the data held in the database, the data stored in the data cache, and the data stored in the data object;
When the required data transfer request is received from the request processing unit, and the necessary data is stored in the data cache with reference to the object reference, the data is acquired from the data cache and the request processing unit And when the necessary data is not stored in the data cache, the database management unit obtains data from the database and stores the data in the data cache, and updates the object reference .
A database search system, wherein the request processing unit, the data object, and the data reference in a Web server are integrated in a one-chip system LSI . A web server that receives a service request from a client via a network, obtains necessary data, and provides a service from the client;
A database server that receives a data transfer request from the Web server, retrieves data from a database held by the Web server, and transfers the data to the Web server;
In a database search system equipped with
The web server is
A data object for storing data transferred from the database server;
A database reference that correlates the data stored in the data object and the data held by the database server;
If the data object stores data necessary to realize the service request, the data object is obtained from the data object, the requested service is provided to the client, and the service request is sent to the data object. If the data required for implementation is not stored, refer to the database reference, request the database server to transfer the necessary data, acquire the necessary data, and then request the client. A request processing unit that provides
With
The database server is
A data cache for storing data retrieved from the database;
And object reference correlating the data stored in the data and the data object stored in the data and the data cache that is held in the database,
When the required data transfer request is received from the request processing unit, and the necessary data is stored in the data cache with reference to the object reference, the data is acquired from the data cache and the request processing unit And when the necessary data is not stored in the data cache, the database management unit obtains data from the database and stores the data in the data cache, and updates the object reference.
The database management unit in the database server, the database, the data cache, the object reference, 1 database search system that is characterized in that integrated in the chip system LSI of.

Images