Data dictionary manager for maintaining an active data dictionary

• US 5,375,234 A
• Filed: 01/28/1994
• Issued: 12/20/1994
• Est. Priority Date: 12/31/1991
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Davidson, William S., Eggerling, Kurt W.
• Primary Examiner(s): Kriess, Kevin A.
• Application Number:
  US08/188,668
• Time in Patent Office: 326 Days
• Field of Search: 395/575, 395/600, 395/650, 395/700, 395/800
• US Class Current: 707/610
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The data dictionary manager takes advantage of the computer system'"'"'s journaling capability enhanced to allow users and application programs to manipulate system objects without the use of the data dictionary'"'"'s built-in utilities. As used here, journaling capability is an internal tracking facility which exists in a somewhat limited form on many computer systems. Typical journaling mechanisms maintain a repository of information about some of the activities that have taken place on the computer system. The information is usually stored in a record called an audit journal. Since many computer systems have limited journaling mechanisms already in place, these mechanisms can be enhanced to add the ability to record information about changes to system objects. Examples of system object changes included in the audit journal are deletes, creates, renames, and moves. Once the information has been logged in the audit journal, the data dictionary manager retrieves the information from the audit journal and ensures that the changes are accurately reflected in the data dictionary. Since the audit journal can be made accessible to several processes, it is possible to have different instances of the data dictionary manager responsible for different data dictionaries. Alternatively, it is possible to have a single data dictionary manager that is responsible for all of the computer system'"'"'s data dictionaries.

Claims

1. A method for maintaining a synchronized data dictionary comprising the steps of:

accessing objects coordinated by said dictionary, said objects being contained in a data base and accessed by an application program;

affecting changes upon said objects, said objects being changed by an application program;

recording information about said changes in a record which is separate from said data dictionary and from said data base, said information being recorded by a journaling mechanism; and

updating said data dictionary to reflect said changes, said data dictionary being updated by a data dictionary manager.

2. The method of claim 1 wherein said recording step comprises the step within said journaling mechanism of placing an entry in an audit journal for each of said changes.

3. The method of claim 2 wherein said updating step comprises tile steps within said data dictionary manager of:

retrieving said information about said changes from said audit journal;

and ensuring that said information is reflected by said data dictionary.

4. A method for maintaining a data dictionary across a system failure, said method comprising the steps within a data dictionary manager of:

marking am audit journal with a first mark, said audit journal containing audit journal entries, said audit journal entries containing information about changes to a data bse, said first mark being used to indicate the location of a last audit journal entry processed;

validating said last entry processed with a second mark;

returning to the first instance of said first mark that has been validated by said second mark; and

updating said data dictionary so that said data dictionary is synchronized with said data base.

5. The method of claim 4 wherein said marking step comprises the step of using a checkpoint entry.

6. The method of claim 4 wherein said validating step comprises the step of using a commit entry.

7. A method for adjusting the synchronization of a data dictionary, said method comprising the steps:

within a journaling mechanism of;

recording information about changes to system objects in an audit journal, where said information its in the form of one entry per change;

within a data dictionary manager of;

accepting as prompts synchronization requests, where said synchronization requests are requests to process said entries of said edit journal;

waking whenever a timer expires, said timer being set to an adjustable timeout value; and

responding to said synchronization requests and said timer expiration by retrieving said entries from said audit journal and updating said data dictionary accordingly.

8. An apparatus for maintaining a synchronized data dictionary comprising:

means for accessing objects coordinated by said dictionary, said objects being contained in a data base and accessed via an application program;

means for affecting changes upon said objects;

means for recording information about said changes in a record separate from said data dictionary and from said data base; and

means for updating said data dictionary to reflect said changes.

9. The apparatus of claim 8 wherein said means for recording comprises means for placing an entry in an audit journal for each of said changes.

10. The apparatus of claim 9 wherein said means for updating comprises:

means for retrieving said information about said changes from said audit journal; and

means for ensuring that said information is reflected by said data dictionary.

11. An apparatus for maintaining a data dictionary across a system failure, said apparatus comprising:

means for marking an audit journal with a first mark, said audit journal containing audit journal entries, said audit journal entries containing information about changes to a data base, said first mark being used to indicate the location of a last audit journal entry processed;

means for validating said last entry processed with a second mark;

means for returning to the first instance of a said first mark that has been validated by a said second mark; and

means for updating said data dictionary such that said data dictionary is synchronized with said data base.

12. The apparatus of claim 11 wherein said means for marking comprises a checkpoint entry.

13. The apparatus of claim 11 wherein said means for validating comprises a commit entry.

14. An apparatus for adjusting the synchronization of a data dictionary, said apparatus comprising:

a journaling mechanism which comprises means for recording information about changes to system objects in an audit journal, where said information is in the form of one entry per change; and

a data dictionary manager which comprises;

means for accepting as prompts synchronization requests, where said synchronization requests are requests to process said entries of said audit journal;

means for waking whenever an adjustable timeout occurs; and

means for responding to said synchronization requests and said timeout by retrieving said entries from said audit journal and updating said data dictionary accordingly.

15. A data dictionary manager comprising:

means for accessing objects coordinated by said dictionary, said object being contained in a data base and accessed via an application program;

means for affecting changes upon said objects;

means for recording information about said changes in a record which is separate from said data dictionary and from said data base; and

means for updating said data dictionary to reflect said changes.

16. The data dictionary manager of claim 15 wherein said means for recording comprises means for placing an entry in an audit journal for each of said changes.

17. The data dictionary manager of claim 16 wherein said means for updating comprises:

means for retrieving said information about said changes from said audit journal; and

means for ensuring that said information is reflected by said data dictionary.

18. A data dictionary manager which maintains a data dictionary'"'"'s integrity across a system failure, said data dictionary manager comprising:

means for marking an audit journal with a first mark, said audit journal containing audit journal entries, said audit journal entries containing information about changes to a data base, said first mark being used to indicate the location of a last audit journal entry processed;

means for validating said last entry processed with a second mark;

means for returning to the first instance of a said first mark that has been validated by a said second mark; and

means for updating said data dictionary such that it is synchronized with said data base.

19. The data dictionary manager of claim 18 wherein said means for marking comprises a checkpoint entry.

20. The data dictionary manager of claim 18 wherein said means for validating comprises a commit entry.

21. A data dictionary manager which allows for the adjusting of the synchronization of a data dictionary, said data dictionary manager comprising:

means within said data dictionary manager for recording information about changes to system objects in an audit journal, where said information is in the form of one entry per change;

means within said data dictionary manager for accepting as prompts synchronization requests, where said synchronization requests are requests to process said entries of said audit journal;

means within said data dictionary manager for waking whenever an adjustable timeout occurs; and

means within said data dictionary manager for responding to said synchronization requests and said timeout by retrieving said entries from said audit journal and updating said data dictionary accordingly.