Method and apparatus for caching multiple Java-database connectivity

• US 20030120638A1
• Filed: 05/20/2002
• Published: 06/26/2003
• Est. Priority Date: 12/24/2001
• Status: Abandoned Application

• Current Assignee: Electronics and Telecommunications Research Institute
• Original Assignee: Electronics and Telecommunications Research Institute
• Inventors: Lee, Kyoung Ho, Park, Joong Ki, Kim, Joong Bae
• Application Number:
  US10/147,804
• Publication Number:
  US 20030120638A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A system and method of caching multiple Java-database connectivity is disclosed. A cache manager for cache management is provided between an intermediate server and a database server in the multi-layer Java-database connectivity system having the intermediate server. If the intermediate server provides a query statement for accessing a database, the caching of the intermediate server is operated in a different manner according to the kind of the query statement. Thus, a response time of the system can be reduced from the viewpoint of a user, and the load of the network can be reduced through reduction of the network traffic from the viewpoint of a network. Also, the load of the database server for service requests can be reduced, and a database management system can process more requests from users.

Claims

1. A method of caching multiple Java-database connectivity in a cache management method for a multi-layer Java-database connectivity unification system having a Java-database connectivity driver and a database server, the method comprising the steps of:

if a database query statement is received from the Java-database connectivity driver, judging a kind of the query statement by analyzing the received query statement; and

a) if data corresponding to the query statement exists in a cache as a result of judging the kind of the query statement, transferring the corresponding data to the Java-database connectivity driver, while b) if the data corresponding to the query statement does not exist in the cache, requesting the corresponding data to the database server and providing the data to the Java-database connectivity driver.

2. The method as claimed in claim 1, wherein the step of providing the data to the Java-database connectivity driver comprises the steps of:

if the kind of the query statement is a data change statement, judging whether the data corresponding to the data change statement exists in the cache; and

a) if the data corresponding to the data change statement exists in the cache as a result of judgment, setting the corresponding data to be in a “

changed”

state, and then transferring the data change statement to the database server to change the corresponding data, while b) if the data corresponding to the data change statement does not exist in the cache, transferring the data change statement directly to the database server to change the corresponding data.

3. The method as claimed in claim 1, wherein the step of providing the data to the Java-database connectivity driver comprises the steps of:

if the kind of the query statement is a data search statement, judging whether a search result data corresponding to the data search statement exists in the cache and the corresponding data is in an “

updated’

state; and

if the search result data corresponding to the data search statement exists in the cache and the corresponding data is in the “

updated”

state as a result of judgment, transferring the corresponding data existing in the cache to the Java-database connectivity driver.

4. The method as claimed in claim 3, wherein the step of providing the data to the Java-database connectivity driver further comprises the steps of:

if the search result data corresponding to the data search statement exists in the cache and the corresponding data is not in the “

updated’

state as a result of judgment, transferring the corresponding data search statement to the database server; and

a) if the search result data corresponding to the data search statement is received from the database server, providing the received search result data to the Java-database connectivity driver, and b) adding the data search statement to a cache query statement list, and adding the search result data to an attribute list.

5. The method as claimed in claim 1, wherein the step of judging the kind of the query statement by analyzing the received query statement comprises the steps of:

if the query statement is not received, judging whether the data in the “

changed”

state exists among cache data; and

if the data in the “

changed”

state exists among the cache data as a result of judgment, receiving resultant data of query statement process from the database server, storing the resultant data in the cache, and setting the data to be in an “

updated”

state.

6. A system for caching multiple Java-database connectivity in a cache management apparatus of a multi-layer Java-database connectivity unification system having a Java-database connectivity driver and a database server, the system comprising:

a cache storage section for storing a plurality of cache data and information; and

a cache management section for a) if a database query statement is received from the Java-database connectivity driver, judging a kind of the query statement by analyzing the received query statement, and if data corresponding to the query statement exists in the cache storage section according to the kind of the query statement, transferring the corresponding data to the Java-database connectivity driver, while b) if the data corresponding to the query statement does not exist in the cache storage section, requesting the corresponding data to the database server and providing the data to the Java-database connectivity driver.

7. The system as claimed in claim 6, wherein the plurality of cache data and information stored in the cache storage section includes at least one of cache query statement list data information corresponding to the data currently stored, resultant data of the query statement existing in the cache query statement list, and status information of the resultant data of the query statement.

8. The system as claimed in claim 6, wherein if the kind of the query statement is a data change statement, the cache management section

a) judges whether the data corresponding to the data change statement exists in the cache;

b) if the data corresponding to the change statement exists in the cache as a result of judgment, sets the corresponding data to be in a “

changed”

state, and then transfers the data change statement to the database server to change the corresponding data; and

c) if the data corresponding to the data change statement does not exist in the cache, transfers the data change statement directly to the database server to change the corresponding data.

9. The system as claimed in claim 6, wherein if the kind of the query statement is a data search statement, the cache management section

a) judges whether search result data corresponding to the data search statement exists in the cache and the corresponding data is in an “

updated”

state; and

b) if the search result data corresponding to the data search statement exists in the cache and the corresponding data is in the “

updated’

state as a result of judgment, transfers the corresponding data existing in the cache to the Java-database connectivity driver.

10. The system as claimed in claim 9, wherein if the search result data corresponding to the data search statement exists in the cache and the corresponding data is not in the “

updated”

state as a result of judgment, the cache management section

a) transfers the corresponding search statement to the database server, and if the search result data is received from the database server as a result of search, provides the received search result data to the Java-database connectivity driver; and

b) additionally stores the search statement and the search result data in the cache storage section.

11. A recording medium that implements by types a program of commands executable by a digital processing apparatus to perform a cache management method in a multi-layer Java-database connectivity unification system having a Java-database connectivity driver and a database server, and that is readable by the digital processing apparatus, the recording medium performing the steps of:

if a database query statement is received from the Java-database connectivity driver, judging a kind of the query statement by analyzing the received query statement;

a) if the kind of the query statement is a data change statement and data changed according to the data change statement is stored in a cache, setting the corresponding data to be in a “

changed”

state, and b) if the changed data does not exist in the cache, transferring the data change statement to the database server so that the database server changes the data according to the data change statement; and

a) if the kind of the query statement is a data search statement, and if the data to be searched according to the data search statement exists in the cache and the data is in an “

updated”

state, transferring the data to the Java-database connectivity driver, and b) if the data to be searched exists in the cache and the data is not in the “

updated’

state, transferring the search statement to the database server to have the database server process the data search statement, checking if it is necessary to store a search result in the cache, and adding the searched data in the cache.