System and method for constraint checking bulk data in a databas

Details System and method for constraint checking bulk data in a databas System and method for constraint checking bulk data in a databas

1995-02-10

1998-01-06

Black, Thomas G.

395604, 395612, 395616, G06F 1730

Patent

active

057064946

ABSTRACT:
In a relational database management system (RDMS), a method and system for constraint checking of bulk data after storage in a base table. This invention generates a "dummy" INSERT inquiry to cause the compiler constraint rule engine to generate code for checking for constraint violations. After construction of a Query Graph Model by the compiler, a logic module replaces the INSERT inquiry with a SELECT inquiry to create code that when executed will select records from the bulk data table. Constraint violations are handled in several ways by this invention, including merely reporting that a constraint error exists or listing those records that violate constraint conditions. The logic also enforces referential integrity constraints by applying the SQL CASCADE command to the violating records to expand the violation list to include children records that would be orphaned when their parent records are later removed.

REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5201046 (1993-04-01), Goldberg et al.
patent: 5226158 (1993-07-01), Horn et al.
patent: 5295256 (1994-03-01), Bapat
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5355474 (1994-10-01), Thuraisngham et al.
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5386557 (1995-01-01), Boykin et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5471629 (1995-11-01), Risch
patent: 5499359 (1996-03-01), Vijaykumar
Ingo DB, Spring 1989, USA, vol. 4, No. 1, ISSN 0891-6004, pp. 13-19, XP000571335 Eberhard, R., et al: "DB2 Referential Integrity Performance" p. 13, col. 1, Line 1, p. 13, col. 1, Line 53.
Communication, European Search Report, Jun. 4, 1996.
Guy M. Lohman, "Grammar-Like Functional Rules for Representing Query Optimization Alternatives", IBM Almaden Research Center Report, San Jose, California, pp. 18-26, 1988.
Hamid Pirahesh et al., "Extensible/Rule Based Query Rewrite Optimization in Starburst", Proceedings of ACM SIGMOD 1992 Intl. Conf. on Management of Data, pp. 39-47.

Affiliated with

Also associated with

Rating

System and method for constraint checking bulk data in a databas 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 constraint checking bulk data in a databas, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for constraint checking bulk data in a databas will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2337988