Collaborative data mapping system

• US 10,417,198 B1
• Filed: 09/21/2016
• Issued: 09/17/2019
• Est. Priority Date: 09/21/2016
• Status: Active Grant

• Current Assignee: Wells Fargo Bank NA (Wells Fargo & Company)
• Original Assignee: Wells Fargo Bank NA (Wells Fargo & Company)
• Inventors: Simonelic, II, Kenneth J., Leo, Kathleen A., Cornish, Michael C., Kaniattu, Unnikrishnan R., Manikonda, Satya
• Primary Examiner(s): Arjomandi, Noosha
• Application Number:
  US15/271,552
• Time in Patent Office: 1,091 Days
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services

Abstract

A data mapping system provides a share, reusable and single mapping tool for mapping data and data lineage. The mapping system provides a version control functionality in the form of spreadsheet for tracking a plurality of mapping tasks that occur in parallel. The system allows multiple users to view the changes in mapping tasks, thereby improving data mapping visibility. Such visibility can significantly reduce conflicts between different mapping tasks that are independently performed by different teams or persons.

Claims

1. A method of mapping data, the method comprising:

obtaining a mapping specification accessible in a plurality of mapping projects, the mapping specification describing how data from a source information system maps to a target information system, wherein the plurality of mapping projects includes a data migration mapping project or a data integration mapping project;

enabling modification to at least one data element of the mapping specification accessible in the plurality of mapping projects;

tracking multiple users, each of the multiple users concurrently working on a respective different mapping project of the plurality of mapping projects, wherein the tracking includes;

determining whether the at least one data element is modified; and

in response to determining that the at least one data element is modified, providing a status indicator in the mapping specification visible to the multiple users, the status indicator being representative of the modification of the at least one data element.

2. The method of claim 1, further comprising:

displaying the mapping specification on a display screen; and

receiving a user input for modifying the at least one data element of the mapping specification.

3. The method of claim 1, further comprising:

storing the mapping specification having the at least one data element that is modified as a different version of the mapping specification.

4. The method of claim 1, further comprising:

in response to determining that the at least one data element is not modified, storing the mapping specification as the same version of the mapping specification.

5. The method of claim 1, wherein at least some of the plurality of mapping projects are independently performed by different users.

6. The method of claim 1, further comprising:

enabling access to different versions of the mapping specification.

7. The method of claim 1, wherein the mapping specification includes a spreadsheet having a plurality of data fields.

8. The method of claim 7, wherein the step of providing a status indicator includes:

modifying at least one graphical attribute of a data field associated with a data element modified from a previous version of the mapping specification.

9. The method of claim 8, wherein the step of modifying at least one graphical attribute of a data field includes:

changing a color of the data field, the color being different from colors of other data fields with unmodified data elements.

10. The method of claim 1, further comprising:

generating a mapping status window configured to present a status of the mapping specification.

11. The method of claim 10, wherein the status of the mapping specification includes an approval status of a particular version of the mapping specification.

12. The method of claim 1, further comprising:

generating a user interface configured to receive a user input of approval of a version of the mapping specification; and

presenting an approval status of the version of the mapping specification.

13. The method of claim 1, further comprising:

generating audit information, the audit information including a history of modification of the mapping specification.

14. The method of claim 13, wherein the audit information includes a date that a data element was created, a user that created the data element, a date that the data element was recently modified, and a user that recently modified the data element.

15. The method of claim 13, wherein the audit information includes a date that the mapping specification was created, a user that created the mapping specification, a date that the mapping specification was recently modified, and a user that recently modified the mapping specification.