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

Claim 11:
12. 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 database similarity scoring application of the management server, a database similarity score between the source database and the target database by:
determining, by the database similarity scoring application, a plurality of table similarity scores between each table in the source database and each table in the target database, the table similarity scores determined based on a comparison between metadata describing columns in each table in the source database and each table in the target database;
determining, by the database similarity scoring application, a subset of the table similarity scores that are greater than or equal to a pre-defined threshold; and
determining, by the database similarity scoring application, the database similarity score between the source database and the target database based on an average of the table similarity scores in the subset, a quantity of the table similarity scores in the subset, and a total quantity of tables in the source database; and

determine, by a usage application of the management server, access data describing a frequency of accessing data stored in at least one of the first database or the source table;
responsive to the frequency of accessing data being less than the threshold amount and the database similarity score being greater than a third threshold amount, transmitting, to a user equipment (UE), using a server-to-user equipment application programming interface, a message comprising the database similarity score and the access data, prompting a user of the UE to delete data stored in the source database to eliminate redundancies at the storage server, wherein the data stored in the source database is associated with the UE.