Computer-implemented method for analyzing a transaction log
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.
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.