Database management by analyzing usage of database fields

摘要

Apparatuses, computer readable media, methods, and systems are described for accessing table layout data identifying a plurality of fields included in a table stored in a database, accessing log data identifying a number of times each of the fields of the table has been queried, ranking the fields based on the number of times each of the fields of the table has been queried, determining a first subset of the fields that have not been queried at least a predetermined number of times, and generating an update to the table by removing the first subset of the fields from the table.

主权项

1. An apparatus, comprising:
at least one processor; and at least one memory storing instructions that, when executed by the at least one processor, cause the apparatus to:
access table layout data identifying database fields of a database table stored in a database;access log data identifying a number of times the database fields of the database table have been queried;rank the database fields of the database table based on the number of times the database fields of the database table have been queried;identify, from amongst the database fields of the database table, a subset of database fields that have not been queried at least a predetermined number of times; andremove the subset of database fields that have not been queried at least the predetermined number of times from the database table.