# US 11,907,184 B1 · Collaborative data mapping system > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,907,184 B1 - Document ID: US11907184B1 - Status: Granted - Kind: B1 - Application number: 18/162,240 - Filed: 2023-01-31 - Granted: 2024-02-20 - Earliest claimed: 2016-09-21 - Assignees: Wells Fargo Bank, N.A. - Applicants: Wells Fargo Bank, N.A. - Inventors: Kenneth J. Simonelic, II; Kathleen A. Leo; Michael C. Cornish; Unnikrishnan R. Kaniattu; Satya Manikonda - Web page: https://patentgrep.com/patent/US11907184B1 ## CPC - G06F 16/211: {Schema design and management} - G06Q 10/101: Collaborative creation, e.g. joint development of products or services - G06F 16/176: Support for shared access to files; File sharing support - G06F 16/219: {Managing data history or versioning (querying versioned data G06F16/2474; querying temporal data G06F16/2477)} - G06F 16/2365: {Ensuring data consistency and integrity} - G06F 16/248: Presentation of query results - G06F 16/25: Integrating or interfacing systems involving database management systems - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## 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 ### Claim 1 A method for mapping data, the method comprising: obtaining, by a computing device, a plurality of versions of a mapping specification, the mapping specification describing how data from a source information system maps to a destination information system; merging, by the computing device, the plurality of versions of the mapping specification to generate a master version of the mapping specification, wherein the master version of the mapping specification is created by merging a first version of the plurality of versions of the mapping specification with a second version of the plurality of versions of the mapping specification; identifying, by the computing device, any conflicts between data elements in the master version of the mapping specification based on one or more predetermined business rules; generating, by the computing device, a severity score of the conflicts, wherein the severity score indicates a significance of the conflicts and whether the conflicts should be fixed; and generating, by the computing device, an alert based upon the conflicts. ### Claim 2 (depends on 1) The method of claim 1, further comprising identifying a nature of the conflicts between the data elements in the master version of the mapping specification. ### Claim 3 (depends on 1) The method of claim 1, wherein obtaining the plurality of versions includes: obtaining the first version associated with a first mapping project of a first user; and obtaining the second version associated with a second mapping project of a second user. ### Claim 4 (depends on 1) The method of claim 1, further comprising generating a user interface including information on the mapping specification. ### Claim 5 (depends on 4) The method of claim 4, wherein the user interface includes a rule column listing the one or more predetermined business rules. ### Claim 6 (depends on 5) The method of claim 5, wherein the user interface includes a filters column programmed to filter data values. ### Claim 7 (depends on 6) The method of claim 6, wherein the filter data values are based on types, fields, and other elements based on business rules. ### Claim 8 A system for mapping data, the system comprising: a processor; and memory encoding instructions which, when executed by the processor, causes the system to: obtain, by the processor, a plurality of versions of a mapping specification, the mapping specification describing how data from a source information system maps to a destination information system; merge, by the processor, the plurality of versions of the mapping specification to generate a master version of the mapping specification, wherein the master version of the mapping specification is created by merging a first version of the plurality of versions of the mapping specification with a second version of the plurality of versions of the mapping specification; identify, by the processor, any conflicts between data elements in the master version of the mapping specification based on one or more predetermined business rules; generate, by the processor, a severity score of the conflicts, wherein the severity score indicates a significance of the conflicts and whether the conflicts should be fixed; and generate, by the processor, an alert based upon the conflicts. ### Claim 9 (depends on 8) The system of claim 8, comprising further instructions which, when executed by the processor, causes the system to identify a nature of the conflicts between the data elements in the master version of the mapping specification. ### Claim 10 (depends on 8) The system of claim 8, wherein to obtain the plurality of versions includes to: obtain the first version associated with a first mapping project of a first user; and obtain the second version associated with a second mapping project of a second user. ### Claim 11 (depends on 8) The system of claim 8, comprising further instructions which, when executed by the processor, causes the system to generate a user interface including information on the mapping specification. ### Claim 12 (depends on 11) The system of claim 11, wherein the user interface includes a rule column listing the one or more predetermined business rules. ### Claim 13 (depends on 12) The system of claim 12, wherein the user interface includes a filters column programmed to filter data values. ### Claim 14 (depends on 13) The system of claim 13, wherein the filter data values are based on types, fields, and other elements based on business rules.