Patent ID: 8930347
Filing Date: 2015-01-06
Classification: G06F

Abstract:
1. A method for storing intermediate result sets in a database system, the method comprising the steps of: receiving an access plan for a single query for accessing data stored in the database system, the access plan comprising a sequence of operations specific to the database system; generating an intermediate result set during execution of the access plan, the intermediate result set comprising a result set of execution of one of the operations of the access plan; determining a value of an intermediate result set rating of the intermediate result set during execution of the access plan at runtime of the query for determining if the intermediate result set, generated during the execution of the access plan, is to be stored before storing the intermediate result set; and based on determining that the value of the intermediate result set rating meets a predefined criterion, storing the determined intermediate result set for a longer period of time than the runtime of the query as a stored intermediate result set.