Patent ID: 11934396
Assignee: BANK OF AMERICA CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method for reconciling data in a big data environment, the method comprising:
receiving, using a lazy evaluation algorithm, a first data set and a second data set for reconciliation, the lazy evaluation algorithm delays loading data included in the first data set and the second data set until the data is demanded by a loading algorithm;
identifying a first set of metadata associated with the first data set;
identifying a second set of metadata associated with the second data set;
comparing the first set of metadata to the second set of metadata to obtain a subset of data found within the first data set and a subset of data found within the second data set that are joinable;
dynamically constructing one or more structured query language (SQL) queries to identify any discrepancies between the first data set and the second data set; and
executing the one or more SQL queries that identify any discrepancies between the first data set and the second data set.