Patent ID: 6542883
Filing Date: 2003-04-01
Classification: G06F,Y10S

Abstract:
A computer program product for programmatically ordering operations to be performed against a relational database in order to maintain referential integrity of said database, said computer program product embodied on a computer-readable medium and comprising:computer-readable program code means for determining, for a plurality of tables of said database, an order in which inserts should be made to said tables; computer-readable program code means for determining, for said plurality of tables of said database, an order in which deletes should be made to said tables; computer-readable program code means for grouping a plurality of modifications to be made to said database according to (1) an operation to be performed by each of said modifications and according to (2) a particular one of said tables which is to be affected by each of said modifications; and computer-readable program code means for applying said grouped modifications to said database, further comprising: computer-readable program code means for first applying all of said grouped modifications for which said operation is insert, according to said insert order; computer-readable program code means for next applying all of said grouped modifications for which said operation is update; and computer-readable program code means for last applying all of said grouped modifications for which said operation is delete, according to said delete order.