DATA MAPPING DOCUMENT DESIGN SYSTEM
First Claim
1. A method for determining a data mapping to a target database, the method comprising:
- obtaining a view selection specifying an application view;
determining component applets of the application view;
determining target database columns in a target database that the component applets use to render the application view;
determining a first set of intermediate staging tables that are available to import source database data into the target database columns;
building a first intermediate mapping comprising target database column identifiers for the target database columns, intermediate staging table identifiers for the first set of intermediate staging tables, and mapping permissibility indicators between the first set of intermediate staging tables and the target database columns;
executing a search algorithm on the intermediate mapping to determine a first intermediate staging table selection for mapping the source database data to the target database columns in the target database through the first set of intermediate staging tables; and
creating a data mapping document specifying the first intermediate staging table selection for mapping the source database data to the target database columns.
2 Assignments
0 Petitions
Accused Products
Abstract
A data mapping document design system provides a market differentiator that facilitates creating the technical specification for migrating legacy databases. The system addresses the significant technical problems associated with the immensely labor intensive, complex, and error prone endeavor of manually creating the technical specification. The system not only achieves cost and time savings in clearly measurable aspects of data migration such as migration project cost and completion timelines, but also achieves improvements in other harder to measure and track areas, such as data quality, and achieves reductions in subsequently discovered data errors.
-
Citations
26 Claims
-
1. A method for determining a data mapping to a target database, the method comprising:
-
obtaining a view selection specifying an application view; determining component applets of the application view; determining target database columns in a target database that the component applets use to render the application view; determining a first set of intermediate staging tables that are available to import source database data into the target database columns; building a first intermediate mapping comprising target database column identifiers for the target database columns, intermediate staging table identifiers for the first set of intermediate staging tables, and mapping permissibility indicators between the first set of intermediate staging tables and the target database columns; executing a search algorithm on the intermediate mapping to determine a first intermediate staging table selection for mapping the source database data to the target database columns in the target database through the first set of intermediate staging tables; and creating a data mapping document specifying the first intermediate staging table selection for mapping the source database data to the target database columns. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A product comprising:
-
a machine-readable medium; and logic stored in the medium and operable to cause a processor to perform a data mapping analysis, the logic comprising; view analysis logic operable to determine component applets of an application view; applet analysis logic operable to determine target database columns that the component applets use to render the application view; staging table analysis logic operable to determine a first set of intermediate staging tables that are available to import source database data into the target database columns; intermediate mapping logic operable to build a first intermediate mapping comprising target database column identifiers for the target database columns, intermediate staging table identifiers for the first set of intermediate staging tables, and mapping permissibility indicators between the first set of intermediate staging tables and the target database columns; search logic operable to search the first intermediate mapping to determine a first intermediate staging table selection for mapping the source database data to the target database columns in the target database through the first set of intermediate staging tables; and file creation logic operable to create a data mapping document specifying the first intermediate staging table selection for mapping the source database data to the target database columns. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A product comprising:
-
a machine readable medium; and logic stored in the medium and operable to cause a processor to perform a data mapping analysis to target database columns, the logic comprising; intermediate mapping logic operable to build a first intermediate mapping comprising target database column identifiers for the target database columns, intermediate staging table identifiers for a first set of intermediate staging tables, and mapping permissibility indicators between the first set of intermediate staging tables and the target database columns; search logic operable to search the first intermediate mapping to determine a first intermediate staging table selection for mapping source database data to the target database columns through the first set of intermediate staging tables; and file creation logic operable to create a data mapping document specifying the first intermediate staging table selection for mapping the source database data to the target database columns. - View Dependent Claims (22, 23, 24, 25, 26)
-
Specification