IP Library Granted Patent US 12670144
Granted Patent B2
US 12670144 · App. 19/003,734 · Granted Jun 30, 2026

System and method for providing a consolidated data hub

Inventors: Mark Gregory Meaden (Pittsburgh, PA); Chaitanya Vejendla (Pittsburgh, PA)
Assignee: The PNC Financial Services Group, Inc.
G06F16/2282G06F16/2272
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 12670144
App. No.
19/003,734
Granted
Jun 30, 2026
Kind
B2
Abstract

The present disclosure is directed to a system for data consolidation. The system may include processors, servers, and/or storage devices. Processors in the system may be configurable to perform operations like importing data from, transforming the imported data into a plurality of tables, identifying tables comprising outlier attributes, and modifying the identified tables by normalizing or deleting corresponding attributes, Operations of the disclosed systems may also include performing a conformity check on the integration tables, generating two or more data structures arranging tables based on downstream modeling requirements, storing the two or more data structures in the single storage location, and provisioning the one or more data structures for downstream modeling.

Claims (57)

1 . A system for data consolidation comprising:

one or more processors; and

one or more storage devices storing instructions that, when executed, configure the one or more processors to perform operations including:

importing data from a plurality of sources to a single storage location through at least one iterative import job, wherein the at least one iterative import job updates a previously imported record during execution of the at least one iterative import job when subsequently imported data indicates one or more updated attributes for the previously imported record;

transforming the imported data into a plurality of tables based on a plurality of lifecycle entities;

identifying at least one table of the plurality of tables including outlier attributes;

modifying the identified at least one table by normalizing or deleting corresponding attributes;

after modifying the identified at least one table, performing a conformity check on the plurality of tables by executing a conformity job, the conformity job including a script that compares the plurality of tables to a control table including control data to ensure data completeness and adjusts attributes in the plurality of tables based on values in the control table;

generating two or more data structures by arranging at least a portion of the plurality of tables based on downstream modeling requirements, wherein the downstream modeling requirements specify at least one lifecycle entity of the plurality of lifecycle entities;

storing the two or more data structures in the single storage location; and

provisioning the two or more data structures for downstream modeling.

2 . The system of claim 1 , wherein the plurality of tables includes one or more integration or consumption tables.

3 . The system of claim 1 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via file transfer.

4 . The system of claim 1 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via application programming interface (API) controllers configured to enable the one or more processors to communicate with the plurality of sources.

5 . The system of claim 1 , wherein transforming the imported data into the plurality of tables includes generating one or more standardized objects that aggregate, integrate, or consolidate the imported data.

6 . The system of claim 1 , wherein the plurality of tables includes a plurality of object tables, each object table in the plurality of object tables associated with an indexing key and one or more attributes.

7 . The system of claim 1 , wherein the lifecycle entity includes at least one of application, static organization, default, transactional data reporting, origination, servicing, delinquency, loss mitigation, modification, or exiting.

8 . The system of claim 1 , wherein provisioning the two or more data structures for downstream modeling includes exposing the two or more data structures via at least one of an application programming interface (API), file transfer protocol (FTP), networked drive, server, hypertext transfer protocol (HTTP), memory location, or graphical user interface.

9 . The system of claim 1 , the operations further including building or executing a data model using at least one data structure of the provisioned two or more data structures.

10 . The system of claim 9 , wherein the data model includes a machine-learning model, an analytics model, or a regulatory model.

11 . A computer-implemented method comprising:

importing data from a plurality of sources to a single storage location through at least one iterative import job, wherein the at least one iterative import job updates a previously imported record during execution of the at least one iterative import job when subsequently imported data indicates one or more updated attributes for the previously imported record;

transforming the imported data into a plurality of tables based on a plurality of lifecycle entities;

identifying at least one table of the plurality of tables including outlier attributes;

modifying the identified at least one table by normalizing or deleting corresponding attributes;

after modifying the identified at least one table, performing a conformity check on the plurality of tables by executing a conformity job, the conformity job including a script that compares the plurality of tables to a control table including control data to ensure data completeness and adjusts attributes in the plurality of tables based on values in the control table;

generating two or more data structures by arranging at least a portion of the plurality of tables based on downstream modeling requirements, wherein the downstream modeling requirements specify at least one lifecycle entity of the plurality of lifecycle entities;

storing the two or more data structures in the single storage location; and

provisioning the two or more data structures for downstream modeling.

12 . The computer-implemented method of claim 11 , wherein the plurality of tables includes one or more integration or consumption tables.

13 . The computer-implemented method of claim 11 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via file transfer.

14 . The computer-implemented method of claim 11 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via application programming interface (API) controllers configured to enable communication with the plurality of sources.

15 . The computer-implemented method of claim 11 , wherein transforming the imported data into the plurality of tables includes generating one or more standardized objects that aggregate, integrate, or consolidate the imported data.

16 . The computer-implemented method of claim 11 , wherein the plurality of tables includes a plurality of object tables, each object table in the plurality of object tables associated with an indexing key and one or more attributes.

17 . The computer-implemented method of claim 11 , wherein the lifecycle entity includes at least one of application, static organization, default, transactional data reporting, origination, servicing, delinquency, loss mitigation, modification, or exiting.

18 . The computer-implemented method of claim 11 , wherein provisioning the two or more data structures for downstream modeling includes exposing the two or more data structures via at least one of an application programming interface (API), file transfer protocol (FTP), networked drive, server, hypertext transfer protocol (HTTP), memory location, or graphical user interface.

19 . The computer-implemented method of claim 11 , further comprising building or executing a data model using at least one data structure of the provisioned two or more data structures.

20 . The computer-implemented method of claim 19 , wherein the data model includes a machine-learning model, an analytics model, or a regulatory model.

21 . A non-transitory computer readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:

importing data from a plurality of sources to a single storage location through at least one iterative import job, wherein the at least one iterative import job updates a previously imported record during execution of the at least one iterative import job when subsequently imported data indicates one or more updated attributes for the previously imported record;

transforming the imported data into a plurality of tables based on a plurality of lifecycle entities;

identifying at least one table of the plurality of tables including outlier attributes;

modifying the identified at least one table by normalizing or deleting corresponding attributes;

after modifying the identified at least one table, performing a conformity check on the plurality of tables by executing a conformity job, the conformity job including a script that compares the plurality of tables to a control table including control data to ensure data completeness and adjusts attributes in the plurality of tables based on values in the control table;

generating two or more data structures by arranging at least a portion of the plurality of tables based on downstream modeling requirements, wherein the downstream modeling requirements specify at least one lifecycle entity of the plurality of lifecycle entities;

storing the two or more data structures in the single storage location; and

provisioning the two or more data structures for downstream modeling.

22 . The non-transitory computer readable medium of claim 21 ,

wherein the plurality of tables includes one or more integration or consumption tables.

23 . The non-transitory computer readable medium of claim 21 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via file transfer.

24 . The non-transitory computer readable medium of claim 21 , wherein the imported data includes data in multiple formats, and wherein the importing is performed via application programming interface (API) controllers configured to enable the one or more processors to communicate with the plurality of sources.

25 . The non-transitory computer readable medium of claim 21 , wherein transforming the imported data into the plurality of tables includes generating one or more standardized objects that aggregate, integrate, or consolidate the imported data.

26 . The non-transitory computer readable medium of claim 21 , wherein the plurality of tables includes a plurality of object tables, each object table in the plurality of object tables associated with an indexing key and one or more attributes.

27 . The non-transitory computer readable medium of claim 21 , wherein the lifecycle entity includes at least one of application, static organization, default, transactional data reporting, origination, servicing, delinquency, loss mitigation, modification, or exiting.

28 . The non-transitory computer readable medium of claim 21 , wherein provisioning the two or more data structures for downstream modeling includes exposing the two or more data structures via at least one of an application programming interface (API), file transfer protocol (FTP), networked drive, server, hypertext transfer protocol (HTTP), memory location, or graphical user interface.

29 . The non-transitory computer readable medium of claim 21 , the operations further including building or executing a data model using at least one data structure of the provisioned two or more data structures.

30 . The non-transitory computer readable medium of claim 29 , wherein the data model includes a machine-learning model, an analytics model, or a regulatory model.