公开(公告)号：US10515059B2

公开(公告)日：2019-12-24

申请号：US15665154

申请日：2017-07-31

Applicant: SAP SE

Inventor： Martin Kaufmann ,  Norman May ,  Andreas Tonder ,  Donald Kossmann

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2458

Abstract: Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.

公开(公告)号：US20170329807A1

公开(公告)日：2017-11-16

申请号：US15665154

申请日：2017-07-31

Applicant: SAP SE

Inventor： Martin Kaufmann ,  Norman May ,  Andreas Tonder ,  Donald Kossmann

IPC: G06F17/30

CPC classification number: G06F16/219 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/2477

Abstract: Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.