公开(公告)号：US10970301B2

公开(公告)日：2021-04-06

申请号：US15855599

申请日：2017-12-27

Applicant: SAP SE

Inventor： Sandro Schiefner ,  Max Krupp

IPC: G06F16/25 ,  G06F16/28 ,  G06F16/22 ,  G06F16/2455

Abstract: Comments are flexibly bound to keyfigures of an in-memory database, through reference to dimension dependency table(s). An in-memory database engine creates a comment bound to a first tuple via a first comment table. The first tuple comprises a first dimension (e.g., Product). A user then requests a second tuple comprising a second dimension (e.g., Product Group) related to the first dimension. In response, the in-memory database engine references a dimension dependency table to determine dimension dependency information. Based upon that information, the engine transforms the comment to also be bound to the second tuple via a second comment table. The second tuple is then returned to the user together with the comment, even though the second tuple may not explicitly share dimensions with the first tuple. Embodiments may leverage the processing power and data proximity of the in-memory database engine, to efficiently transform comments by executing aggregation (e.g., join) operations.

公开(公告)号：US20190197170A1

公开(公告)日：2019-06-27

申请号：US15855599

申请日：2017-12-27

Applicant: SAP SE

Inventor： Sandro Schiefner ,  Max Krupp

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/2264 ,  G06F16/2282 ,  G06F16/24556 ,  G06F16/2456 ,  G06F16/283

Abstract: Comments are flexibly bound to keyfigures of an in-memory database, through reference to dimension dependency table(s). An in-memory database engine creates a comment bound to a first tuple via a first comment table. The first tuple comprises a first dimension (e.g., Product). A user then requests a second tuple comprising a second dimension (e.g., Product Group) related to the first dimension. In response, the in-memory database engine references a dimension dependency table to determine dimension dependency information. Based upon that information, the engine transforms the comment to also be bound to the second tuple via a second comment table. The second tuple is then returned to the user together with the comment, even though the second tuple may not explicitly share dimensions with the first tuple. Embodiments may leverage the processing power and data proximity of the in-memory database engine, to efficiently transform comments by executing aggregation (e.g., join) operations.