IP Library Granted Patent US 12699699
Granted Patent B2
US 12699699 · App. 17/126,577 · Granted Aug 4, 2026

Computer-implemented method for analyzing a transaction log

Inventor: Markus Lachenmayr (Munich, DE)
Assignee: Siemens Aktiengesellschaft
G06F16/24564G06F16/1805G06F16/1865G06F16/2365G06F16/908
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12699699
App. No.
17/126,577
Granted
Aug 4, 2026
Kind
B2
Abstract

Provided is a computer-implemented method for analyzing a transaction log, stored in a computer readable storage medium, wherein the transaction log comprises records of transactions in the range of zero to a plurality of records, wherein each record of transaction comprises at least one action executed during a test and at least one associated recorded criterion, comprising the steps: a. Providing the transaction log and at least one filter criterion; b. Determining records of transactions from the transaction log to be filtered in accordance with the at least one filter criterion; wherein the at least one filter criterion matches the respective associated recorded criterion of the action at least one action of the respective filtered records of transactions of transaction; c. Determining a test verdict based on the filtered records of transactions of transaction; and d. Providing the filtered records of transactions, the test verdict and/or related data as output.

Claims (42)

1 . A method for analyzing a transaction log stored in a database, wherein a computer readable storage medium comprises the database, wherein the computer readable storage medium is not a transitory signal, said method comprising steps of:

a. providing, by a technical unit selected from the group consisting of a processor of a computer system and an application-specific integrated circuit (ASIC), the transaction log and at least one filter criterion;

b. retrieving, by the technical unit from the transaction log stored on the computer readable storage medium, those records of transactions meeting at least one filter criterion, wherein the transaction log comprises a plurality of records of transactions, and wherein each record of transaction in the transaction log comprises at least one action executed and tested during a test and at least one associated recorded criterion, wherein the at least one action of each retrieved record includes one or more database processings on the database; and

c. storing and/or displaying, by the technical unit, the retrieved records of transactions, a test verdict, and a message in accordance with the test verdict, wherein the test verdict is a negative test verdict or a positive test verdict if Nr≠Ne or Nr=Ne, respectively, wherein Nr is a number of determined database processings in all of the retrieved records of transactions in a time frame of the test, wherein Ne is a number of expected database processings on the database in the time frame of the test, wherein Nr, Ne, or both Nr and Ne is at least 2, wherein the at least one action executed and tested during the test comprises a primary action and secondary actions executed in the background, wherein each expected database processing, each database processing of the one or more database processings, the primary action, and each secondary action is of a database processing type selected from the group consisting of create, read, insert, update, and delete.

2 . The method according to claim 1 , wherein the method further comprises prior to step a:

initiating, by the technical unit, the test in accordance with a specified criterion; and

writing, by the technical unit, an executed at least one action with respective criteria in form of records of transactions into the transaction log.

3 . The method according to claim 1 , wherein the method further comprises performing, by the technical unit, actions consisting of:

outputting the retrieved records of transactions retrieved from the transaction log, the test verdict, related transaction log data, and a message in accordance with the test verdict; and

transmitting, to a computing unit, the retrieved records of transactions, the test verdict, related transaction log data, and a message in accordance with the test verdict.

4 . A computer program product, comprising a non-transitory computer readable hardware storage device having computer readable program code stored therein, said program code executable by a processor of a computer system to implement a method for analyzing a transaction log stored in a database, wherein a computer readable storage medium comprises the database, wherein the computer readable storage medium is not a transitory signal, said method comprising steps of:

a. providing, by a technical unit selected from the group consisting of the processor of the computer system and an application-specific integrated circuit (ASIC), the transaction log and at least one filter criterion;

b. retrieving, by the technical unit from the transaction log stored on the computer readable storage medium, records of transactions meeting at least one filter criterion, wherein the transaction log comprises a plurality of records of transactions, and wherein each record of transaction in the transaction log comprises at least one action executed and tested during a test and at least one associated recorded criterion, wherein the at least one action of each retrieved record includes one or more database processings on the database; and

c. storing and/or displaying, by the technical unit, the retrieved records of transactions, a test verdict, and a message in accordance with the test verdict, wherein the test verdict is a negative test verdict or a positive test verdict if Nr≠Ne or Nr=Ne, respectively, wherein Nr is a number of determined database processings in all of the retrieved records of transactions in a time frame of the test, wherein Ne is a number of expected database processings on the database in the time frame of the test, wherein Nr, Ne, or both Nr and Ne is at least 2, wherein the at least one action executed and tested during the test comprises a primary action and secondary actions executed in the background, wherein each expected database processing, each database processing of the one or more database processings, the primary action, and each secondary action is of a database processing type selected from the group consisting of create, read, insert, update, and delete.

5 . The computer program product according to claim 4 , wherein the method further comprises prior to step a:

initiating, by the technical unit, the test in accordance with a specified criterion;

executing, by the technical unit, a plurality of computer instructions stored on a non-transitory computer readable storage medium to perform at least one action to be tested; and

writing, by the technical unit, the executed at least one action with respective criteria in form of records of transactions into the transaction log.

6 . The computer program product according to claim 4 , wherein the method further comprises performing, by the technical unit, actions consisting of:

outputting the retrieved records of transactions retrieved from the transaction log, the test verdict, related transaction log data, and a message in accordance with the test verdict;

transmitting, to a computing unit, the retrieved records of transactions, the test verdict, related transaction log data, and a message in accordance with the test verdict.

7 . A system comprising a technical unit, wherein the technical unit is hardware selected from the group consisting of a processor of a computer system and an application-specific integrated circuit (ASIC), wherein the technical unit is configured to implement a method for analyzing a transaction log stored in a database, wherein a computer readable storage medium comprises the database, wherein the computer readable storage medium is not a transitory signal, said method comprising steps of:

a. providing, by the technical unit, the transaction log and at least one filter criterion;

b. retrieving, by the technical unit from the transaction log stored on the computer readable storage medium, records of transactions meeting at least one filter criterion, wherein the transaction log comprises a plurality of records of transactions, and wherein each record of transaction in the transaction log comprises at least one action executed and tested during a test and at least one associated recorded criterion, wherein the at least one action of each retrieved record includes one or more database processings on the database; and

c. storing and/or displaying, by the technical unit, the retrieved records of transactions, a test verdict, and a message in accordance with the test verdict, wherein the test verdict is a negative test verdict or a positive test verdict if Nr≠Ne or Nr=Ne, respectively, wherein Nr is a number of determined database processings in all of the retrieved records of transactions in a time frame of the test, wherein Ne is a number of expected database processings on the database in the time frame of the test, wherein Nr, Ne, or both Nr and Ne is at least 2, wherein the at least one action executed and tested during the test comprises a primary action and secondary actions executed in the background, wherein each expected database processing, each database processing of the one or more database processings, the primary action, and each secondary action is of a database processing type selected from the group consisting of create, read, insert, update, and delete.

8 . The system according to claim 7 , wherein the method further comprises prior to step a:

initiating, by the technical unit, the test in accordance with a specified criterion;

executing, by the technical unit, a plurality of computer instructions stored on a non-transitory computer readable storage medium to perform at least one action to be tested; and

writing, by the technical unit, the executed at least one action with respective criteria in form of records of transactions into the transaction log.

9 . The system according to claim 7 , wherein the method further comprises performing, by the technical unit, actions consisting of:

outputting the retrieved records of transactions retrieved from the transaction log, the test verdict, related transaction log data, and a message in accordance with the test verdict;

transmitting, to a computing unit, the retrieved records of transactions, the test verdict, related transaction log data, and a message in accordance with the test verdict.

10 . The method according to claim 1 , wherein Nr≠Ne.

11 . The method according to claim 1 , wherein Nr=Ne.

12 . The computer program product according to claim 4 , wherein Nr≠Ne.

13 . The computer program product according to claim 4 , wherein Nr=Ne.

14 . The system according to claim 7 , wherein Nr≠Ne.

15 . The system according to claim 7 , wherein Nr=Ne.

16 . The method according to claim 1 , wherein the secondary actions executed in the background include a nested action.

17 . The method according to claim 1 , wherein the secondary actions executed in the background include recursive actions.

18 . The method according to claim 1 , wherein Nr>Ne.

19 . The method according to claim 1 , wherein the expected database processings pertain to only one table of the database, and wherein the determined database processings pertain to the only one table.