Data modernization system for legacy software

• US 7,996,413 B2
• Filed: 12/21/2007
• Issued: 08/09/2011
• Est. Priority Date: 12/21/2007
• Status: Active Grant

• Current Assignee: NTT DATA Canada, Inc. (Nippon Telegraph and Telephone Corporation)
• Original Assignee: MAKE Technologies, Inc. (Dell Technologies Inc.)
• Inventors: Green, David John, White, Michael E. F., Cotichini, Christian
• Primary Examiner(s): Lu; Kuen S
• Assistant Examiner(s): Rayyan; Susan F
• Application Number:
  US11/963,671
• Publication Number:
  US 20090164491A1
• Time in Patent Office: 1,327 Days
• Field of Search: 707/810, 707/687, 707/691
• US Class Current: 707/756
• CPC Class Codes: G06F 16/214 Database migration support

Abstract

A database modernization system and method is disclosed. One example embodiment comprises a method for receiving a record stored as a source physical data model, parsing the source physical data model into a source logical data model, wherein the source logical data model includes semantic information from the record, transforming 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, and storing the destination logical data model in a destination physical data model. In this manner, a destination physical data model may be stored in a relational database management system on a per record basis.

Claims

1. A database modernization method, comprising:

receiving a record stored as a source physical data model;

parsing the source physical data model into a source logical data model based on a rule set, wherein the source logical data model includes semantic information from the record;

transforming the source logical data model to a destination logical data model independent of a source or a destination record physical implementation based on the rule set, wherein the destination logical data model includes at least a portion of the semantic information from the record;

storing 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 transforming of the source logical data model to the destination logical data model is successful, then validating database modernization in an audit log; and

if transformation of the source logical data model to the destination logical data model is unsuccessful, then;

invalidating database modernization in the audit log,

correcting referential integrity violations,

reporting a plurality of runtime statistics, the plurality of runtime statistics including at least the audit log,

re-processing the record after the rule set has been adjusted, and

adjusting the rule set to improve subsequent database modernization based on the plurality of runtime statistics.

2. The database modernization method of claim 1, wherein invalidating further comprises storing at least one violation if the record could not be modernized, wherein the at least one violation prevented the record from being modernized.

3. The database modernization method of claim 1, further comprising storing a unique identifier in the source logical data model.

4. The database modernization method of claim 3, wherein validating further comprises attaching the unique identifier to the record and creating a success log entry if the record was successfully modernized, wherein the log entry includes the unique identifier.

5. The database modernization method of claim 3, wherein invalidating further comprises attaching the unique identifier to the record and creating a violation log entry if the record was not successfully modernized, wherein the violation log entry includes the unique identifier and a violation log type.

6. The database modernization method of claim 1, further comprising transforming multiple distinct sets of data in the record from the source logical data model to the destination logical data model at the same time.

7. The database modernization method of claim 6, wherein a first distinct set of data is a first field in the record, and a second distinct set of data is a second field in the record.

8. 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.

9. The non-transitory computer-readable medium of claim 8, further comprising instructions executable to invalidate database modernization by storing at least one violation if the record could not be modernized, wherein the at least one violation prevented the record from being modernized.

10. The non-transitory computer-readable medium of claim 8, further comprising instructions executable to store a unique identifier in the source logical data model.

11. The non-transitory computer-readable medium of claim 10, further comprising instructions executable to validate database modernization by attaching the unique identifier to the record and creating a success log entry if the record was successfully modernized, wherein the success log entry includes the unique identifier.

12. The non-transitory computer-readable medium of claim 10, further comprising instructions executable to invalidate database modernization by attaching the unique identifier to the record and creating a violation log entry if the record was not successfully modernized, wherein the violation log entry includes the unique identifier and a violation log type.

13. The non-transitory computer-readable medium of claim 8, further comprising instructions executable to transform multiple distinct sets of data in the record from the source logical data model to the destination logical data model at the same time.

14. The non-transitory computer-readable medium of claim 13, wherein a first distinct set of data is a first field in the record, and a second distinct set of data is a second field in the record.

15. 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.

16. The database modernization system of claim 15, wherein the transformer is further configured to invalidate database modernization by storing at least one violation if the record could not be modernized, wherein the at least one violation prevented the record from being modernized.

17. The database modernization system of claim 15, wherein the loader is further configured to store a unique identifier in the source logical data model.

18. The database modernization system of claim 17, wherein the transformer is further configured to validate database modernization by attaching the unique identifier to the record and creating a success log entry if the record was successfully modernized, wherein the success log entry includes the unique identifier.

19. The database modernization system of claim 17, wherein the transformer is further configured to invalidate database modernization by attaching the unique identifier to the record and creating a violation log entry if the record was not successfully modernized, wherein the violation log entry includes the unique identifier and a violation log type.

20. The database modernization system of claim 15, wherein the transformer is further configured to transform multiple distinct sets of data in the record from the source logical data model to the destination logical data model at the same time.

21. The database modernization system of claim 20, wherein a first distinct set of data is a first field in the record, and a second distinct set of data is a second field in the record.