Method, apparatus and article of manufacture to aggregate automated transaction procession

• US 7,155,429 B2
• Filed: 07/09/2002
• Issued: 12/26/2006
• Est. Priority Date: 07/09/2002
• Status: Expired due to Term

• Current Assignee: Infor Global Solutions Michigan Incorporated (Infor Incorporated)
• Original Assignee: Bridgelogix Corp. (Infor Incorporated)
• Inventors: Madduri, Seshachala Kumar, Krishna, Koteswar
• Primary Examiner(s): Gaffin, Jeffrey
• Assistant Examiner(s): NGUYEN, CAM LINH T
• Application Number:
  US10/191,468
• Publication Number:
  US 20040010500A1
• Time in Patent Office: 1,631 Days
• Field of Search: 707 1- 4, 707/100
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

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.

Claims

1. An apparatus for aggregating automated transaction processing and thereby facilitating continuing database integrity comprising:

a general purpose computer;

a memory that stores a transaction aggregation program; and

a central processing unit that, when executing the program, adapts the general purpose computer to aggregate automated transaction processing and thereby facilitate continuing database integrity;

wherein the executing program'"'"'s adaptation of the general purpose computer further comprises;

executing one or more DLL functions that is/are devoid of database connect, start of step, end of step, commit or rollback transaction processing logic;

executing an instruction set for connecting to a database prior to executing the one or more DLL functions; and

,

executing an instruction set which commits to updating to a database following successful execution of the DLL functions or rolls backs any updates made to a database following unsuccessful execution of the DLL functions.

2. The apparatus of claim 1 wherein the general purpose computer adaptation further comprises executing an instruction set which adapts the computer to operate as a DDC enabled function server.

3. The apparatus of claim 1 wherein the executing program'"'"'s adaptation of the general purpose computer adaptation further comprises executing an instruction set which adapts the computer to receive, parse, process and communicate XML files.

4. A process to aggregate automated transaction processing utilizing software to facilitate continuing database integrity, the process comprising the steps of:

selecting at least one automated candidate to be converted to a callable DLL function;

interrogating the selected candidate and determining associated processing requirements of the selected candidate;

re-sequencing event driven processing logic expressed within the selected candidate to an order of dependency processing logic;

identifying input validation logic associated with the selected candidate;

re-sequencing the identified input validation logic to validate input data in an ordered sequence;

identifying data validation logic associated with the selected candidate;

structuring the identified processing logic;

storing the identified processing logic; and

generating a computer executable list of the one or more DLL functions that responds/respond to the associated processing requirements, wherein the DLL function is devoid of database connect, start of step, end of step, commit or rollback transaction processing logic.

5. The process of claim 4, further including the steps of:

inserting first logic connecting to a database in advance of occurrence of the callable DLL function;

inserting second logic that commits to updating to updating the database following successful execution of the DLL function; and

inserting third logic that rolls back updates to a database following unsuccessful execution of the DLL function.