US 12,443,581 B2
Methods, systems, and apparatuses for improved data management
Raja Kumar Narasimhadevara, Chester Springs, PA (US); Reinaldo José Garcia, Collegeville, PA (US); and Nicholas Stephen Myers, Stephenson, VA (US)
Assigned to Comcast Cable Communications, LLC, Philadelphia, PA (US)
Filed by Comcast Cable Communications, LLC, Philadelphia, PA (US)
Filed on Feb. 5, 2021, as Appl. No. 17/168,828.
Application 17/168,828 is a continuation in part of application No. 16/885,065, filed on May 27, 2020.
Prior Publication US 2021/0374116 A1, Dec. 2, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/22 (2019.01); G06F 16/2457 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/221 (2019.01); G06F 16/24573 (2019.01); G06F 16/248 (2019.01)] 23 Claims
OG exemplary drawing
 
1. A method comprising:
retrieving, by a computing device, first database metadata for a first plurality of data tables stored within a first database without collecting row data stored in the first plurality of data tables;
retrieving, by the computing device, second database metadata for a second plurality of data tables stored within a second database without collecting row data stored in the second plurality of data tables, wherein the first database is compatible with a first database type and the second database is compatible with a second database type that is different than the first database type, wherein the first database metadata and the second database metadata each comprise two or more of: a plurality of column names, a plurality of column attribute datatypes, and a plurality of column descriptions stored within the first plurality of data tables and the second plurality of data tables, respectively;
converting, by the computing device, the first database metadata from the first database type to a common format and the second database metadata from the second database type to the common format;
based on the converting of the first database metadata from the first database type to the common format and the converting of the second database metadata to the common format, storing a database metadata table comprising both of the first database metadata and the second database metadata, wherein the database metadata table comprises two or more of: a first column comprising the plurality of column names, a second column comprising the plurality of column attribute datatypes, and a third column comprising the plurality of column descriptions stored within the first plurality of data tables and/or the second plurality of data tables;
determining, based on a request for data associated with one or more personal information (PI) elements associated with a requesting party, one or more database metadata rules, wherein the one or more database metadata rules are configured to identify one or more column names, one or more column attribute datatypes, or one or more column descriptions, within the database metadata table, associated with one or more data tables of the first plurality of data tables and/or the second plurality of data tables that comprise the data associated with the one or more PI elements;
determining, based on the one or more database metadata rules, at least one portion of the database metadata table indicative of one or more databases, of the first database and/or the second database, comprising the one or more data tables that comprise the one or more PI elements, wherein the data associated with the one or more PI elements is stored in the one or more data tables as the row data;
determining a confidence score associated with the at least one portion of the database metadata table, wherein the confidence score is indicative of a level of confidence that the one or more data tables indicated by the at least one portion of the database metadata table comprise the one or more PI elements; and
sending, based on the confidence score, a response to the request.