Auditing tool for a legacy software modernization system
First Claim
1. A database modernization auditing method executed on a computing device, comprising:
- loading a source data object from a source data file;
transforming the source data object into a target data object according to a rule set, wherein transforming the source data object into the target data object further includes parsing at least a portion of the source data object into semantic information, transforming the semantic information into the target data object, and logging one or more violations in an audit trail, the audit trail configured to log a set of distinct audit units created during a data modernization run, the rule set including at least one of a record-level transformation rule, a field level rule, a source expression, and a caster;
identifying one or more instances of a first type of violation that occurs while parsing at least a portion of the source data object to the semantic information;
reporting to the audit trail one or more first audit log entries in response to the one or more instances of the first type of violation that occurs while parsing at least a portion of the source data object to the semantic information, wherein the violations of the first type are logged in a distinct audit unit of the set, which contains a unique identifier that is used to identify the source data object related to the distinct audit unit;
identifying one or more instances of a second type of violation that occurs while transforming the semantic information into the target data object, the second type of violation different than the first type of violation;
reporting to the audit trail one or more second audit log entries in response to the one or more instances of the second type of violation that occurs while transforming the semantic information into the target data object, wherein the violations of the second type are logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit; and
displaying audit statistics pertaining to a specific transformation data run compiled from occurrences of the first audit log entries and the second audit log entries reported to the audit trail, the rule set further including more than one of a record-level transformation rule, a field level rule, a source expression, and a caster, the method further comprising generating an audit log entry corresponding to a plurality of violations including one or more of the first type of violation and the type of second violation, wherein an audit log including the audit log entries can be viewed at a level of each rule in the rule set.
3 Assignments
0 Petitions
Accused Products
Abstract
A database modernization auditing system and method is disclosed. One embodiment comprises a method for loading a legacy data object, transforming the legacy data object into a modern data object according to a rule set, wherein transforming the legacy data object into the modern data object further includes abstracting at least a portion of the legacy data object into semantic information and transforming the semantic information into the modern data object, and generating an audit log entry corresponding to an error that occurs while transforming the semantic information into the modern data object, wherein the audit log entry contains a unique identifier that relates the audit log entry with the legacy data object.
-
Citations
17 Claims
-
1. A database modernization auditing method executed on a computing device, comprising:
-
loading a source data object from a source data file; transforming the source data object into a target data object according to a rule set, wherein transforming the source data object into the target data object further includes parsing at least a portion of the source data object into semantic information, transforming the semantic information into the target data object, and logging one or more violations in an audit trail, the audit trail configured to log a set of distinct audit units created during a data modernization run, the rule set including at least one of a record-level transformation rule, a field level rule, a source expression, and a caster; identifying one or more instances of a first type of violation that occurs while parsing at least a portion of the source data object to the semantic information; reporting to the audit trail one or more first audit log entries in response to the one or more instances of the first type of violation that occurs while parsing at least a portion of the source data object to the semantic information, wherein the violations of the first type are logged in a distinct audit unit of the set, which contains a unique identifier that is used to identify the source data object related to the distinct audit unit; identifying one or more instances of a second type of violation that occurs while transforming the semantic information into the target data object, the second type of violation different than the first type of violation; reporting to the audit trail one or more second audit log entries in response to the one or more instances of the second type of violation that occurs while transforming the semantic information into the target data object, wherein the violations of the second type are logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit; and displaying audit statistics pertaining to a specific transformation data run compiled from occurrences of the first audit log entries and the second audit log entries reported to the audit trail, the rule set further including more than one of a record-level transformation rule, a field level rule, a source expression, and a caster, the method further comprising generating an audit log entry corresponding to a plurality of violations including one or more of the first type of violation and the type of second violation, wherein an audit log including the audit log entries can be viewed at a level of each rule in the rule set. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer-readable storage device comprising computer-executable instructions for auditing a database modernization, the instructions being executable by a computing device of a modernization system to:
-
load a source data object from a source data file; transform the source data object into a target data object according to a rule set, wherein to transform the source data object into the target data object further includes instructions to parse at least a portion of the source data object into semantic information, instructions to transform the semantic information into the target data object, and instructions to log violations in an audit trail, the audit trail configured to log a set of distinct audit units created during a data modernization run; identify one or more instances of a first type of violation in parsing at least a portion of the source data object to the semantic information; report to the audit trail one or more first audit log entries in response to the one or more instances of the first type of violation in parsing at least a portion of the source data object to the semantic information, wherein the violations of the first type are logged in a distinct audit unit of the set, which contains a unique identifier that is used to identify the source data object related to the distinct audit unit; identify one or more instances of a second type of violation in transforming the semantic information into the target data object, the second type of violation different than the first type of violation; report to the audit trail one or more second audit log entries in response to the one or more instances of the second type of violation in transforming the semantic information into the target data object, the violations of the second type are is logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit; identify one or more instances of a third type of violation in response to a foreign key violation, wherein a dangling foreign key is generated which associates the target data object with a data element that does not exist in the source data file, the third type of violation different from each of the first type of violation and the second type of violation; report to the audit trail one or more third audit log entries in response to the one or more instances of the third type of violation, wherein the violations of the third type are logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit; and displaying audit statistics pertaining to a specific transformation data run compiled from occurrences of the first audit log entries, the second audit log entries, and the third audit log entries reported to the audit trail. - View Dependent Claims (7, 8, 9, 10, 11)
-
-
12. A database modernization auditing system, comprising a computing device configured to execute a conversion engine having a graphical user interface, the conversion engine including:
-
a loader to provide a source data object from a source data file; a transformer coupled with the loader, the transformer configured to, receive the source data object from the loader and transform the source data object into a data object according to a rule set, parse at least a portion of the source data object into semantic information and transform the semantic information into the target data object, log violations in an audit trail, the audit trail configured to log a set of distinct audit units created during a data modernization run, wherein the transformer, to log the violations, is further configured to; identify one or more instances of a first type of violation in parsing at least a portion of the source data object to the semantic information, report to the audit trail one or more first audit log entries in response to the one or more instances of the first type of violation in parsing at least a portion of the source data object to the semantic information, wherein the violations of the first type are logged in a distinct audit unit of the set, which contains a unique identifier that is used to identify the source data object related to the distinct audit unit, identify one or more instances of a second type of violation in transforming the semantic information into the target data object, the second type of violation different than the first type of violation, report to the audit trail one or more second audit log entries in response to the one or more instances of the second type of violation in transforming the semantic information into the target data object, wherein the violations of the second type are logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit, identify one or more instances of a third type of violation in response to a foreign key violation, wherein a dangling foreign key is generated which associates the target data object with a data element that does not exist in the source data file, the third type of violation different from each of the first type of violation and the second type of violation, report to the audit trail one or more third audit log entries in response to the one or more instances of the third type of violation, wherein the third type of violation is logged in the distinct audit unit containing the unique identifier that is used to identify the source data object related to the distinct audit unit, and compile data for occurrences of each of the first type of violation, the second type of violation, and the third type of violation reported to the audit trail in order to display audit statistics, the audit statistics comprising one or more of key index performance, loader efficiency, log messages, and referential integrity results. - View Dependent Claims (13, 14, 15, 16, 17)
-
Specification