Patent ID: 8990186
Filing Date: 2015-03-24
Classification: G06F

Abstract:
1. A method implemented and programmed within a non-transitory computer-readable storage medium and processed by a processor, the processor configured to execute the method, comprising: acquiring a query defining a join index; parsing the query to identify each occurrence and each context where a current date or current time condition is used; determining actions to take based on each occurrence and each context; updating the query and the join index by using the actions to restate the query; and devising join index maintenance mechanisms for different maintenance conditions that arise with the restated query, and devising the index maintenance mechanisms as an incremental joint index maintenance to handle: the current date or the current time present in a WHERE clause of the query, the current date or the current time present in an ON clause of the query, complex conditions within the query having the current date or the current time, the current date or the current type present in a PARTITION BY clause of the query, the current date or the current time present in a SELECT list of the query, the current date or the current time present in GROUP BY and ORDER BY clauses of the query, and the current date or the current time present in a PRIMARY INDEX clause of the query.