A method, apparatus and article of manufacture to aggregate automated
transaction processing and facilitate database integrity. In one
embodiment of the invention, identified transactions are interrogated and
their associated processing requirements determined. Once determined,
transaction processing logic relating to database connection, startup
steps, end of step, commit or roll back are removed with the resulting
transaction stored as a callable DLL. The resultant DLL or DLLs further
modified to re-sequence validation logic to on input data appropriately
ordered sequence. The invention additionally comprises first logic which
connects to a database in advance of referencing any callable DLL
functions; second logic commits to updating a database following
successful execution of any called DLL functions and third logic which
rollbacks updates to a database following unsuccessful execution of
called DLL functions as well as startup step and end of step processing
logic. Consequently, multiple transaction processing steps are combined
into a single transaction (DLL) which enhances operational efficiency
allows end to end acknowledgment and is decreases execution time for
multi-step processing.