Application server, cache program, and application server system

• US 7,711,720 B2
• Filed: 01/30/2004
• Issued: 05/04/2010
• Est. Priority Date: 03/27/2003
• Status: Active Grant

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Suzuki, Takamune
• Primary Examiner(s): Cottingham; John R.
• Assistant Examiner(s): TIMBLIN, ROBERT M
• Application Number:
  US10/766,839
• Publication Number:
  US 20040193574A1
• Time in Patent Office: 2,286 Days
• Field of Search: None
• US Class Current: 707/700
• CPC Class Codes: G06F 16/24552 Database cache management

Abstract

An application server includes a cache memory that stores in a correlated form a retrieval condition and a retrieval result, an update condition setting unit that sets a cache update condition that indicates when the cache memory is to be updated; and an update processing unit that reads the retrieval condition from the cache memory upon fulfillment of the cache update condition, retrieves data as the retrieval result from the database using the retrieval condition, and updates the retrieval result in the cache memory corresponding to the retrieval condition.

Claims

1. An application server that retrieves data from a database management system using a retrieval condition received from a terminal and transmits the data retrieved as a retrieval result to the terminal, comprising:

a cache memory that stores in a correlated form the retrieval condition and the retrieval result;

an update condition setting unit that sets a cache update condition that indicates when the cache memory is to be updated;

an update processing unit that determines whether to transmit an update request to update the retrieval result based on the cache update condition; and

a main controlling unit that sends, to the database management system, a retrieval expression which is produced based on the retrieval condition received from a client terminal or read from the cache memory, based on the update request received from the update processing unit, and receives the retrieval result of a database from the database management system and stores the retrieval condition and the retrieval result in the correlated form in the cache memory,

wherein the update condition setting unit acquires a number of data records updated within a predetermined period from the database, and determines whether the number of data records updated is in a fixed range of the data records and, if the number of data records updated is not in the fixed range, the update condition setting unit sets the cache update condition such that the number of data records updated falls in the fixed range.

2. The application server according to claim 1, wherein, when searching the database, the update processing unit acquires a database update condition that indicates when the database is updated and the update condition setting unit sets the cache update condition based on the database update condition acquired.

3. The application server according to claim 1, wherein a user sets the cache update condition.

4. The application server according to claim 1, wherein the update processing unit sets next and subsequent cache update conditions using a date and a time of the retrieval result updated.

5. An application server system comprising:

a plurality of application servers, each of which retrieves data from a database management system using a retrieval condition, received from a terminal and transmits the data retrieved as a retrieval result to the terminal, each application server including

a cache memory that stores in a correlated form the retrieval condition and the retrieval result;

an update condition setting unit that sets a cache update condition that indicates when the cache memory is to be updated;

an update processing unit that determines whether to transmit an update request based on the cache update condition; and

a main controlling unit that sends, to the database management system, a retrieval expression which is produced based on the retrieval condition received from a client terminal or read from the cache memory, based on the update request received from the update processing unit, and receives the retrieval result of a database from the database management system and stores the retrieval condition and the retrieval result in the correlated form in the cache memory, wherein

the update condition setting unit acquires a number of data records updated within a predetermined period from the database, and determines whether the number of data records updated is in a fixed range of the data records and, if the number of data records updated is not in the fixed range, the update condition setting unit sets the cache update condition such that the number of data records updated fall in the fixed range.

6. The application server system according to claim 5, wherein the cache update condition of each application server differs from the cache update condition of any other application server.

7. The application server system according to claim 5, wherein the cache update condition of all the application servers is identical.

8. A cache update method comprising:

storing a retrieval condition received from a terminal and a retrieval result retrieved using the retrieval condition in a correlated form in a cache memory;

reading the retrieval result from the cache memory when a retrieval request is identical to the stored retrieval request;

setting a cache update condition that indicates when the cache memory is to be updated;

determining whether to transmit an update request based on the cache update condition;

sending, to the database management system, a retrieval expression, which is produced based on the retrieval condition received from a client terminal or read from the cache memory, based on the update request received at the determining;

receiving the retrieval result of a database from the database management system; and

storing the retrieval condition and the retrieval result in the correlated form in the cache memory, wherein

the setting includes acquiring a number of data records updated within a predetermined period from the database, and determining whether the number of data records updated within the predetermined period is in a fixed range of the data records and, if the number of data records updated is not in the fixed range, the setting includes setting the cache update condition such that the number of data records updated fall in the fixed range.

9. An application server comprising:

a cache memory that stores therein in a correlated form a retrieval expression and a retrieval result; and

a main controlling unit that sends, to a database management system, the retrieval expression that is produced based on a retrieval condition received from a client terminal or read from the cache memory based on a cache update condition, receives the retrieval result of a database by the retrieval expression from the database management system, and stores the retrieval expression and the retrieval result in the correlated form in the cache memory, wherein

the main controlling unit acquires a number of data records updated within a predetermined period from the database management system, and determines whether the number of data records updated is in a fixed range of the data records and, if the number of data records updated is not in the fixed range, the main controlling unit sets the cache update condition such that the number of data records updated fall in the fixed range.

10. A cache control method comprising:

storing a retrieval expression and a retrieval result in a correlated form in a cache memory; and

sending, to a database management system, the retrieval expression that is produced based on a retrieval condition received from a client terminal or read from the cache memory based on a cache update condition;

receiving the retrieval result of a database by the retrieval expression from the database management system; and

storing the retrieval expression and the retrieval result in the correlated form in the cache memory, wherein

the sending includes acquiring a number of data records updated within a predetermined period from the database management system, and determining whether the number of data records updated is in a fixed range of the data records and, if the number of data records updated is not in the fixed range, the sending includes setting the cache update condition such that the number of data records updated fall in the fixed range.