Systems and methods for online transactional data processing
First Claim
1. An online transactional data processing system, comprising:
- a relational database for storing transactional data;
an OLTP application program for processing the transactional data, the OLTP application program operable to generate a set of change documents for each run of the OLTP application program, wherein each change document is descriptive of a transformation of the transactional data;
a mass storage device for storing the change documents;
means for receiving a request for correction of a previous run of the OLTP application program;
means for reading the set of change documents of the previous run from the mass storage device into a random access memory;
means for inverting the transformations as described by the set of change documents of the previous run;
means for initiating a renewed run of the OLTP application program to create a new set of change documents that are temporarily stored in the random access memory; and
means for overwriting at least a sub-set of the set of change documents of the previous run stored on the mass storage device by at least a sub-set of the new set of new change documents.
3 Assignments
0 Petitions
Accused Products
Abstract
An online transactional data processing (OLTP) system is provided that includes a relational database for storing transactional data, an OLTP application program for processing the transactional data, and a change log for storing a set of change documents that describe transformations performed on the transactional data by the OLTP application program. To correct a run of the OLTP application program, the set of change documents is used to re-establish the original state. A re-run of the OLTP application program may produce a new set of change documents in the random access memory (RAM) of the OLTP system. Further, the original set of change documents stored in the change log may be at least partly overwritten by the new set of change documents.
26 Citations
21 Claims
-
1. An online transactional data processing system, comprising:
-
a relational database for storing transactional data;
an OLTP application program for processing the transactional data, the OLTP application program operable to generate a set of change documents for each run of the OLTP application program, wherein each change document is descriptive of a transformation of the transactional data;
a mass storage device for storing the change documents;
means for receiving a request for correction of a previous run of the OLTP application program;
means for reading the set of change documents of the previous run from the mass storage device into a random access memory;
means for inverting the transformations as described by the set of change documents of the previous run;
means for initiating a renewed run of the OLTP application program to create a new set of change documents that are temporarily stored in the random access memory; and
means for overwriting at least a sub-set of the set of change documents of the previous run stored on the mass storage device by at least a sub-set of the new set of new change documents. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method of online transactional data processing, comprising:
-
storing transactional data in a relational database;
performing a first run of an OLTP application program for processing the transactional data generating a first set of change documents, wherein each change document is descriptive of a transformation of the transactional data;
storing the first set of change documents on a mass storage device;
receiving a request for correction of the first run;
reading the first set of change documents from the mass storage device into a random access memory;
inverting the transformations as described by the first set of change documents;
performing the correction of the transactional data;
initiating a second run of the OLTP application program to create a second set of change documents that is temporarily stored in the random access memory; and
overwriting at least a sub-set of the first set stored on the mass storage device by at least a sub-set of the second set of change documents. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer readable medium comprising program code instructions for executing a method for online transactional data processing, the method comprising:
-
storing transactional data in a relational database;
performing a first run of an OLTP application program for processing the transactional data generating a first set of change documents, wherein each change document is descriptive of a transformation of the transactional data;
storing the first set of change documents on a mass storage device;
receiving a request for correction of the first run;
reading the first set of change documents from the mass storage device into a random access memory;
inverting the transformations as described by the first set of change documents;
performing the correction of the transactional data;
initiating a second run of the OLTP application program to create a second set of change documents that is temporarily stored in the random access memory; and
overwriting at least a sub-set of the first set stored on the mass storage device by at least a sub-set of the second set of change documents. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification