IP Library › Granted Patent US 12,353,351
Granted Patent B2
US 12,353,351 · App. 18/315,080 · Granted Jul 8, 2025

Systems and methods for data translation of source data files

Inventors: David Newman (Walnut Creek, CA); Chao Chen (Short Hills, NJ); Cristian Cocos (Princeton, NJ); Steven Daryl McCullough (Ithaca, NY); Omar B. Khan (Richmond, VA)
Assignee: Wells Fargo Bank, N.A.
G06F16/116
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,353,351
App. No.
18/315,080
Filed
May 10, 2023
Granted
Jul 8, 2025
Kind
B2
Art Unit
2152
USPC
707/756
Abstract

A method may include accessing, using a processing unit, a source chain datafile formatted in a first format, the source chain datafile including data entries identifying linkages between a service provider, a service receiver, and a component provider, of an enterprise; forming, using the processing unit, initial knowledge graph tuples including subject, object, and predicate components based on the linkages; generating, using the processing unit, a staging knowledge graph storing the initial knowledge graph tuples; translating, using the processing unit, the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema; and storing, using the processing unit, the production knowledge graph tuples in a production knowledge graph.

Claims (53)

1. A method comprising:

accessing, using a processing unit, a first source chain datafile including data entries identifying linkages between a service provider, a service receiver, and a component provider, of an enterprise, the first source chain datafile covering a first period of time;

forming, using the processing unit, initial knowledge graph tuples including subject, object, and predicate components based on the linkages;

generating, using the processing unit, a staging knowledge graph storing the initial knowledge graph tuples;

translating, using the processing unit, the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema;

storing, using the processing unit, the production knowledge graph tuples in a production knowledge graph;

ingesting a second source chain datafile covering a second period of time into the production knowledge graph, the second period of time occurring before the first period of time;

inferring, using the production knowledge graph, material entities in the first source chain datafile based on a centrality metric for entities in the first source chain datafile;

inferring, using the production knowledge graph, material entities in the second source chain datafile based on a centrality metric for entities in the second source chain datafile;

executing a first data quality review on tuples in production knowledge graph originating from the first source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers;

executing a second data quality review on tuples in production knowledge graph originating from the second source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers; and

presenting a user interface on a computing device, the user interface including a visualization of a change between a result of the first data quality review and the second data quality review.

2. The method of claim 1 , wherein the source chain knowledge graph schema inherits a second knowledge graph data schema.

3. The method of claim 1 , wherein the first source chain datafile is formatted as a spreadsheet document format having columns and rows.

4. The method of claim 3 , wherein forming the initial knowledge graph tuples including subject, object, and predicate components based on the linkages includes:

generating a plurality of initial knowledge graph tuples from a row in the source chain datafile.

5. The method of claim 1 , wherein mapping, using the processing unit, the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema includes using a resource description framework to resource description framework process.

6. A non-transitory computer-readable medium comprising instructions, which when executed by a processing unit, configure the processing unit to perform operations comprising:

accessing a first source chain datafile formatted in a first format, the source chain datafile including data entries identifying linkages between a service provider, a service receiver, and a component provider, of an enterprise, the first source chain datafile covering a first period of time;

forming initial knowledge graph tuples including subject, object, and predicate components based on the linkages;

generating a staging knowledge graph storing the initial knowledge graph tuples;

translating the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema;

storing the production knowledge graph tuples in a production knowledge graph;

ingesting a second source chain datafile covering a second period of time into the production knowledge graph, the second period of time occurring before the first period of time;

inferring, using the production knowledge graph, material entities in the first source chain datafile based on a centrality metric for entities in the first source chain datafile;

inferring, using the production knowledge graph, material entities in the second source chain datafile based on a centrality metric for entities in the second source chain datafile;

executing a first data quality review on tuples in production knowledge graph originating from the first source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers;

executing a second data quality review on tuples in production knowledge graph originating from the second source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers; and

presenting a user interface on a computing device, the user interface including a visualization of a change between a result of the first data quality review and the second data quality review.

7. The non-transitory computer-readable medium of claim 6 , wherein the source chain knowledge graph schema inherits a second knowledge graph data schema.

8. The non-transitory computer-readable medium of claim 6 , wherein the first source chain datafile is formatted as a spreadsheet document format having columns and rows.

9. The non-transitory computer-readable medium of claim 8 , wherein forming the initial knowledge graph tuples including subject, object, and predicate components based on the linkages includes:

generating a plurality of initial knowledge graph tuples from a row in the source chain datafile.

10. The non-transitory computer-readable medium of claim 6 , wherein mapping the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema includes using a resource description framework to resource description framework process.

11. A system comprising:

a processing unit; and

a storage device comprising instructions, which when executed by the processing unit, configure the processing unit to perform operations comprising:

accessing a first source chain datafile formatted in a first format, the source chain datafile including data entries identifying linkages between a service provider, a service receiver, and a component provider, of an enterprise, the first source chain datafile covering a first period of time;

forming initial knowledge graph tuples including subject, object, and predicate components based on the linkages;

generating a staging knowledge graph storing the initial knowledge graph tuples;

translating the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema;

storing the production knowledge graph tuples in a production knowledge graph;

ingesting a second source chain datafile covering a second period of time into the production knowledge graph, the second period of time occurring before the first period of time;

inferring, using the production knowledge graph, material entities in the first source chain datafile based on a centrality metric for entities in the first source chain datafile;

inferring, using the production knowledge graph, material entities in the second source chain datafile based on a centrality metric for entities in the second source chain datafile;

executing a first data quality review on tuples in production knowledge graph originating from the first source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers;

executing a second data quality review on tuples in production knowledge graph originating from the second source chain datafile to identify a number of mismatches between service receivers designated as critical and non-material service providers; and

presenting a user interface on a computing device the user interface including a visualization of a change between a result of the first data quality review and the second data quality review.

12. The system of claim 11 , wherein the source chain knowledge graph schema inherits a second knowledge graph data schema.

13. The system of claim 11 , wherein the first source chain datafile is formatted as a spreadsheet document format having columns and rows.

14. The system of claim 13 wherein forming the initial knowledge graph tuples including subject, object, and predicate components based on the linkages includes:

generating a plurality of initial knowledge graph tuples from a row in the source chain datafile.

15. The system of claim 11 , wherein mapping the initial knowledge graph tuples into production knowledge graph tuples according to a source chain knowledge graph schema includes using a resource description framework to resource description framework process.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 13, 2023
From: NEWMAN, DAVID; CHEN, CHAO; COCOS, CRISTIAN; MCCULLOUGH, STEVEN DARYL; KHAN, OMAR B
To: WELLS FARGO BANK, N.A.
Reel/Frame 063928/0158 →
Continuity (1)
Related Publication 20240378176A1 · Nov 14, 2024
References Cited (25)
US 10452975B2 · Jacob · 2019 [cited by examiner]
US 10614086B2 · Tung et al. · 2020 [cited by applicant]
US 10977603B2 · Katsoulakos et al. · 2021 [cited by applicant]
US 11238084B1 · Newman · 2022 [cited by examiner]
US 20130013645A1 · Dias · 2013 [cited by examiner]
US 20170364570A1 · Jacob · 2017 [cited by examiner]
US 20170371881A1 · Reynolds · 2017 [cited by examiner]
US 20190303871A1 · Katsoulakos et al. · 2019 [cited by applicant]
US 20200272989A1 · Katsoulakos et al. · 2020 [cited by applicant]
US 20210173711A1 · Crabtree et al. · 2021 [cited by applicant]
US 20210182995A1 · Cella et al. · 2021 [cited by applicant]
US 20210216881A1 · Mccarthy et al. · 2021 [cited by applicant]
US 20210224929A1 · Bajaj et al. · 2021 [cited by applicant]
US 20210304044A1 · Nagarajan et al. · 2021 [cited by applicant]
US 20220044204A1 · Cella et al. · 2022 [cited by applicant]
US 20220229400A1 · Soler Garrido · 2022 [cited by examiner]
US 20230376496A1 · Jacob · 2023 [cited by examiner]
US 20240296080A1 · Portisch · 2024 [cited by examiner]
CA 3035213 · 2020 [cited by applicant]
CN 113836310 · 2021 [cited by applicant]
A. Keshavarzi and K. J. Kochut, “KGdiff: Tracking the Evolution of Knowledge Graphs,” 2020 IEEE 21st International Conference on Information Reuse and Integration for Data Science (IRI), Las Vegas, NV, USA, 2020, pp. 27… [cited by examiner]
Boxtel, L. Van, “Supporting decision making in a complex supply chain environment using a virtual knowledge graph”, Sep. 2020, Eindhoven University of TechnologyThesis, (Sep. 30, 2020), 93 pgs. [cited by applicant]
Zhang, Wanyue, “The Construction of a Domain Knowledge Graph and Its Application in Supply Chain Risk Analysis”, K.-M. Chao et al. (Eds.): ICEBE 2019, LNDECT 41, pp. 464-478, 2020.https: doi.org 10.1007.978-3-030-34986-… [cited by applicant]
U.S. Appl. No. 18/315,083, filed May 10, 2023, User Interfaces for Navigation of Knowledge Graph Source Data. [cited by applicant]
U.S. Appl. No. 18/315,092, filed May 10, 2023, Systems and Methods for Role Based Knowledge Graph Visualizations of Source Data Files. [cited by applicant]