US 12,443,606 B2
Methods, systems, and apparatuses for improved data management
Nicholas S. Myers, Stephenson, VA (US); Raja Kumar Narasimhadevara, Chester Springs, PA (US); James A. Ficarra, Jr., Quakertown, PA (US); Amitkumar A. Patel, Katy, TX (US); Jayson Brooks Hurd, Highlands Ranch, CO (US); Pramod Dimri, Parker, CO (US); Anupam Mohanta, Chennai (IN); Chakrapani Velugubantla, Skillman, NJ (US); John Engler, Highlands Ranch, CO (US); and Joseph K. Zia, Philadelphia, PA (US)
Assigned to COMCAST CABLE COMMUNICATIONS, LLC, Philadelphia, PA (US)
Filed by COMCAST CABLE COMMUNICATIONS, LLC, Philadelphia, PA (US)
Filed on May 27, 2020, as Appl. No. 16/885,065.
Prior Publication US 2021/0374145 A1, Dec. 2, 2021
Int. Cl. G06F 16/2457 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/24573 (2019.01) [G06F 16/2282 (2019.01)] 26 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 a plurality of column names from 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 a first column of the database metadata table comprises the plurality of column names and a second column of the database metadata table comprises one of a plurality of column attribute datatypes or a plurality of column descriptions associated with the plurality of column names;
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, of the plurality of column names within the database metadata table, associated with one or more data tables that comprise the data associated with the one or more PI elements;
determining, based on the one or more database metadata rules and the one or more column names, a portion of the database metadata table indicative of one or more of the first database and/or the second database, of the first plurality of data tables stored within the first database or of the second plurality of data tables stored within the second database, comprising the one or more data tables that comprise the data associated with 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 row data; and
sending, based on the data associated with the one or more PI elements, a response to the request.