Granted Patent B2

US 12,254,111 · App. 17/646,727 · Granted Mar 18, 2025

Inventors: Sridhar Raghunathan (Chennai, IN); Kevin Tran (Frisco, TX); Jyotsana Utsav (Frisco, TX)

Assignee: Bank of America Corporation

G06F21/6227G06F16/2358G06F16/285G06F40/40

Abstract

Claims (94)

1. A system for automatically applying data type classifications to data, the system comprising:

a plurality of data servers, each data server comprising one or more databases;

a classification server comprising a classification database;

a memory configured to store a plurality of classification models, wherein:

each classification model is associated with one or more column attributes and a data type classification that applies to data columns that are associated with the one or more column attributes; and

the data type classification indicates a type of data that is stored in a data column;

a processor communicatively coupled to the memory, the processor configured to:

determine, by periodically analyzing the one or more databases, that a data table has been newly created or modified;

extract a data column from the data table that has been newly created or modified;

determine that the data column does not have an existing data type classification;

in response to determining that the data column does not have an existing data type classification, determine from the plurality of classification models, a particular classification model to use for the data column by:

determining one or more column attributes associated with the data column;

determining from the plurality of classification models the particular classification model that is associated with the one or more column attributes of the data column; and

apply a particular data type classification associated with the particular classification model to the data column by:

sending the particular data type classification to the classification server, wherein the particular data type classification is applied to the data column in the classification database of the classification server.

2. The system of claim 1 , wherein the particular data type classification is a privacy classification this is operable to restrict access to the data column.

3. The system of claim 1 , wherein the column attributes of the data column and the column attributes of the plurality of classification models comprise:

a column name;

a datatype;

a data size; and

creator information.

4. The system of claim 1 , wherein determining from the plurality of classification models, by comparing data attributes of the data column to data attributes of the plurality of classification models, the particular classification model to use for the data column comprises utilizing natural language processing (NLP).

5. The system of claim 1 , wherein the one or more databases are pre-production development databases.

6. The system of claim 1 , wherein determining that a data table has been newly created or modified comprises:

accessing a time stamp of the data table, the time stamp indicating a time that the data table was created or modified;

determining a time of a previous access of the data table; and

comparing the time of the time stamp to the time of the previous access of the data table.

7. The system of claim 1 , wherein the plurality of data servers comprise:

a SQL server;

an Oracle server;

a Hive server;

a Teradata server; or

a Hadoop server.

8. A method for automatically applying data type classifications to data, the method comprising:

accessing one or more databases stored in a plurality of data servers;

accessing a plurality of classification models, wherein:

each classification model is associated with one or more column attributes and a data type classification that applies to data columns that are associated with the one or more column attributes; and

the data type classification indicates a type of data that is stored in a corresponding data column;

determining, by periodically analyzing the one or more databases, that a data table has been newly created or modified;

extracting a data column from the data table that has been newly created or modified;

determining that the data column does not have an existing data type classification;

in response to determining that the data column does not have an existing data type classification, determining from the plurality of classification models a particular classification model to use for the data column by:

determining one or more column attributes associated with the data column;

determining from the plurality of classification models the particular classification model that is associated with the one or more column attributes of the data column; and

applying a particular data type classification associated with the particular classification model to the data column by:

sending the particular data type classification to the classification server, wherein the particular data type classification is applied to the data column in the classification database of the classification server.

9. The method of claim 8 , wherein the particular data type classification is a privacy classification this is operable to restrict access to the data column.

10. The method of claim 8 , wherein the column attributes of the data column and the column attributes of the plurality of classification models comprise:

a column name;

a datatype;

a data size; and

creator information.

11. The method of claim 8 , wherein determining from the plurality of classification models, by comparing data attributes of the data column to data attributes of the plurality of classification models, the particular classification model to use for the data column comprises utilizing natural language processing (NLP).

12. The method of claim 8 , wherein the one or more databases are pre-production development databases.

13. The method of claim 8 , wherein determining that a data table has been newly created or modified comprises:

accessing a time stamp of the data table, the time stamp indicating a time that the data table was created or modified;

determining a time of a previous access of the data table; and

comparing the time of the time stamp to the time of the previous access of the data table.

14. The method of claim 8 , wherein the plurality of data servers comprise:

a SQL server;

an Oracle server;

a Hive server;

a Teradata server; or

a Hadoop server.

15. A system comprising:

a memory configured to store a plurality of classification models, wherein:

each classification model is associated with one or more column attributes and a data type classification that applies to data columns that are associated with the one or more column attributes; and

the data type classification indicates a type of data that is stored in a corresponding data column;

a processor communicatively coupled to the memory, the processor configured to:

periodically access one or more databases stored in one or more data servers;

determine, by periodically analyzing the one or more databases, that a data table has been newly created or modified;

determine that a data column of the data table does not have an existing data type classification;

in response to determining that the data column does not have an existing data type classification, determine from the plurality of classification models, a particular classification model to use for the data column by:

determining one or more column attributes associated with the data column;

determining from the plurality of classification models the particular classification model that is associated with the one or more column attributes of the data column; and

apply a particular data type classification associated with the particular classification model to the data column by:

sending the particular data type classification to the classification server, wherein the particular data type classification is applied to the data column in the classification database of the classification server.

16. The system of claim 15 , wherein the particular data type classification is a privacy classification this is operable to restrict access to the data column.

17. The system of claim 15 , wherein the column attributes of the data column and the column attributes of the plurality of classification models comprise:

a column name;

a datatype;

a data size; and

creator information.

18. The system of claim 15 , wherein determining from the plurality of classification models, by comparing data attributes of the data column to data attributes of the plurality of classification models, the particular classification model to use for the data column comprises utilizing natural language processing (NLP).

19. The system of claim 15 , wherein determining that a data table has been newly created or modified comprises:

accessing a time stamp of the data table, the time stamp indicating a time that the data table was created or modified;

determining a time of a previous access of the data table; and

comparing the time of the time stamp to the time of the previous access of the data table.

20. The system of claim 15 , wherein the one or more data servers comprise:

a SQL server;

an Oracle server;

a Hive server;

a Teradata server; or

a Hadoop server.

Assignments (1)

Continuity (1)

References Cited (53)