System and method for ensuring referential integrity for...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07080085

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.

REFERENCES:
patent: 5483596 (1996-01-01), Rosenow et al.
patent: 5511186 (1996-04-01), Carhart et al.
patent: 5553218 (1996-09-01), Li et al.
patent: 5560005 (1996-09-01), Hoover et al.
patent: 5615112 (1997-03-01), Sheng et al.
patent: 5630127 (1997-05-01), Moore et al.
patent: 5644770 (1997-07-01), Burke et al.
patent: 5734899 (1998-03-01), Yoshizawa et al.
patent: 5745896 (1998-04-01), Vijaykumar
patent: 5787428 (1998-07-01), Hart
patent: 5809317 (1998-09-01), Kogan et al.
patent: 5826268 (1998-10-01), Schaefer et al.
patent: 5937402 (1999-08-01), Pandit
patent: 5978811 (1999-11-01), Smiley
patent: 5991776 (1999-11-01), Bennett et al.
patent: 6012067 (2000-01-01), Sarkar
patent: 6029160 (2000-02-01), Cabrera et al.
patent: 6038563 (2000-03-01), Bapat et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6085031 (2000-07-01), Johnson et al.
patent: 6085191 (2000-07-01), Fisher et al.
patent: 6088694 (2000-07-01), Burns et al.
patent: 6112209 (2000-08-01), Gusack
patent: 6144959 (2000-11-01), Anderson et al.
patent: 6151623 (2000-11-01), Harrison et al.
patent: 6154741 (2000-11-01), Feldman
patent: 6189010 (2001-02-01), Isip, Jr.
patent: 6192405 (2001-02-01), Bunnell
patent: 6249873 (2001-06-01), Richard et al.
patent: 6275824 (2001-08-01), O'Flaherty et al.
patent: 6308173 (2001-10-01), Glasser et al.
patent: 6385730 (2002-05-01), Garrison
patent: 6473748 (2002-10-01), Archer

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System and method for ensuring referential integrity for... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for ensuring referential integrity for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for ensuring referential integrity for... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3603988

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.