System and method for ensuring referential integrity for heterogeneously scoped references in an information management system

• US 7,080,085 B1
• Filed: 07/12/2000
• Issued: 07/18/2006
• Est. Priority Date: 07/12/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Raghavan, Sriram, Choy, David Mun-Hien
• Primary Examiner(s): Corrielus, Jean M.
• Assistant Examiner(s): Woo, Isaac M.
• Application Number:
  US09/614,369
• Time in Patent Office: 2,197 Days
• Field of Search: 707/501.1, 707/500.1, 707 1- 10, 707100-1041, 707200-206, 715500-510
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A system and method are provided for an information management system (IMS) to manage heterogenous references in the system, to ensure “referential integrity”, without changing the underlying relational database management system (RDBMS) of the IMS. One or more system tables are kept that are not visible to system users. In one embodiment, the RDBMS'"'"' mechanisms to ensure referential integrity for homogenous references is used in conjunction with the system table to extend referential integrity to heterogenous references. In another embodiment, the triggers of the RDBMS, in conjunction with the system table, are used to ensure referential integrity of heterogenous references.

Claims

1. A computer-implemented method for preventing dangling pointers in heterogeneously scoped links, comprising the acts of:

providing at least one heterogeneously scoped link (HSL) table in a non-RDBMS element communicating with at least one RDBMS, at least one table having a heterogeneously scoped link column, the HSL table being associated with the heterogeneously scoped link column; and

accessing the HSL table to ensure referential integrity in an RDBMS.

2. The method of claim 1, wherein the HSL table is accessed when a link attribute is sought to be changed.

3. The method of claim 1, wherein the HSL table is accessed when a tuple is sought to be changed or deleted.

4. The method of claim 1, wherein the HSL table is established by an RI table.

5. The method of claim 1, further comprising providing at least one trigger useful in selectively disallowing operations.

6. The method of claim 1, further comprising providing at least one stored procedure accessible by an application to insert, update, or delete a tuple while ensuring referential integrity in heterogenous links associated with the tuple.