Data modernization system for legacy software

A non-transitory computer-readable medium comprising computer-executable instructions for modernizing a database, the instructions being executable by a modernization system to:

• receive a record stored as a source physical data model;
• parse the source physical data model into a source logical data model, wherein the source logical data model includes semantic information from the record;
• transform the source logical data model to a destination logical data model independent of a source or a destination record physical implementation, wherein the destination logical data model includes at least a portion of the semantic information from the record;
• store the destination logical data model in a destination physical data model, wherein the destination physical data model is stored in a relational database management system on a per record basis;
• if database modernization is successful, then validate database modernization in an audit log;
• and
• if database modernization is unsuccessful, then:
• invalidate database modernization in the audit log,
• correct referential integrity violations,
• report a plurality of runtime statistics, the plurality of runtime statistics including at least the audit log,
• re-process the record after the rule set has been adjusted, and
• receive instructions to adjust the rule set to improve subsequent database modernization based on the plurality of runtime statistics.

A database modernization system, comprising:

• a computer processor;
• a loader to receive a record stored as a source physical data model, and to parse the source physical data model into a source logical data model,
• wherein the source logical data model includes semantic information from the record;
• a transformer coupled to the loader, the transformer to receive the source logical data model from the loader, wherein the transformer is configured to:
• transform the source logical data model to a destination logical data model independent of a source or a destination record physical implementation,
• wherein the destination logical data model includes at least a portion of the semantic information from the record,
• if database modernization is successful,
• then validate database modernization in an audit log, and
• if database modernization is unsuccessful, then:
• invalidate database modernization in the audit log,
• correct referential integrity violations,
• report a plurality of runtime statistics, the plurality of runtime statistics including at least the audit log,
• receive instructions to adjust the rule set to improve subsequent database modernization based on the plurality of runtime statistics, and
• re-process the record after the rule set has been adjusted;
• and
• a storer coupled with the transformer, the storer to receive the destination logical data model from the transformer and configured to store the destination logical data model in a destination physical data model in a relational database management system on a per record basis.