Data processing system for dynamically switching access control process and for performing recovery process

• US 5,553,303 A
• Filed: 12/20/1994
• Issued: 09/03/1996
• Est. Priority Date: 08/31/1990
• Status: Expired due to Term

• Current Assignee: Google Inc. (Alphabet Inc.)
• Original Assignee: Fujitsu Limited
• Inventors: Hayashi, Katsumi, Hayashi, Tomohiro, Ishii, Takuji, Sekine, Yutaka, Mitani, Masaaki, Obata, Takashi, Saitou, Kazuhiko, Ohsato, Hiroshi, Ura, Mitsuhiro
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Loomis, John C.
• Application Number:
  US08/360,033
• Time in Patent Office: 623 Days
• Field of Search: 395/600, 395/200.03, 395/182.11, 395/182.13, 395/183.07, 395/600, 395/650
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

A database processing system using a multi-processor including a plurality of processor modules each having a local memory connected to an external shared memory. The database processing system includes a composite structure definition control part for defining an administrative processor module for controlling an access to a composite structure of a database which has a storage structure independent of a logical structure; and a maintenance/selection control part in an optimum control processor for providing a function of access-controlling a shared process and a local process when an access request arises for a database composite structure, and for dynamically switching the access control process for the composite structure according to the access frequency notified by each processor module. The system may further include an operation continuing control part for providing a controlling function for a recovery process for the composite structure of a database to be locally processed or shared-processed, and for performing a recovery process according to an access control process type for the composite structure of the database when the processor module falls in error, by replacing the erroneous processor module with another single processor module or a plurality of processor modules.

Claims

1. A database processing system using a multiprocessor including a plurality of processor modules each having a local memory connected to an external shared memory, said database processing system comprising:

a composite structure definition control part for defining an administrative processor module for controlling an access to a composite structure of a database which has a storage structure independent of a logical structure; and

a maintenance/selection control part in an optimum control processor for providing a function of access-controlling a shared process and a local process when an access request arises for a database composite structure, and for dynamically switching the access control process for said composite structure according to an access frequency notified by each said processor module.

2. The data base processing system for use in a multi-processor system according to claim 1, wherein

said maintenance/section control part calculates a sum of the number of accesses to said composite structure or a composite structure set from a respective said processor modules per predetermined time period, thereby switching an access management between a local process and a shared process.

3. The data base processing system for use in a multi-processor system according to claim 1, wherein

said maintenance/selection control part calculates a ratio or rate of the number of accesses from a respective said processor modules per unit time.

4. The data base processing system for use in a multi-processor system according to claim 1, wherein

said maintenance/selection control part calculates a ratio of the number of accesses to said composite structure from respective said processor modules and transfers a management of said composite structure or composite structure set to a particular said processor module exceeding a defined value.

5. The data base processing system for use in a multi-processor system according to claim 1, wherein, when a composite structure set being processed is in a local process, a ratio of the number of accesses to said composite structure set from a respective said processor module is calculated;

when a ratio of the number of accesses from a respective said processor module is smaller than the defined value the composite structure set from said respective processor module is switched to a management of a shared control;

when a ratio of the number of accesses is larger than the defined value, a ratio of the number of accesses to a respective said composite structure from a respective said processor module is calculated; and

when a ratio of the number of accesses is smaller than the defined value, the composite structure is switched to a management of a shared control.

6. The data base processing system for use an a multi-processor system according to claim 1, wherein, when a composite structure set being processed is in a shared process, a ratio of the number of accesses to said composite structure set is calculated;

when a ratio of the number of accesses is larger than the defined value, the composite structure set is switched to a management of a local control;

when a ratio of the number of accesses is smaller than the defined value, a ratio of the number of accesses to respective composite structure is calculated; and

when a ratio of the number of accesses is larger than the defined value, the composite structure is switched to a management of a local control.

7. The data base processing system for use in a multi-processor system according to claim 1, wherein

said processor module for performing a transferring operation prohibits an access to a composite structure or a composite structure set from other said processor modules, a management of said composite structure or composite structure set is switched between said shared and local processes, and a prohibition of an access to said composite structure or composite structure set is released after completion of the switching operation.

8. A database processing system using a multiprocessor including a plurality of processor modules each having a local memory connected to an external shared memory, said database processing system comprising:

a composite structure definition control part for defining an administrative processor module for controlling an access to a composite structure of a database which has a storage structure independent of a logical structure; and

an operation continuing control part for providing a controlling function for a recovery process for said composite structure of a database to be locally processed or shared-processed, and for performing a recovery process according to an access control process type for said composite structure of the database when a processor module falls in error, by replacing the erroneous said processor module with another single said processor module or a plurality of said processor modules.

9. The data base processing system for use in a multi-processor system according to claim 8, wherein

said operation continuing control part performs said recovery process from the crash by reading log information existing in the shared memory and prohibiting or releasing an access to the unrecovered portion.

10. The data base processing system for use in a multi-processor system according to claim 8, wherein

said operation continuing control part performs said recovery process from the crash by using log data provided within a range from the most recent recovery starting point in check point information until a log terminating point upon an occurrence of the crash.