Patent ID: 11914553
Assignee: T-MOBILE INNOVATIONS LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 6:
7. A method performed by a management server for identifying similarities between tables and databases stored in a storage server, wherein the storage server comprises a source database and a target database, wherein the source database comprises a source table and a target table, and wherein the method comprises:
obtaining, by a scanner application of the management server, metadata describing each column in the source table and metadata describing each column in a target table, wherein the metadata includes table names for each of a plurality of tables stored at the storage server, physical paths to each of the plurality of tables within the storage server, a row count of each of the plurality of tables, a size of each of the tables, a timestamp of a last access of each of the plurality of tables, access data of each of the plurality of tables, a sender of each of the plurality of tables, and a data format of each column in each of the plurality of tables;
determining, by a table similarity scoring application of the management server, a table similarity score between the source table and the target table by comparing metadata describing each column in the source table with metadata describing each column in the target table;
determining, by a usage application of the management server, access data describing a frequency of accessing data stored in the source table; and
responsive to the frequency of accessing data being less than a threshold amount and the table similarity score being greater than a second threshold amount, transmitting, to a user equipment (UE), using a server-to-user equipment application programming interface, a message comprising the table similarity score and the access data, prompting a user of the UE to delete data stored in the source table to eliminate redundancies at the storage server, wherein the data stored in the source table is associated with the UE.