Database system, database update method, database, and database update program

• US 8,380,660 B2
• Filed: 03/31/2009
• Issued: 02/19/2013
• Est. Priority Date: 04/04/2008
• Status: Expired due to Fees

• Current Assignee: NEC Corporation
• Original Assignee: NEC Corporation
• Inventors: Honda, Kazutoshi
• Primary Examiner(s): Ly, Anh
• Application Number:
  US12/922,051
• Publication Number:
  US 20110004583A1
• Time in Patent Office: 1,421 Days
• Field of Search: 707/609, 707/704, 707/E17.005, 707/999.008, 711/147, 711/148, 711/153, 711/E12.001, 711/E12.066, 711/173
• US Class Current: 707/609
• CPC Class Codes: G06F 16/24539 using cached or materialised query results

Abstract

A database system, which updates data by an application program, includes data storage for storing a master data and a shared memory area. The shared memory area includes: a first area, which loads the master data and to which an application program is allowed only to refer; and a second area, which stores a difference data generated when the application program updates the master data in the first area, and which the application program is allowed to refer to and update. The database system is robust against variation of application programs and environments.

Claims

1. A memory database system, which updates data by an application program, comprising:

a data storage unit to store a master data; and

a shared memory area, including;

a first area to load said master data and to only be referred to by said application program; and

a second area to store a difference data, which is generated when said application program updates said master data in said first area, and to be referred to and updated by said application program, wherein

said master data includes a main data and an index for reference for referring to the main data, and wherein

said difference data includes an index for update, which links to said index for reference and refers to said difference data.

2. The memory database system according to claim 1, further comprising:

a daemon execution unit to refer to said first and second areas and to update said first and second areas.

3. The memory database system according to claim 2, wherein

said daemon execution unit reflects said difference data into said master data, and eliminates said difference data.

4. The memory database system according to claim 3, wherein

when the daemon execution unit reflects said difference data into said master data, said daemon execution unit excludes said first and second areas.

5. The memory database system according to claim 1, wherein

when said application program updates said master data, said second area is excluded.

6. A database update method for updating data by an application program, comprising:

updating a master data loaded in a first area, which is only referred to by said application program, and generating a difference data;

storing the difference data, which is generated when said application program updates said master data, in a second area, which is referred to and updated by said application program;

reflecting said difference data into said master data; and

eliminating said difference data, wherein

said master data includes a main data and an index for reference for referring to the main data, and wherein

said difference data includes an index for update, which links to said index for reference and refers to said difference data.

7. The database update method according to claim 6, further comprising:

excluding said second area, before said application program updates said master data; and

cancelling exclusion for said second area, after said application program updates said master data.

8. The database update method according to claim 6, further comprising:

excluding said first and second areas, before reflecting said difference data into said master data; and

cancelling exclusion for said first and second areas, after reflecting said difference data into said master data.

9. The database update method according to claim 6, further comprising:

updating said master data by another application program, before reflecting said difference data into said master data; and

appending a difference of said master data updated by said another application program to said difference data.

10. A memory database system, which updates data by an application program, comprising:

a first area, which loads a master data, and which is only referred to by said application program; and

a second area, which stores a difference data, generated when said application program updates said master data in said first area, and which is referred to and updated by said application program, wherein

said master data includes a main data and an index for reference for referring to the main data, and wherein

said difference data includes an index for update, which links to said index for reference and refers to said difference data.

11. The memory database system according to claim 10, wherein

said difference data is reflected into said master data and said difference data is eliminated by a daemon, which refers to said first and second areas and updates said first and second areas.

12. The memory database system according to claim 11, wherein

said first and second areas are excluded, when said difference data is reflected into said master data by said daemon.

13. The memory database system according to claim 10, wherein

said second area is excluded, when said application program updates said master data.

14. A non-transitory computer-readable data storage medium having stored thereon a computer program that when executed by a computer causes a method to be performed, the method for updating data loaded in a database, the method comprising:

updating a master data loaded in a first area, which is only referred to by said program, and generating a difference data;

storing said difference data in a second area, which is referred to and updated by said program;

reflecting said difference data into said master data; and

eliminating said difference data, wherein

said master data includes a main data and an index for reference for referring to the main data, and wherein

said difference data includes an index for update, which links to said index for reference and refers to said difference data.