Database management by analyzing usage of database fields

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; and

remove the subset of database fields that have not been queried at least the predetermined number of times from the database table.

2. The apparatus of claim 1 , wherein the instructions, when executed by the at least one processor, cause the apparatus to process the log data to determine a user identifier associated with a user that has initiated at least one query to access the database table.

3. The apparatus of claim 2 , wherein the instructions, when executed by the at least one processor, cause the apparatus to determine whether the user is authorized to access the database table.

4. The apparatus of claim 3 , wherein the instructions, when executed by the at least one processor, cause the apparatus to update a security control in response to determining that the user does not have authorization to access the database table.

5. The apparatus of claim 1 , wherein the instructions, when executed by the at least one processor, cause the apparatus to transfer data of the subset of database fields that have not been queried at least the predetermined number of times to a long term storage device prior to removing the subset of database fields that have not been queried at least the predetermined number of times from the database table.

6. The apparatus of claim 1 , wherein the instructions, when executed by the at least one processor, cause the apparatus to identify, based on the number of times the database fields of the database table have been queried, a subset of database fields that have been queried at least a predetermined minimum number of times.

7. The apparatus of claim 6 , wherein the instructions, when executed by the at least one processor, cause the apparatus to identify a particular database field from amongst the subset of database fields that have been queried at least the predetermined minimum number of times based on a determination that the particular database field is not associated with metadata.

8. The apparatus of claim 7 , wherein the instructions, when executed by the at least one processor, cause the apparatus to authorize manual entry of metadata for the particular database field.

9. The apparatus of claim 1 , wherein the instructions, when executed by the at least one processor, cause the apparatus to:

determine a time period within which at least a predetermined percentage of the database fields of the database table have been queried at least once;

identify a subset of database fields that have not been queried within the time period; and

delete the subset of database fields that have not been queried within the time period from the database table.

10. A method, comprising:

at a computing platform comprising at least one processor and a memory:

accessing, by the at least one processor, log data stored in the memory, the log data identifying a number of times database fields of a database table have been queried;

ranking, by at least one processor, the database fields of the database table based on the number of times the database fields of the database table have been queried;

identifying, by the at least one processor and 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 and that have not been queried by at least a predetermined number of users; and

removing, by the at least one processor, the subset of database fields from the database table.

11. The method of claim 10 , comprising:

processing, by the at least one processor, the log data to determine a user identifier associated with a user that has initiated at least one query to access the database table;

determining, by the at least one processor, whether the user is authorized to access the database table; and

updating, by the at least one processor, a security control in response to determining that the user does not have authorization to access the database table.

12. The method of claim 10 , comprising transferring, by the at least one processor, data of the subset of database fields to a long term storage device prior to removing the subset of database fields from the database table.

13. The method of claim 10 , comprising:

identifying, by the at least one processor and based on the number of times the database fields of the database table have been queried, a subset of database fields that have been queried at least a predetermined minimum number of times; and

authorizing, by the at least one processor and responsive to a determination that a particular database field from amongst the subset of database fields that have been queried at least the predetermined minimum number of times is not associated with metadata, manual entry of metadata for the particular database field from amongst the subset of database fields that have been queried at least the predetermined minimum number of times.

14. The method of claim 10 , comprising:

determining, by the at least one processor, a time period within which at least a predetermined percentage of the database fields of the database table have been queried at least once;

identifying, by the at least one processor, a subset of database fields that have not been queried within the time period; and

deleting, by the at least one processor, the subset of database fields that have not been queried within the time period from the database table.

15. One or more non-transitory computer-readable media having instructions stored thereon that, when executed by one or more computers, cause the one or more computers to:

access log data of a database, the log data identifying a number of times database fields included in a database table stored in the database have been queried;

rank the database fields included in the database table stored in the database based on the number of times the database fields included in the database table stored in the database have been queried;

identify, from amongst the database fields included in the database table, a subset of database fields that have not been queried at least a predetermined number of times; and

remove the subset of database fields that have not been queried at least the predetermined number of times from the database table stored in the database.

16. The one or more non-transitory computer-readable media of claim 15 , wherein the instructions, when executed by the one or more computers, cause the one or more computers to:

process the log data to determine a user identifier associated with a user that has initiated at least one query to access the database table;

determine whether the user is authorized to access the database table; and

update a security control in response to determining that the user does not have authorization to access the database table.

17. The one or more non-transitory computer-readable media of claim 15 , wherein the instructions, when executed by the one or more computers, cause the one or more computers to transfer data of the subset of database fields that have not been queried at least the predetermined number of times to a long term storage device prior to removing the subset of database fields that have not been queried at least the predetermined number of times from the database table stored in the database.

18. The one or more non-transitory computer-readable media of claim 15 , wherein the instructions, when executed by the one or more computers, cause the one or more computers to:

identify, based on the number of times the database fields included in the database table stored in the database have been queried, a subset of database fields that have been queried at least a predetermined minimum number of times; and

responsive to a determination that a particular database field of the subset of database fields that have been queried at least the predetermined minimum number of times is not associated with metadata, authorize manual entry of metadata for the particular database field of the subset of database fields that have been queried at least the predetermined minimum number of times.

19. The one or more non-transitory computer-readable media of claim 15 , wherein the instructions, when executed by the one or more computers, cause the one or more computers to:

determine a time period within which at least a predetermined percentage of the database fields included in the database table stored in the database have been queried at least once;

identify, from amongst the database fields included in the database table stored in the database, a subset of database fields that have not been queried within the time period; and

delete the subset of database fields that have not been queried within the time period from the database table stored in the database.