System and method ordering operations to be performed on the relational database in order to maintain the referential integrity of the planned

摘要

A method, system, and computer program product for increasing the efficiency of operations that are to be performed against an arbitrary relational database by automatically ordering the operations according to the referential integrity constraints defined for the affected tables. Because the ordering is performed programmatically, the application developer is relieved of the burden of attempting to structure the application in a manner that avoids violating the referential integrity constraints. The efficiency of modifying the database increases significantly using this technique. The ordering may be performed at a database engine. Existing applications may take advantage of this ordering technique, without requiring change to the application itself. Batch-mode write operations are possible when using this technique, thereby reducing the number of network round-trips that must be performed.