Patent ID: 11947537
Assignee: AMAZON TECHNOLOGIES, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A system, comprising:
at least one processor; and
a memory, storing program instructions that when executed by the at least one processor, cause the at least one processor to implement a non-relational database system, configured to:
perform one or more queries to one or more tables stored in the non-relational database system;
obtain one or more performance metrics for the one or more queries;
evaluate the one or more performance metrics to determine to create a secondary index that projects a subset of the one or more tables in the database to access for performing one or more subsequent queries to the database;
responsive to the determination to create the secondary index:
create the secondary index while the database system is available to accept queries to the database; and
include the secondary index in planning for performing the one or more subsequent queries to the database, wherein the planning comprises:
determining respective types of consistency specified in the one or more subsequent queries; and
selecting the secondary index to perform the one or more subsequent queries instead of the one or more tables in the database according to the determined respective types of consistency for the one or more subsequent queries.