Duplicate table identification in enterprise database systems for data storage optimization
AssigneePaypal, Inc.
InventorsAnchika Agarwal, Pushpinder Singh
Life of this patent
Estimating the term…
Loading patent…
AssigneePaypal, Inc.
InventorsAnchika Agarwal, Pushpinder Singh
Estimating the term…
There are provided systems and methods for duplicate table identification in enterprise database systems for data storage optimization. A service provider, such as an electronic transaction processor for digital transactions, may determine data duplication in database tables so that database storage resources may be optimized. In order to determine data duplication, within database tables, a data collector daemon operation and/or application may collect metadata for tables within a domain. Using the metadata, a master table and derived tables may be determined for a group of the tables. Further, a duplication factor may be determined based on matching columns in the tables, a usage factor may be determined using processing hits to the tables, and a size factor may be determine based on table size. This allows for determination of a relevance score of the group, which provides a measure of duplication of data within those tables.
A system comprising:
A method comprising:
A non-transitory machine-readable medium having stored thereon machine-readable instructions executable to cause a machine to perform operations comprising:
Dependencies are inferred from the claim text.