US 11,531,665 B2 · 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.

Claims18

Dependent claims

A method of modifying an index of a table in a relational database, the method comprising:

identifying, by a processor, one or more columns of the table;
receiving a query log comprising two or more queries performed on the table;
analyzing the query log using a machine learning model to identify, among the one or more columns, a column for which an index is to be added, removed or modified;
and
adding, removing, or modifying the index for the identified column,
wherein the analyzing of the query log to identify the column comprises:
using the machine learning model to identify a query pattern for the table based on historical queries;
using the machine learning model to identify a change in the query pattern based on the query log;
and
setting, as the identified column, a column corresponding to the change in the query pattern.

7 more elements

A system for adding, removing, or modifying an index of a table in a relational database, the system comprising:

a machine learning model;
and
a processor and memory configured to:
identify one or more columns of the table;
receive a query log comprising two or more queries performed on the table;
analyze the query log, using the machine learning model, to identify, among the one or more columns, a column for which an index is to be added, removed, or modified;
and
add, remove, or modify the index of the identified column,
wherein the processor and memory are further configured to:
use the machine learning model to identify a query pattern for the table based on historical queries;
use the machine learning model to identify a change in the query pattern based on the query log;
and
set, as the identified column, a column corresponding to the change in the query pattern.

10 more elements

Dependencies are inferred from the claim text.

Automated database index management

Life of this patent

Automated database index management

Life of this patent

Abstract

Claims18