Auditing tool for a legacy software modernization system

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.

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.