Abstract: One or more embodiments of the invention enable a smart store and forward DBMS statement collating system. The system may be utilized with any database implementation by coupling computer readable program code to the interface layer of the database, generally the lowest layer of software that accesses the database. The system can be utilized with complex transactional code that insulates a user from programming complex collating logic. Hence a user that employs an embodiment of the system is unaware that database operations within a transaction are collated into silos with like table and field usage and flushed to the database as part of a database block operation. The order in which operations occur allows for high priority table inserts to occur before low priority table inserts to maintain referential integrity, while low priority table deletes occur before high priority table deletes for the same reason.

Abstract: One or more embodiments of the invention enable a smart store and forward DBMS statement collating system. The system may be utilized with any database implementation by coupling computer readable program code to the interface layer of the database, generally the lowest layer of software that accesses the database. The system can be utilized with complex transactional code that insulates a user from programming complex collating logic. Hence a user that employs an embodiment of the system is unaware that database operations within a transaction are collated into silos with like table and field usage and flushed to the database as part of a database block operation. The order in which operations occur allows for high priority table inserts to occur before low priority table inserts to maintain referential integrity, while low priority table deletes occur before high priority table deletes for the same reason.