US 11,232,017 B2Granted

System for refreshing and sanitizing testing data in a low-level environment

AssigneeBank of America Corporation

InventorsJustin Daniel Kelly, Philip Wayne Adams, David William Crowe

Life of this patent

Estimating the term…

Loading patent…

Abstract

Embodiments of the present invention provide a system for refreshing data within the testing environment by sanitizing production data. In particular, the system may process real-world data obtained in the production environment and automatically replace sensitive or confidential information with realistic substitute data, then provide the sanitized data to the systems within the low level testing environment. The system may account for differences in table schema amongst a plurality of disparate databases within the production environment and the low level environment, thereby allowing the system to provide sanitized data only to the extent that it is needed for testing purposes. Furthermore, the system selectively provides sanitized test data on an as-needed basis, removing the need to continuously generate testing data.

Claims20

Dependent claims

A system for sanitizing and refreshing testing data, comprising:

a production computer system comprising a processor, a memory device, and a communication device, and a production application stored in the memory device, the production application comprising a production data table comprising production data, and a sanitization table comprising substitute data, wherein the production application when executed by the processor causes the processor to:
detect a data refresh request within a control table of a low level environment computer system;
read a set of table metadata from a system table of the low level environment computer system, wherein the set of table metadata comprises a low level environment table schema;
compare fields of the low level environment table schema of the system table with fields of a production data table schema of the production data table;
create a copy of production data correlating to the set of table metadata;
identify, using the sanitization table, fields requiring sanitization;
based on comparing the fields of the low level environment table schema with the fields of the production data table schema, selectively replace the fields requiring sanitization using the substitute data;
and
write the copy of the production data into a target table of the low level environment computer system.

6 more elements

A computer program product for sanitizing and refreshing testing data, the computer program product comprising at least one non-transitory computer readable medium having computer-readable program code portions embodied therein, the computer-readable program code portions comprising executable portions configured for:

detecting a data refresh request within a control table of a low level environment computer system;
reading a set of table metadata from a system table of the low level environment computer system, wherein the set of table metadata comprises a low level environment table schema;
comparing fields of the low level environment table schema of the system table with fields of a production data table schema of a production data table;
creating a copy of production data correlating to the set of table metadata;
identifying, using a sanitization table, fields requiring sanitization;
based on comparing the fields of the low level environment table schema with the fields of the production data table schema, selectively replacing the fields requiring sanitization using substitute data;
and
writing the copy of the production data into a target table of the low level environment computer system.

5 more elements

A computer-implemented method for sanitizing and refreshing testing data, said method comprising:

detecting a data refresh request within a control table of a low level environment computer system;
reading a set of table metadata from a system table of the low level environment computer system, wherein the set of table metadata comprises a low level environment table schema;
comparing fields of the low level environment table schema of the system table with fields of a production data table schema of a production data table;
creating a copy of production data correlating to the set of table metadata;
identifying, using a sanitization table, fields requiring sanitization;
based on comparing the fields of the low level environment table schema with the fields of the production data table schema, selectively replacing the fields requiring sanitization using substitute data;
and
writing the copy of the production data into a target table of the low level environment computer system.

5 more elements

Dependencies are inferred from the claim text.

Facts

Application: 16/594,184Filed 7 Oct 2019 · continuation
Priority: 26 Jan 2017
Published: US 2020/0034278 A130 Jan 2020
Granted: 25 Jan 2022
Term ends: Not estimatedThe source records don’t support an estimate.

Classification6 codes

G06F 11/3698
Prevention of errors by analysis, debugging or testing of software: environments for analysis, debugging or testing of software
G06F 16/21
Of structured data, e.g. relational data: design, administration or maintenance of databases
G06F 16/2455
Query processing: query execution
G06F 16/252
Integrating or interfacing systems involving database management systems: between a Database Management System and a front-end application

Family

Application15/416,141Parent of this continuation · filed 26 Jan 2017
US 2020/0034278 A1Pre-grant publication · published 30 Jan 2020
US 10,437,708 B2Parent of this continuation
US 2018/0210817 A1Published application
US 11,232,017 B2This patent

From the US filing history. Foreign family members aren’t listed.