Data mapping design tool

• US 7,801,908 B2
• Filed: 12/31/2007
• Issued: 09/21/2010
• Est. Priority Date: 09/19/2007
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services GmbH (Accenture PLC)
• Inventors: Zachariah, Alex George
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): LODHI, ANDALIB FT
• Application Number:
  US11/967,461
• Publication Number:
  US 20090077114A1
• Time in Patent Office: 995 Days
• Field of Search: None
• US Class Current: 707/763
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A data mapping tool facilitates database engineer interaction with a data mapping document design system that facilitates creating the technical specification for migrating legacy databases. The data mapping tool provides a flexible selection of mapping modes, including a fully automated mode that resolves conflicts that may occur during the creation of the technical specification. The available modes also allow the database engineer to fully specify the intermediate staging tables used in the technical specification, and to request an partially automatic and partially interactive role over the execution of the data mapping document design system.

Claims

1. A product comprising:

a machine readable medium; and

data mapping tool logic stored in the medium for execution by a processor, the data mapping tool logic comprising;

an application view selection interface operable to obtain an application view selection supported by a target database;

a database mapping mode selection interface operable to accept a mapping mode selection between multiple different mapping modes, where the multiple different mapping modes comprise an interactive mapping mode;

mapping execution logic operable to;

initiate, based on the mapping mode selection, execution of a data mapping analysis from intermediate staging tables to target database columns in the target database to determine an intermediate staging table selection for mapping the target database columns;

mapping result analysis logic operable to determine whether a conflict exists between a first intermediate staging table and a second intermediate staging table, among the intermediate staging tables, for mapping the target database columns;

a conflict resolution interface operable to obtain a manual conflict resolution input, when the mapping mode selection specifies the interactive mapping mode; and

a data mapping document completion interface operable to report creation of a data mapping document based on the intermediate staging table selection.

2. The product of claim 1, where:

the multiple different mapping modes comprise a manual mapping mode; and

where the data mapping tool logic further comprises;

an intermediate staging table selection interface operable to display the intermediate staging table selection and accept a manual selection of intermediate staging tables from among the intermediate staging table selection for mapping the target database columns.

3. The product of claim 1, where:

the multiple different mapping modes comprise an automatic mapping mode; and

where the mapping execution logic is further operable to specify the automatic mapping mode for the data mapping analysis.

4. The product of claim 1, where the data mapping tool logic further comprises:

a configuration interface operable to accept a data source name specifying the target database and establish a connection to the target database using the data source name.

5. The product of claim 4, where the configuration interface is further operable to accept a username and password for accessing the target database and establish a connection to the target database using the data source name, username, and password.

6. The product of claim 1, where the data mapping document comprises an applet specification of a component applet of an application view specified by the application view selection.

7. The product of claim 6, where the applet specification further comprises a base table specification comprising the target database columns that provide data for component applet.

8. The product of claim 7, where the applet specification further comprises an intermediate staging table specification for the target database columns for mapping source database data to the target database columns through the intermediate staging tables in the intermediate staging table specification.

9. The product of claim 1, where the data mapping document comprises:

an applet specification of a first component applet and a second component applet of an application view specified by the application view selection; and

an applet relation specification of an applet relation between the first component applet and the second component applet.

10. A method for facilitating generation of a data mapping document, the method comprising:

generating an application view selection interface operable to obtain an application view selection supported by a target database;

generating a database mapping mode selection interface operable to accept a mapping mode selection between multiple different mapping modes, where the multiple different mapping modes comprise an interactive mapping mode;

initiating, based on the mapping mode selection, execution of a data mapping analysis from intermediate staging tables to target database columns in the target database to determine an intermediate staging table selection for mapping the target database columns;

determining whether a conflict exists between a first intermediate staging table and a second intermediate staging table, among the intermediate staging tables, for mapping the target database columns;

generating a conflict resolution interface operable to obtain a manual conflict resolution input, when the mapping mode selection specifies the interactive mapping mode; and

generating a data mapping document completion interface operable to report creation of a data mapping document based on the intermediate staging table selection.

11. The method of claim 10, where:

the multiple different mapping modes comprise a manual mapping mode; and

further comprising;

generating an intermediate staging table selection interface operable to display the intermediate staging table selection and accept a manual selection of intermediate staging tables from among the intermediate staging table selection for mapping the target database columns.

12. The method of claim 10, where:

the multiple different mapping modes comprise an automatic mapping mode; and

further comprising;

specifying the automatic mapping mode to the data mapping analysis.

13. The method of claim 10, where generating a data mapping document completion interface comprises:

generating a data mapping document completion interface operable to report creation of a data mapping document comprising;

an applet specification of a component applet of an application view specified by the application view selection;

a base table specification comprising the target database columns that provide data for component applet; and

an intermediate staging table specification for the target database columns for mapping source database data to the target database columns through the intermediate staging tables in the intermediate staging table specification.

14. A data mapping tool comprising:

a memory comprising;

data mapping tool logic stored in the medium for execution by a processor, the data mapping tool logic comprising;

an application view selection interface operable to obtain an application view selection supported by a target database;

a database mapping mode selection interface operable to accept a mapping mode selection between multiple different mapping modes, where the multiple different mapping modes comprise an interactive mapping mode;

mapping execution logic operable to;

initiate, based on the mapping mode selection, execution of a data mapping analysis from intermediate staging tables to target database columns in the target database to determine an intermediate staging table selection for mapping the target database columns;

mapping result analysis logic operable to determine whether a conflict exists between a first intermediate staging table and a second intermediate staging table, among the intermediate staging tables, for mapping the target database columns;

a conflict resolution interface operable to obtain a manual conflict resolution input, when the mapping mode selection specifies the interactive mapping mode; and

a data mapping document completion interface operable to report creation of a data mapping document based on the intermediate staging table; and

a processor coupled to the memory and operable to execute the data mapping tool logic.

15. The data mapping tool of claim 14, where:

the multiple different mapping modes comprise a manual mapping mode; and

where the data mapping tool logic further comprises;

an intermediate staging table selection interface operable to display the intermediate staging table selection and accept a manual selection of intermediate staging tables from among the intermediate staging table selection for mapping the target database columns.

16. The data mapping tool of claim 14, where:

the multiple different mapping modes comprise an automatic mapping mode; and

where the mapping execution logic is further operable to specify the automatic mapping mode for the data mapping analysis.

17. The data mapping tool of claim 14, where the data mapping document comprises an applet specification of a component applet of an application view specified by the application view selection, a base table specification comprising the target database columns that provide data for component applet, and an intermediate staging table specification for the target database columns for mapping source database data to the target database columns through the intermediate staging tables in the intermediate staging table specification.