JP2000222272A - Data base retrieval system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data base retrieval system capable of retrieving a data base on a network at high speed. SOLUTION: A request processing part 21 of a Web server 20, which receives a service request from a client 1, retrieves a data object 22 and when there are data, they are sent to the client 1 however when there is no data, while referring to a data base reference 23, the transfer of data is requested to a data base managing part 31. The data base managing part 31 acquires data from a data cache 33 while referring to an object reference 34 and when there is no data, data are acquired from a data base 32 and transferred to the Web server 20.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a database search system for realizing a high-speed cache in a network environment.

[0002]

2. Description of the Related Art FIG. 7 is a diagram showing the configuration of a conventional database search system. In the figure, reference numeral 1 denotes a client that sends a service request, and 2 denotes a client from a client 1 via a network 5 using the Internet technology. A Web server that receives a service request. Reference numeral 3 denotes a database server which receives a data transfer request from the Web server 2, searches the disk 4 holding the data for relevant data,
Transfer to e-server 2. Generally, Web server 2
Is held by a service provider on the network 5. 7, a plurality of clients 1, a Web server 2, and a database server 3 exist on the network 5.

Next, the operation will be described. The client 1 uses the browser to connect to the Web 5 via the network 5.
A service request is sent to the server b. The Web server 2 that has received the service request specifies the database server 3 that manages data necessary to realize the service, and sends a data transfer request via the network 5.

[0004] Upon receiving the data transfer request, the database server 3 extracts the relevant data from the disk 4 holding the data, and sends the data to the requesting Web server 2.
The extracted data is transferred via the network 5.
The Web server 2 processes the acquired data if necessary, and provides a service to the client 1 that has requested the service via the network 5.

[0005]

Since the conventional database search system is configured as described above, the search must be performed through a low-speed interface to the disk 4, and a large amount of data must be searched through the network 5. When searching data online, there was a problem that high-speed search was not possible.

[0006] In order to solve the above problems,
Conventionally, data retrieved from the disk 4 is stored in a data cache incorporated in the database server 3, and when a data transfer request is received from the Web server 2, the corresponding data is transferred from the data cache to the Web server. 2 is used. However, in the database server 3, the memory constituting the data cache is stored in the C in the database server 3.
Since it is mounted on a separate LSI from the PU, it is necessary to increase the data width between the CPU and the memory, that is, the bus width in order to increase the speed. Then, the crosstalk increases in conjunction with the increase in the bus length between the memory and the CPU, and it is necessary to lower the clock frequency of the CPU in order to take countermeasures. As a result, the processing becomes slower and the speed is increased. There was a problem of difficulty.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-described problems, and has as its object to realize a high-speed cache in a network environment and to obtain a database search system capable of searching a database on the network 5 at high speed. .

[0008]

A 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, In response to a data transfer request from the Web server, data is retrieved from a database held by the
a data object for storing data transferred from the database server, data stored in the data object, and data held by the database server. If the data required to realize the service request is stored in the data object, the data is obtained from the data object to provide the requested service to the client. If the data required to implement the service request is not stored in the data object, the database server refers to the database reference, requests the database server to transfer necessary data, and acquires the required data. Teka A request processing unit that provides a service requested by the client, wherein the database server stores data retrieved from a database, and data stored in the database and stored in the data cache. An object reference for correlating the data stored in the data object with the data stored in the data object and a request for necessary data transfer from the request processing unit are received. If such data is stored, the data is obtained from the data cache and transferred to the request processing unit,
When necessary data is not stored in the data cache, the data cache is provided with a database management unit that acquires data from the database, stores the data in the data cache, and updates the object reference.

[0009] In the database search system according to the present invention, the database reference is based on the index of the data stored in the database, the IP address of the database server on the network, and the address of the data object storing the data. The correlation with the data held by the database server is obtained.

[0010] In the database search system according to the present invention, the object reference is based on the index of the data stored in the database, the address of the data cache storing the data, and the IP address of the Web server on the network. The correlation with the data held by the Web server is taken.

In the database search system according to the present invention, when updating data stored in the database, the database management unit locks the data to be updated in the database, and the object reference contains the reference to the data to be updated. If not, the database management unit updates the data to be updated in the database, and then releases the lock.If the reference to the data to be updated exists in the object reference, the database management unit updates the data cache. Lock the target data and notify the request processing unit to lock the data to be updated of the data object, update the data in the database, release the lock, and update the data in the data cache. Then unlock And notifies to the request processing unit, is intended to release the lock by updating the data of the data object.

[0012] In the database search system according to the present invention, a request processing unit, a data object, and a data reference in a Web server are stored in a one-chip system
I.

[0013] A database search system according to the present invention includes a database management unit in a database server;
The database, data cache, and object reference are integrated on a one-chip system LSI.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below. Embodiment 1 FIG. FIG. 1 is a diagram showing a configuration of the database search system according to the first embodiment. In the figure, a client 1 and a network 5 have the same configuration 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 retained data,
The data is transferred to the Web server 20 via the network 5.

In the Web server 20 shown in FIG.
Reference numeral 21 denotes a request processing unit which receives a service request from the client 1 and, if necessary,
In response to the transfer of data from 0, a service is provided to the client 1. The function of the request processing unit 21 is realized by a CPU (not shown) and application software. Reference numeral 22 denotes a data object transferred from the database server 30, which is stored in a RAM or the like.

Further, in the Web server 20 shown in FIG. 1, reference numeral 23 denotes a database reference which associates the data object 22 with data held by the database server 30, and is stored in a RAM or the like.

Further, in the Web server 20 shown in FIG. 1, the request processing unit 21, the data object 22, and the database reference 23 include one as a system LSI.
The chip is integrated in the Web server chip 200.

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, acquires and transfers the corresponding data. The function of the database management unit 31 is 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 or the like. The data stored on the disk 4 in FIG. 7 of the related art is stored in the database 32.

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.

Further, in the database server 30 of FIG. 1, a database management unit 31, a database 32,
Data cache 33, object reference 34
Are integrated in a one-chip database server chip 300 as a system LSI.

FIG. 2 is a diagram showing information held by the database reference 23. In the figure, 231 is an index of data held by the database 32,
232 is the URL (Universal Resource L) of the database server holding the data.
octor) information, and the IP (Internet Protocol) of the database server 30 on the network 5 for accessing the requested data.
l) The address is shown. Here, the URL is a standard that defines a means for accessing various information resources (databases) on the network 5 and a method for specifying a resource name.

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 the information shown in FIG. 2 in a list format.

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 indicates an index of data in the database 32. Reference numeral 342 is reference information to the data cache 33, and indicates an address where data in the data cache 33 is stored. Reference numeral 343 denotes URL information of the Web server 20,
The IP address of the Web server 20 on the network 5 is shown. The object reference 34 is shown in FIG.
Each of the information shown in Table 1 is held in the form of a list.

Next, the operation will be described. 4 and 5
9 is a flowchart showing a database search process. In step ST11 of FIG. 4, the Web server 2
The 0 request processing unit 21 receives the service request from the client 1. In step ST12, the request processing unit 21 refers to the database reference 23, and 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.

In step ST13, if data for realizing a service request from the client 1 exists in the data object 22, the process proceeds to step ST13.
At 14, the request processing unit 21 sets the data object 2
2. Obtain the corresponding data from 2. In step ST15, the request processing unit 21 confirms whether or not further data is necessary to realize the service request from the client 1, and if necessary, returns to step ST12.
The processing after step ST12 is performed. Step ST above
In step ST16, if no further data is needed, the request processing unit 21 sends the client 1
To provide the requested service.

In step ST13, if there is no data in the data object 22 for realizing the service request from the client 1, the process proceeds to step S13.
At T17, the request processing unit 21 refers to the database reference 23, acquires the IP address of the database server 30 holding the data, and requests the database server 30 to transfer necessary data.

In step ST 18 of FIG. 5, the database management section 31 of the database server 30 receives a data transfer request from the request processing section 21. Step S
At T19, the database management unit 31 refers to the object reference 34 from the index of the data requested to be transferred, and checks whether necessary data is stored in the data cache 33.

If necessary data is stored in the data cache 33 in step ST19, in step ST20, the database management unit 31
The necessary data is acquired from the data cache 33.

In step ST21, the database management section 31 transfers the obtained data to the request processing section 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 processing after step ST14 in FIG.

In step ST19, when the necessary data is not stored in the data cache 33,
In step ST23, the database management unit 31
Acquires necessary data from the database 32. In step ST24, the database management unit 31
The acquired data is stored in the data cache 33, and in step ST25, the database management unit 31 updates the object reference 34. That is, in correspondence with the index 341 of the acquired data, the cache address 342 storing the data and the IP address 343 of the requested Web server 20 are added.

After the update processing of the object reference 34 in step ST25, the processing after step 20 is performed.

FIG. 6 is a flowchart showing the updating process of the database 32. In step ST31, when the database management unit 31 of the database server 30 receives a request for updating the database 32 from the operator,
In step ST32, the database management unit 31
Locks data to be updated in the database 32.

In step ST33, the database management section 31 checks whether or not the reference (index) of the data to be updated exists in the object reference 34. If the reference (index) of the data to be updated does not exist, the process proceeds to step ST33. In ST34, the database management unit 31 updates the data in the database 32 and releases the lock.

If there is a reference (index) of the data to be updated in step ST33, the process proceeds to step ST35.
1 locks data to be updated in the data cache 33 and notifies the Web server 20 of an update request of the database 32 from the operator. In step ST36, the request processing unit 21 of the Web server 20 locks the data to be updated of the data object 22.

In step ST37, the database management unit 31 of the database server 30 updates the data in the database 32 to release the lock, and then proceeds to step ST37.
At 38, the database management unit 31 updates the data in the data cache 33 and releases 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.

As described above, according to the first embodiment, the Web server 20 includes the data object 22 having the cache function, and the database reference 23
By correlating the data held by the Web server 20 and the database server 30 with the object reference 34, a high-speed cache can be realized in a network environment, and an effect that a database can be searched on the network 5 at a high speed can be obtained.

In the Web server 20, the request processing unit 21, the data object 22, and the database reference 23 correspond to one chip W
integrated in the eb server chip 200, and
In the database server 30, the database management unit 31, the database 32, the data cache 33, and the object reference 34 are used as system LSIs.
By being integrated in the one-chip database chip 300, the memory constituting the data cache is replaced with the CPU in the database server 3 as in the related art.
Memory and C compared to being implemented on another LSI
The wiring between PUs can be shortened, that is, FIG.
In this case, the wiring between the request processing unit 21 and the data object 22 and the database reference 23 and the wiring between the database management unit 31 and the database 32, the data cache 33 and the object reference 34 can be shortened, and crosstalk can be reduced. There is no need to lower the clock frequency of the CPU that implements the request processing unit 21 and the database management unit 31, and the effect that high-speed processing can be performed is obtained.

[0038]

As described above, according to the present invention, the We
The b server includes a data object for storing data transferred from the database server, and realizes a high-speed cache in a network environment by correlating the data held by the Web server and the database server with the database reference and the object reference. There is an effect that a database can be searched at high speed on a network.

According to the present invention, the request processing unit, data object, and data reference in the Web server are integrated in a one-chip system LSI,
The wiring can be shortened, the crosstalk can be reduced, and there is no need to lower the clock frequency of the CPU that implements the request processing unit 21, and there is an effect that high-speed processing can be performed.

According to the present invention, by integrating the database management unit, the database, the data cache, and the object reference in the database server in a one-chip system LSI, the wiring can be shortened, and the crosstalk can be reduced. Therefore, 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 a first embodiment of the present invention.

FIG. 2 is a diagram showing information held by 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 a database search process according to the first embodiment of the present invention.

FIG. 5 is a flowchart showing a database search process according to the first embodiment of the present invention.

FIG. 6 is a flowchart showing a database update process according to the first embodiment of the present invention.

FIG. 7 is a diagram showing a configuration of a conventional database search system.

[Explanation of symbols]

1 client, 5 networks, 20 Web servers, 21 request processing unit, 22 data objects,
23 database reference, 30 database server, 31 database management unit, 32 database, 33 data cache, 34 object reference.

Claims (6)

[Claims] 1. A web server that receives a service request from a client via a network, acquires necessary data and provides a service from the client, and receives a data transfer request from the web server and holds the data. A database object for retrieving data from a database to be transferred and transferring the data to the web server, wherein the web server stores data transferred from the database server and stores the data in the data object A database reference for correlating the obtained data with the data held by the database server, and, if the data necessary for realizing the service request is stored in the data object, the data from the data object. Obtain and provide the requested service to the client, and if the data object does not store the data required to fulfill the service request, refer to the database reference and A request processing unit for requesting data transfer, obtaining the required data, and then providing the requested service to the client, wherein the database server stores data retrieved from a database. And an object reference for correlating the data held in the database, the data stored in the data cache, and the data stored in the data object, and a request for a necessary data transfer from the request processing unit. Receiving
If necessary data is stored in the data cache with reference to the object reference, data is obtained from the data cache and transferred to the request processing unit, and the required data is stored in the data cache. If not, a database management unit that acquires a data from the database, stores the data in the data cache, and updates the object reference. 2. A method according to claim 1, wherein the database reference is based on an index of data stored in the database, an IP address of the database server on the network, and an address of a data object storing the data. 2. The database retrieval system according to claim 1, wherein the database retrieval system is correlated with. 3. An object reference includes an index of data stored in a database, an address of a data cache storing data, and a Web reference.
2. The database search system according to claim 1, wherein a correlation with data held by the Web server is made based on an IP address on a network of the server. 4. When updating data stored in a database, the database management unit locks data to be updated in the database, and when there is no reference to the data to be updated in the object reference, the database management unit But,
Update the data to be updated in the database and then release the lock.If there is a reference to the data to be updated in the object reference, the database management unit locks the data to be updated in the data cache, and Notify the request processing unit to lock the data to be updated of the data object, update the data in the database and release the lock, update the data in the data cache and release the lock, 2. The database search system according to claim 1, wherein the processing unit is notified to update the data of the data object and release the lock. 5. The database search system according to claim 1, wherein a request processing unit, a data object, and a data reference in the Web server are integrated in a one-chip system LSI. 6. The database search system according to claim 1, wherein a database management unit, a database, a data cache, and an object reference in the database server are integrated in a one-chip system LSI.