US 9,811,571 B2
Bitemporal timeline index
Martin Kaufmann, Zurich (CH); Anil Kumar Goel, Ontario (CA); Chang Ge, Ontario (CA); and Donald Kossmann, Zurich (CH)
Assigned to SAP SE, Waldorf (DE)
Filed by Martin Kaufmann, Zurich (CH); Anil Kumar Goel, Ontario (CA); Chang Ge, Ontario (CA); and Donald Kossmann, Zurich (CH)
Filed on Dec. 13, 2013, as Appl. No. 14/106,621.
Prior Publication US 2015/0169697 A1, Jun. 18, 2015
Int. Cl. G06F 17/30 (2006.01)
CPC G06F 17/30551 (2013.01) [G06F 17/30353 (2013.01); G06F 17/30336 (2013.01); G06F 17/30339 (2013.01)] 13 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, from a remote application server, data comprising a query of a temporal database, the query specifying at least one fact and a system time and an application time for the at least one fact;
accessing a bitemporal timeline index to identify data responsive to the query, the bitemporal timeline index comprising:
a system timeline index comprising a system time dimension, the system time dimension comprising a system time that indicates when a data object is visible in the temporal database; and
an application timeline index comprising an application time dimension, the application time dimension comprising an application time that indicates when the data object is visible to a user;
storing updates to at least one of the application timeline index and the system timeline index in a delta store;
dynamically generating the application timeline index for a point in time specified by the query by merging the application timeline index with the corresponding delta store;
retrieving the identified data; and
providing the retrieved data to a remote application server.