Patent ID: 9454344
Filing Date: 2016-09-27
CPC Classification: G06F

Claim Text:
1. A database system comprising: a storage device configured to store a database dictionary; a processor in communication with the storage device, the processor configured to: receive a plurality of related versions of a temporal user-defined function; store, in the database dictionary, the plurality of related versions of the temporal user-defined function and a respective time period for each related version of the temporal user-defined function over which to apply each related version of the temporal user-defined function, wherein each related version of the temporal user-defined function is configured to be selectively applied based on the respective time period; receive a database query comprising a request to apply the temporal user-defined function to database data for a specified time; in response to the specified time contained in the database query, select a version from the plurality of related versions-of the temporal user-defined function having a respective time period that contains the specified time; and apply the selected version of the temporal user-defined function to the database data in performance of at least a portion of the database query.