one
AUTOMATED DATABASE INDEX MANAGEMENT

Abstract:

A database index management system uses one or more machine learning models to analyze a query log in relation to a database. A machine learning model may identify a query pattern and/or a change in the query pattern from the query log, identify a column associated with the query pattern, and identify an addition, removal, or modification of an index related to the identified column. The database index management system may perform one or more additions, removals or modifications of indices of the database based on query patterns identified in the query log. The database index management system continuously improves database performance in response to changing database usage patterns over time.