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

Claim 0:
1. A system for identifying similarities between tables and databases stored in a storage server, wherein the system comprises:
the storage server, comprising:
a first database configured to store a plurality of first database tables, wherein the first database tables comprise:
a source table; and
a target table;

a second database configured to store a plurality of second database tables;

a management server, comprising:
a non-transitory memory configured to store:
instructions; and
a storage index indicating metadata describing a plurality of tables stored at the storage server, wherein the metadata includes table names for each of the tables, physical paths to each of the tables within the storage server, a row count of each of the tables, a size of each of the tables, a timestamp of a last access of each of the tables, access data of each of the tables, a sender of each of the tables, and a data format of each column in each of the tables;

a processor configured to execute the instructions, which cause the processor to be configured to:
determine, by a table similarity scoring application of the management server, a table similarity score between the source table and the target table based on a comparison between metadata describing each column in the source table and metadata describing each column in the target table;
determine, by a database similarity scoring application of the management server, a database similarity score between the first database and the second database based on either:
a comparison between metadata describing each column in the first database and metadata describing each column in the second database; or
a plurality of table similarity scores between of each table in the first database and each table in the second database;

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 a threshold amount and the table similarity score being greater than a second threshold amount, transmit, using a server-to-storage application programming interface, an instruction to the storage server 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 a user equipment (UE); and
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, transmit, using the server-to-storage application programming interface, an instruction to the storage server to delete data stored in the first database to eliminate redundancies at the storage server, wherein the data stored in the first database is associated with the UE.