Generic data staging and loading using enhanced metadata and associated method

1. A system to reduce data loading time from one or more source systems, minimize any effect on the one or more source systems during data loading, and correct any error in the data, comprising:

a master data management (MDM) computer system comprising a processor and a memory, the MDM computer system configured to:

invoke batch data loading of data of one or more source systems into an unconstrained area of an input staging area to reduce data loading time from the one or more source systems and minimize any effect on the one or more source systems during data loading;

automatically select one or more staging and master interfaces based on metadata of the one or more source systems;

automatically select relational table structures based on semantic mapping metadata;

evaluate the data loaded into the input staging area by an error correction workflow;

move any error records into an error table;

correct any error records in the error table by a spooler within the error correction workflow;

load the data from the input staging area and corrected data from the error table into a master repository; and

load the data from the master repository into an output staging area.

2. The system of claim 1 , wherein the data of the one or more source systems is fed in bulk mode as a file into the input staging area.

3. The system of claim 1 , wherein the input staging area comprises a relational input staging interface.

4. The system of claim 3 , wherein the data of the one or more source systems is loaded into the input staging are through the relational input staging interface.

5. The system of claim 1 , wherein the MDM computer system models the batch data loading as a workflow.

6. The system of claim 1 , wherein the MDM computer system is further configured to:

invoke a data loading workflow for processing the data loaded into the input staging area.

7. The system of claim 6 , wherein the data load workflow is configured to execute one or more filter data business rules on the data loaded into the input staging area.

8. The system of claim 7 , wherein the one or more filter data business rules is configured to:

capture the data loaded into the input staging area that satisfies the one or more filter data business rules; and

move the data that satisfies the one or more filter data business rules into a temporary data table.

9. The system of claim 6 , wherein the data load workflow is configured to execute one or more auto correction rules on the data loaded into the input staging area.

10. The system of claim 6 , wherein the data load workflow is configured to enable one or more database constraints to:

detect any errors on the data loaded into the input staging area; and

move the detected errors into an error table.

11. The system of claim 6 , wherein the data load workflow is configured to execute one or more validation rules on the data loaded into the input staging area.

12. The system of claim 11 , wherein the one or more validation rules, is configured to:

evaluate the data loaded into the input staging area; and

move any error records into an error table.

13. The system of claim 6 , wherein the MDM computer system is further configured to:

create a net change table of the data loaded into the input staging area with reference data; and

spool the net change table of data into a file.

14. A method to reduce data loading time from one or more source systems, minimize any effect on the one or more source systems during data loading, and correct any error in the data, comprising:

invoking, by a processor of a master database management (MDM) computer system, batch data loading of data of one or more source systems into an unconstrained area of an input staging area to reduce data loading time from the one or more source systems and minimize any effect on the one or more source systems during data loading;

automatically selecting, by the processor, one or more staging and master interfaces based on metadata of the one or more source systems;

automatically selecting, by the processor, relational table structures based on semantic mapping metadata;

evaluating, by the processor, the data loaded into the input staging area by an error correction workflow;

moving, by the processor, any error records into an error table;

correcting, by the processor, any error records in the error table by a spooler within the error correction workflow;

loading, by the processor, the data from the input staging area and corrected data from the error table into a master repository; and

loading, by the processor, the data from the master repository into an output staging area.

15. The method of claim 14 , wherein the data of the one or more source systems is fed in bulk mode as a file into the input staging area.

16. The method of claim 14 , wherein the input staging area comprises a relational input staging interface.

17. The method of claim 16 , wherein the data of the one or more source systems is loaded into the input staging are through the relational input staging interface.

18. The method of claim 14 , wherein the MDM computer system models the batch data loading as a workflow.

19. The method of claim 14 , further comprising:

invoking a data loading workflow for processing the data loaded into the input staging area.

20. The method of claim 19 , wherein the data load workflow executes one or more filter data business rules on the data loaded into the input staging area.

21. The method of claim 20 , wherein the one or more filter data business rules comprise:

capturing the data loaded into the input staging area that satisfies the one or more filter data business rules; and

moving the data that satisfies the one or more filter data business rules into a temporary data table.

22. The method of claim 19 , wherein the data load workflow executes one or more auto correction rules on the data loaded into the input staging area.

23. The method of claim 19 , wherein the data load workflow further comprises:

enabling one or more database constraints;

detecting any errors on the data loaded into the input staging area; and

moving the detected errors into an error table.

24. The method of claim 19 , wherein the data load workflow executes one or more validation rules on the data loaded into the input staging area.

25. The method of claim 24 , wherein the one or more validation rules, comprise:

evaluating the data loaded into the input staging area; and

moving any error records into an error table.

26. The method of claim 19 , further comprising:

creating a net change table of the data loaded into the input staging area with reference data; and

spooling the net change table of data into a file.

27. A non-transitory computer-readable medium embodied with software to reduce data loading time from one or more source systems, minimize any effect on the one or more source systems during data loading, and correct any error in the data, the software when executed using one or more computers is configured to:

invoke batch data loading of data of one or more source systems into an unconstrained area of an input staging area of a master database management (MDM) computer system to reduce data loading time from the one or more source systems and minimize any effect on the one or more source systems during data loading;

automatically select one or more staging and master interfaces based on metadata of the one or more source systems;

automatically select relational table structures based on semantic mapping metadata;

evaluate the data loaded into the input staging area by an error correction workflow;

move any error records into an error table;

correct any error records in the error table by a spooler within the error correction workflow;

load the data from the input staging area and corrected data from the error table into a master repository; and

load the data from the master repository into an output staging area.

28. The non-transitory computer-readable medium of claim 27 , wherein the data of the one or more source systems is fed in bulk mode as a file into the input staging area.

29. The non-transitory computer-readable medium of claim 27 , wherein the input staging area comprises a relational input staging interface.

30. The non-transitory computer-readable medium of claim 29 , wherein the data of the one or more source systems is loaded into the input staging are through the relational input staging interface.

31. The non-transitory computer-readable medium of claim 27 , wherein the MDM computer system models the batch data loading as a workflow.

32. The non-transitory computer-readable medium of claim 27 , wherein the software is further configured to:

invoke a data loading workflow for processing the data loaded into the input staging area.

33. The non-transitory computer-readable medium of claim 32 , wherein the data load workflow is configured to execute one or more filter data business rules on the data loaded into the input staging area.

34. The non-transitory computer-readable medium of claim 33 , wherein the one or more filter data business rules is configured to:

capture the data loaded into the input staging area that satisfies the one or more filter data business rules; and

move the data that satisfies the one or more filter data business rules into a temporary data table.

35. The non-transitory computer-readable medium of claim 32 , wherein the data load workflow is configured to execute one or more auto correction rules on the data loaded into the input staging area.

36. The non-transitory computer-readable medium of claim 32 , wherein the data load workflow is configured to enable one or more database constraints to:

detect any errors on the data loaded into the input staging area; and

move the detected errors into an error table.

37. The non-transitory computer-readable medium of claim 32 , wherein the data load workflow is configured to execute one or more validation rules on the data loaded into the input staging area.

38. The non-transitory computer-readable medium of claim 37 , wherein the one or more validation rules, is configured to:

evaluate the data loaded into the input staging area; and

move any error records into an error table.

39. The non-transitory computer-readable medium of claim 32 , wherein the software is further configured to:

create a net change table of the data loaded into the input staging area with reference data; and

spool the net change table of data into a file.