Patent ID: 9158802
Filing Date: 2015-10-13
Classification: G06F

Abstract:
1. A processor-implemented method to execute on one or more processors that perform the method, comprising: creating a virtual partition of a temporal database table by mapping physical partitions of the table to logical partitions of the table, wherein the temporal database includes data associated with valid times and transaction times, wherein valid times are rows that are either valid or no longer valid, wherein a valid row references a time that is current or future to a present time and a no longer valid row references a time that is past, wherein transaction times are rows that are either an open transaction or a closed transaction, wherein a first portion of the logical partitions belong to a current partition and a second portion of the logical partitions belong to a history partition, wherein the physical partitions are associated with a selected mapping update frequency for a partition mapping update, the partition mapping update changing the mapping of a physical partition from a logical current partition to a logical history partition; receiving a request to move at least a portion of the data from the current partition to the history partition, the at least a portion of the data being at least one of valid times data that is no longer valid or transaction times data that is closed; and in response to the receiving, modifying the logical partitions by updating the mapping of the physical partitions from a logical current partition to a logical history partition, instead of moving the data to other physical partitions.