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

• US 20040010500A1
• Filed: 07/09/2002
• Published: 01/15/2004
• Est. Priority Date: 07/09/2002
• Status: Active Grant

• Current Assignee: Infor Global Solutions Michigan Incorporated (Infor Incorporated)
• Original Assignee: Bridgelogix Corp. (Infor Incorporated)
• Inventors: Madduri, Seshachala Kumar, Krishna, Koteswar
• Granted Patent: US 7,155,429 B2
• Time in Patent Office: Days
• US Class Current: 707/100
• 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. A process to aggregate automated transaction processing and thereby facilitate continuing database integrity comprising:

identifying at least one automated transaction aggregation candidate to be converted to a callable DLL function;

interrogating said selected candidate and determining said candidate'"'"'s associated processing requirements; and

,

generating a computer executable list of one or more DLL functions which respond to said candidate'"'"'s associated processing requirements.

2. The process to aggregate automated transaction processing of claim 1 further comprising:

re-sequencing event driven processing logic expressed within said identified candidate to an order of dependency processing logic.

3. The process to aggregate automated transaction processing of claim 1 further comprising:

identifying validation logic associated with said candidate; and

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

4. The process to aggregate automated transaction processing of claim 1 wherein said at least one DLL function includes code which performs sub-tasks associated with said DLL.

5. The process of claim 1 wherein the determination of said candidate'"'"'s associated processing requirements further comprises data validation or related task execution requirements and including such in said at least one callable DLL function

6. The process to aggregate automated transaction processing of claim 1 further comprising inserting first logic which connects to a database in advanced occurence of said callable DLL function, second logic which commits to updating to a database following successful execution of said DLL functions, third logic which rolls back updates to a database following unsuccessful execution of said DLL functions and start and end of step end processing logic.

7. The process to aggregate automated transaction processing of claim 6 further comprising the computerized conversion of said process into a DDC enabled function server.

8. The process to aggregate automated transaction processing of claim 6 further comprising the computerized conversion of said process into a business object interface DLL.

9. A computer readable medium encoded with a computer program for aggregating automated transaction processing and thereby facilitating continuing database integrity comprising:

an instruction set for executing one or more one or more DLL functions which are devoid of database connect, start of step, end of step, commit or rollback transaction processing logic;

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

an instruction set which commits to updating to a database following successful execution of said DLL functions; and

,

an instruction set which rolls back updates to a database following unsuccessful execution of said DLL functions.

10. The computer program of claim 9 further comprising an instruction set for converting said program into a DDC enabled function server program.

11. The computer program of claim 9 further comprising an instruction set for converting said program into a business object interface DLL.

12. 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 said program, adapts said general purpose computer to aggregate automated transaction processing and thereby facilitate continuing database integrity.

13. The apparatus of claim 12 wherein said executing program'"'"'s adaptation of said general purpose computer further comprises:

executing one or more one or more DLL functions which 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 said one or more DLL functions; and

,

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

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

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