Sap Se

Chang Ge

Anil Kumar Goel

Donald Kossmann

Martin Kaufmann

Norman May

Andreas Luethi

Elias Yousefi Amin Abadi

Puspanantha Shanmuganathan

Partitioning of temporal databases can implement distributed storage of temporal data via time-based or space-based techniques to improve performance of operators on the database. A variety of operators can be supported for the partitioned tables, including temporal aggregation, time travel, and temporal join. The use of checkpoints can greatly increase performance in a variety of scenarios. The described partitioning techniques can be applied in a parallel execution context to great benefit. The partitioning can also reduce local memory footprint, facilitating in-memory database processing.

Timeline index for partitioned temporal database tables

Data that includes a query of a temporal database is received from a remote application server. The query specifies at least one fact and a system time and an application time for the at least one fact. Thereafter, a bitemporal timeline index is accessed to identify data responsive to the query. The bitemporal timeline index includes a system time dimension and an application time dimension. Next, the identified data can be retrieved and provided to the remote application server. Related apparatus, systems, techniques and articles are also described.

Bitemporal timeline index

Growing community of inventors

Waterloo, Canada

Chang Ge