Patent ID: 9626403
Date: 2017-04-18
CPC Classifications: G06F

Claim:
1. A method comprising: determining, using a computing device, that a data table includes a problematic key, wherein the problematic key includes a key used in a plurality of queries that fails to generate query results within a threshold time period; creating, in response to determining that the data table includes a problematic key, a variant table configured to store at least a portion of the data in the data table and optimize processing queries using the problematic key; storing an update time of the variant table; receiving a new query including a key; determining whether the key is the problematic key; determining whether resolving the new query using information associated with the update time of the variant table is acceptable; upon determining that the query key is a problematic key and that resolving the new query using information associated with the update time of the variant table is acceptable, generating a result for the new query using the variant table; and upon determining that the query key is not a problematic key or that resolving the new query using information associated with the update time of the variant table is unacceptable, generating a result for the new query using the data table.