Database management method, apparatus and system

• US 8,874,509 B2
• Filed: 12/01/2008
• Issued: 10/28/2014
• Est. Priority Date: 12/13/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Takano, Kohji, Takano, Sawa
• Primary Examiner(s): Leroux, Etienne
• Assistant Examiner(s): DAYE, CHELCIE L
• Application Number:
  US12/325,517
• Publication Number:
  US 20090157773A1
• Time in Patent Office: 2,157 Days
• Field of Search: 707/204, 707/611, 709/203, 709/248
• US Class Current: 707/611
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

A technique for appropriately managing a database in an apparatus with a limited storage capacity is described. A client apparatus includes a first storage unit storing part of a record set included in a database of a database server apparatus, and a second storage unit storing a copy of the record set stored in the first storage unit. The client apparatus usually searches the second storage unit. If data is not found, the client apparatus transmits a search request to the database server apparatus and stores a search result in the second storage unit. When the client apparatus receives update data from the database server apparatus, the client apparatus performs processing of updating the first storage unit.

Claims

1. A client apparatus comprising:

a communication unit communicating with a database server apparatus over a network;

a first storage unit storing part of a record set included in a database of the database server apparatus;

a second storage unit storing a copy of the record set stored in the first storage unit, said copy of the record set disappears from said second storage unit upon losing a power supply;

a management unit copying the record set from the first storage unit to the second storage unit upon resumption of said power supply to said second storage unit; and

a searching unit searching the second storage unit in response to a search request for data from a user,

wherein in response to absence of the requested data in the second storage unit, the searching unit requests the data from the database server apparatus via the communication unit and stores a record containing the requested data returned from the database server apparatus in the second storage unit, and

the management unit updates the record set stored in the first storage unit by using update data generated by reference to an order list of the record set stored in the first storage unit and the number of searches recorded, and received from the database server apparatus via the communication unit, and deletes a record, from the second storage unit, for which few search requests have been made.

2. The client apparatus according to claim 1, wherein the first storage unit is nonvolatile memory, and the second storage unit is volatile memory.

3. The client apparatus according to claim 2, wherein the management unit copies the record set from the first storage unit to the second storage unit in response to resumption of power supply to the second storage unit after shutoff of the power supply.

4. The client apparatus according to claim 1, wherein the management unit deletes said record for which few search requests have been made from the second storage unit in absence of available space to add the record containing the requested data returned from the database server apparatus.

5. The client apparatus according to claim 1, wherein the client apparatus is an embedded device.

6. The client apparatus according to claim 1, wherein the update performed by the management unit for the record set stored in the first storage unit comprises at least one of addition of one or more records, deletion of one or more records, and modification of one or more records.

7. A system comprising a database server apparatus and a plurality of client apparatuses connecting to the database server apparatus over a network, wherein each client apparatus comprises:

a communication unit communicating with the database server apparatus over the network;

a first storage unit storing part of a record set included in a database of the database server apparatus;

a second storage unit storing a copy of the record set stored in the first storage unit;

a management unit updating the record set stored in the first storage unit and copying the record set from the first storage unit to the second storage unit following resumption of a power supply to the second storage unit; and

a searching unit searching the second storage unit in response to a search request for data from a user of the client apparatus and, following determination that the data is not found, transmitting a search request to the database server apparatus and storing a record containing the data returned from the database server apparatus in the second storage unit, and

the database server apparatus comprises;

the database;

a database management unit searching the database in response to a search request received from the second storage unit from each client apparatus;

a search information recording unit recording the number of searches for each record;

an order list storage unit storing an order list of the records commonly stored in the first storage unit of each client apparatus; and

an update data generation unit generating, based on the number of searches and the order list, update data for updating the record set commonly stored in the first storage unit of each client apparatus.

8. The system according to claim 7, wherein the update data comprises one or more records to be added to the record set stored in the first storage unit of the client apparatus, and information about one or more records to be deleted from the record set.

9. The system according to claim 7, wherein the order list of the records commonly stored in the first storage unit of each client is an order list in terms of recency of the records.

10. A database management method performed in a client apparatus capable of communicating with a database server apparatus over a network, comprising:

storing, in a first storage unit, part of a record set included in a database of the database server apparatus;

copying the record set stored in the first storage unit to a second storage unit upon resumption of a power supply to the second storage unit after loss of the copy of the record set by said second storage unit due to a power shutoff;

searching the second storage unit in response to a search request for data from a user of the client apparatus;

in response to absence of the requested data in the second storage unit, requesting the data from the database of the database server apparatus and storing a record containing the data returned from the database server apparatus in the second storage unit; and

updating the record set stored in the first storage unit in response to reception of update data generated by reference to an order list of the record set stored in the first storage unit and the number of searches recorded, for updating part of the record set included in the database from the database server apparatus.

11. The database management method according to claim 10, wherein the first storage unit is nonvolatile memory, and the second storage unit is volatile memory.

12. A database management method performed in a system comprising a database server apparatus and a plurality of client apparatuses connecting to the database server apparatus over a network, wherein each client apparatus comprises a first storage unit of nonvolatile memory storing part of a record set included in a database of the database server apparatus and a second storage unit of volatile memory storing a copy of the record set stored in the first storage unit, the method comprising:

in each client apparatus,

searching the second storage unit in response to a search request for data from a user;

in response to absence of the requested data in the second storage unit, requesting the data from the database of the database server apparatus and storing a record containing the data returned from the database server apparatus in the second storage unit; and

updating the record set stored in the first storage unit, and

in the database server apparatus,

searching the database in response to a request for data not included in the second storage unit from each client apparatus;

recording the number of searches for each record; and

with reference to an order list of the record set commonly stored in the first storage unit of each client apparatus and the number of searches, generating update data for updating the record set commonly stored in the first storage unit of each client apparatus.