IP Library Granted Patent US 11,755,613
Granted Patent B2
US 11,755,613 · App. 17/897,472 · Granted Sep 12, 2023

Streamlined data engineering

Inventors: Thomas Joseph (Old Bridge, NJ); John Abraham (Belle Mead, NJ)
Assignee: Bank of America Corporation
G06F16/258G06F16/113G06F16/211G06F16/215G06F16/2282G06F40/205
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 11,755,613
App. No.
17/897,472
Granted
Sep 12, 2023
Kind
B2
Abstract

A method for standardizing data input, data output and data manipulation at a data lake is provided. Methods include receiving a data transfer instruction comprising a seed file. Methods include parsing the seed file. Methods include validating the seed file. Methods include retrieving one or more data elements from one or more data sources as specified in the seed file. Methods include saving the retrieved data elements to a data lake. Methods include archiving the data elements at the data lake. Methods include receiving a schema from a network data mover client at an edge node at the data lake. Methods include creating a table to match the schema and validating the data elements using the schema. Methods include pushing the data elements into the table using the schema. Methods include saving the table that comprises the data elements in a shoreline edge node within the data lake.

Claims (23)

1. A system for standardizing data input, data output and data manipulation at a data lake, the system comprising:

a data transporter, executing on a processor coupled to a memory, said data transporter operable to:

receive a seed file, said seed file comprising a list of data elements and a data source location for each data element included in the list of data elements;

parse the seed file into a plurality of data elements and associated data source locations;

validate the seed file by validating that each data element, included in the plurality of data elements, is located in the data source location included in the plurality of data elements and associated data source locations;

retrieve the data elements from the plurality of data source locations; and

transfer the retrieved data elements from the data source locations to an edge node at a data lake;

a data ingester, operating on the processor coupled to the memory, said data ingester operable to:

receive a first schema configuration file for each of the data elements, said first schema configuration file comprising field definitions, validation rules and mappings;

label each of the data elements, located at the edge node at the data lake, based on the received first schema configuration file;

convert a format of each of the data elements, located at the edge node at the data lake, from a native format to a data lake accessible format;

execute a set of standardized validation rules on each of the data elements located at the edge node at the data lake;

store each of the labeled, converted and validated data elements at one or more locations the data lake based on the first schema configuration file; and

archive each of the labeled, converted and validated data elements at the data lake; and

a data chef, operating on the processor coupled to the memory, said data chef operable to:

execute a second schema configuration file on each of the stored data elements, said second schema configuration file operable to transform each of the data elements into integrated, conformed data elements, said second schema configuration file being received from a location other than the data source location, wherein the data elements on which were executed the second schema configuration file qualifies for a first level of curated data; and

execute one or more recipes on each of the stored data elements, the one or more recipes manipulating each of the data elements into consumable data elements that are specifically consumable by one or more end users, the one or more recipes being received from one or more end users, wherein the data elements on which were executed the one or more recipes qualifies for a second level of curated data.

2. The system of claim 1 , wherein each data element and the data source location included in the list of data elements is included on a separate line of the seed file.

3. The system of claim 1 , wherein the second schema configuration file is received at the data lake from the one or more end users.

4. The system of claim 1 , wherein the data chef operates on a copy of the labeled, converted and validated data elements.

5. The system of claim 4 , wherein the data chef executes a plurality of recipes, each of the plurality of recipes is executed on a copy of the labeled, converted and validated data elements, each of the plurality of recipes is specific to an end user.

6. The system of claim 1 , wherein the execution of the second schema configuration file and the execution of the one or more recipes comprises generating a data format map, said data format map instructing the locations of the labeled, converted and validated data elements stored in the data lake, and manipulations to accommodate end user specifications.

7. The system of claim 6 , wherein the system further comprises a data output module, and when an end user, from the one or more end users, transmits a data request to the system, the data output module retrieves the requested data elements, formats the requested data elements based on the data format map and delivers the requested, formatted data elements to the end user.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 29, 2022
From: JOSEPH, THOMAS; ABRAHAM, JOHN
To: BANK OF AMERICA CORPORATION
Reel/Frame 060925/0344 →
Continuity (2)
Continuation 17353878 · Jun 22, 2021
Related Publication 20220414118A1 · Dec 29, 2022