US 12,067,026 B2
In-memory databases for integration testing of extraction, transformation, and/or loading jobs
Anil Konduru, Plano, TX (US); Amit Ramesh Deshpande, McKinney, TX (US); Dillon Forsberg, Aubrey, TX (US); Anvitha Banakal Sadananda, Lewisville, TX (US); and Jameskutty Mony, Lewisville, TX (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Aug. 19, 2022, as Appl. No. 17/891,554.
Prior Publication US 2024/0061853 A1, Feb. 22, 2024
Int. Cl. G06F 16/25 (2019.01); G06F 11/36 (2006.01); G06F 16/27 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 11/3684 (2013.01); G06F 16/27 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for testing instructions the method comprising:
receiving, from a storage, first database instructions comprising:
first extraction instructions configured to extract source content,
first transform instructions configured to transform the extracted source content, and
first load instructions configured to load the transformed source content as target content;
generating, in a memory of a computing system and from sampling, via a random number generator, a source database description and a target database description, a source database framework and a target database framework;
receiving first test information, wherein the first test information describes source database content and variability of the source database content;
generating, based on:
the source database framework,
the first test information, and
the random number generator,
a source database, wherein the source database comprises first records and first fields, and wherein the generating the source database comprises sampling, via the random number generator, the first test information to generate the first records;
generating, based on:
the source database,
the first database instructions, and
the target database framework,
a target database comprising target records and target fields;
validating at least a portion of the target database against a corresponding portion of the source database; and
generating, based on:
a successful validation of the at least the portion of the target database against the corresponding portion of the source database,
the variability of the source database content, and
the random number generator,
a modified source database,
wherein the modified source database comprises second records and second fields,
wherein the generating the modified source database comprises sampling, via the random number generator, the first test information to generate the second records, and
wherein the source database and the modified source database differ in at least one of records or fields.