US 11,386,052 B2Granted

System for scanning and analysis of protected electronic data using a database schema collection

AssigneeBank of America Corporation

InventorsCandace R. Gordon, Parthiban T. Shanmugam, Kia Kinlaw, Prashant Ranjan Srivastava, Sriram Mohanraj, Barbara Billups, Timothy Lamonte Atwell, Theresa Cozene Pitts, Kalwa Srikanth, Kamalanathan Jeganathan, Todd Lowney, Bala Naga Satish Gandham, Kartheek Kotha, Suman Mishra, Shakeb Mohammed Ali, Archana Raghupathi

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

A system provides a way to scan protected electronic data via database schema collection. In particular, the system may comprise a database schema collection application which may aggregate physical database schema from all of the databases within the network environment. The system may further comprise a protected data scan application which may receive scan results from the database schema collection (e.g., by scanning metadata) and subsequently output the scan results to other applications and/or repositories. The protected data scan application may further report changes in database schema to account for new values and/or categories existing within the various databases.

Claims20

Dependent claims

A system for scanning protected electronic data via database schema collection, the system comprising:

a memory device with computer-readable program code stored thereon;
a communication device;
and
a processing device operatively coupled to the memory device and the communication device, wherein the processing device is configured to execute the computer-readable program code to:
submit a protected data scan request to a database schema collection application;
receive, from the database schema collection application, a compiled list of data from one or more databases comprising protected data;
identify, via a protected data scan tool, the protected data within the compiled list of database schema;
generate a stored copy of the protected data within a protected data repository;
transmit, via a reporting application, the stored copy of the protected data to a user associated with the protected data;
generate, via the reporting application, a personalized report associated with the user, wherein the personalized report comprises a list and descriptions of the protected data;
transmit the personalized report to the user;
detect, using a protected data compare tool, a change in a database schema in the one or more databases comprises protected data;
generate a delta report comparing the change in the database schema with metadata stored within the protected data repository, wherein the delta report comprises an indication of a new column within the change in the database schema, wherein the new column provides a new classification of protected data;
update the protected data repository based on the delta report, wherein updating the protected data repository based on the delta report comprises appending the new column to the protected data repository;
identify, in response to a second protected data scan request, the new classification of protected data within the second protected data scan request;
and
store the new classification of protected data in the protected data repository.

14 more elements

A computer program product for scanning protected electronic data via database schema collection, 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 code portions for:

submitting a protected data scan request to a database schema collection application;
receiving, from the database schema collection application, a compiled list of data from one or more databases comprising protected data;
identifying, via a protected data scan tool, the protected data within the compiled list of database schema;
generating a stored copy of the protected data within a protected data repository;
transmitting, via a reporting application, the stored copy of the protected data to a user associated with the protected data;
generating, via the reporting application, a personalized report associated with the user, wherein the personalized report comprises a list and descriptions of the protected data;
transmitting the personalized report to the user;
detecting, using a protected data compare tool, a change in a database schema in the one or more databases comprises protected data;
generating a delta report comparing the change in the database schema with metadata stored within the protected data repository, wherein the delta report comprises an indication of a new column within the change in the database schema, wherein the new column provides a new classification of protected data;
updating the protected data repository based on the delta report, wherein updating the protected data repository based on the delta report comprises appending the new column to the protected data repository;
identifying, in response to a second protected data scan request, the new classification of protected data within the second protected data scan request;
and
storing the new classification of protected data in the protected data repository.

10 more elements

A computer-implemented method for scanning protected electronic data via database schema collection, wherein the method comprises:

submitting a protected data scan request to a database schema collection application;
receiving, from the database schema collection application, a compiled list of data from one or more databases comprising protected data;
identifying, via a protected data scan tool, the protected data within the compiled list of database schema;
generating a stored copy of the protected data within a protected data repository;
and
transmitting, via a reporting application, the stored copy of the protected data to a user associated with the protected data;
generating, via the reporting application, a personalized report associated with the user, wherein the personalized report comprises a list and descriptions of the protected data;
transmitting the personalized report to the user;
detecting, using a protected data compare tool, a change in a database schema in the one or more databases comprises protected data;
generating a delta report comparing the change in the database schema with metadata stored within the protected data repository, wherein the delta report comprises an indication of a new column within the change in the database schema, wherein the new column provides a new classification of protected data;
updating the protected data repository based on the delta report, wherein updating the protected data repository based on the delta report comprises appending the new column to the protected data repository;
identifying, in response to a second protected data scan request, the new classification of protected data within the second protected data scan request;
and
storing the new classification of protected data in the protected data repository.

11 more elements

Dependencies are inferred from the claim text.

Facts

Application: 16/580,344Filed 24 Sep 2019
Published: US 2021/0089505 A125 Mar 2021
Granted: 12 Jul 2022
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/211
Design, administration or maintenance of databases: schema design and management
G06F 21/562
Computer malware detection or handling, e.g. anti-virus arrangements: static detection
G06F 21/6227
To a system of files or objects, e.g. local or distributed file system or database: where protection concerns the structure of data, e.g. records,…
G06F 21/6245
To a system of files or objects, e.g. local or distributed file system or database: protecting personal data, e.g. for financial or medical purposes