Method and system for intra-table referential integrity for relational database systems
AssigneeInternational Business Machines Corporation
InventorsGregory P. Fitzpatrick, Jeffrey A. Heming
Life of this patent
Estimating the term…
Abstract
In a relational database management system (RDBMS), a method of processing related records can include receiving a plurality of related records and inserting the plurality of related records into a single table of an RDBMS. The plurality of related records can be associated as a set within the single table using a published function of the RDBMS. Responsive to a triggering condition, particular related records of the set can be selectively purged from the single table.
Claims10
A computer-implemented relational database management system (RDBMS), comprising:
- an RDBMS table that stores a plurality of records, wherein said table includes an identifier that specifies related ones of said plurality of records as a record set, wherein said identifier is unique to each said record set;
- and
- an intra-table record set processor that configures the RDBMS table with the identifier and that publishes an associate records function and a purge associated set function, said associate records function and said purge associated set function comprising RDBMS functions that are each accessible by at multiple front-end systems,
- said associate records function configured to associate said related ones of said plurality of records with one another as a record set within said table using said identifier, wherein said associate records function further comprising programmatic code for disassociating selected records of said record set responsive to a triggering condition;
- and
- said purge associated set function configured to purge selected ones of said record set in said table responsive to a triggering condition, wherein the triggering condition identifies at least one of said related ones of said plurality of records, and wherein the purge associated set function purges non-identified ones of the related records from the RDBMS table using said identifier.
A computer-implemented relational database management system (RDBMS), comprising:
- a table that stores a plurality of records wherein particular ones of said plurality of records are related;
- an associated record set processor that associates said related ones of said plurality of records with one another as a record set within said table;
- a disassociate record set processor for disassociating selected records of said record set responsive to a triggering condition;
- a purge record set processor that purges selected ones of said record set in said table responsive to a triggering condition;
- and
- a second pre-defined table within said RDBMS for maintaining associations of said related ones of said plurality of records within said table as said record set, wherein the RDBMS publishes an associate record function and a purge associated set function so that multiple front-end systems are able to access the associate record function and the purge associated set function, wherein the triggering condition identifies at least one of said related ones of said plurality of records, and wherein the purge associated set function purges non-identified ones of the related records from the RDBMS table.
Dependencies are inferred from the claim text.