IP Library › Granted Patent US 10,970,301
Granted Patent B2
US 10,970,301 · App. 15/855,599 · Granted Apr 6, 2021

Keyfigure comments bound to database level persistence

Inventors: Sandro Schiefner (Hockenheim, DE); Max Krupp (Neulußheim, DE)
Assignee: SAP SE
G06F16/258G06F16/2264G06F16/2282G06F16/2456G06F16/24556G06F16/283
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,970,301
App. No.
15/855,599
Granted
Apr 6, 2021
Kind
B2
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.

Claims (36)

1. A computer-implemented method comprising:

an in-memory database engine of an in-memory database receiving a request for a first tuple from a planning application, the first tuple comprising a first dimension, the first dimension comprising a first keyfigure, the first keyfigure comprising a time attribute, the in-memory database comprising a time series table including the time attribute;

based upon the first dimension, the in-memory database engine referencing a dependency table stored in the in-memory database to produce dimension dependency stored in the dependency table, the dimension dependency information revealing the first dimension as being related to the second dimension;

based on the dimension dependency information, the in-memory database engine transforming, using a join operation, a comment stored with a second tuple to be bound at database level persistence with the first tuple stored in the in-memory database, the transforming further comprising persisting in the in-memory database a time table storing fields of the time series table and a reference to the comment; and

the in-memory database returning the first tuple and the comment to the planning application.

2. A method as in claim 1 further comprising:

prior to receiving the request, the in-memory database engine receiving the comment with the second tuple; and

the in-memory database engine creating the comment bound to the second tuple in a first comment table of the in-memory database.

3. A method as in claim 2 wherein the in-memory database engine transforms the comment that is bound to the second tuple in a second comment table of the in-memory database.

4. A method as in claim 1 wherein the first dimension comprises a first keyfigure.

5. A method as in claim 4 wherein the dimension dependency information comprises a dependency between the first keyfigure and the second dimension comprising a second keyfigure.

6. A method as in claim 4 wherein:

if the time series table already includes another comment, the method further comprising checking whether the reference should be inserted.

7. A method as in claim 4 wherein: the first keyfigure comprises a time attribute; the in-memory database comprises a time series table including the time attribute; and the method further comprises adding a comment indicator to the time series table.

8. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

an in-memory database engine of an in-memory database receiving a request for a first tuple from a planning application, the first tuple comprising a first dimension, the first dimension comprising a first keyfigure, the first keyfigure comprising a time attribute, the in-memory database comprising a time series table including the time attribute;

based upon the first dimension, the in-memory database engine referencing a dependency table stored in the in-memory database to produce dimension dependency information stored in the dependency table, the dimension dependency information revealing the first dimension as being related to the second dimension;

based on the dimension dependency information, the in-memory database engine transforming, using a join operation, a comment stored with a second tuple to be bound at database level persistence with the first tuple stored in the in-memory database, the transforming further comprising persisting in the in-memory database a time table storing fields of the time series table and a reference to the comment; and

the in-memory database returning the first tuple and the comment to the planning application.

9. A non-transitory computer readable storage medium as in claim 8 further comprising:

prior to receiving the request, the in-memory database engine receiving the comment with the second tuple; and

the in-memory database engine creating the comment bound to the second tuple in a first comment table of the in-memory database.

10. A non-transitory computer readable storage medium as in claim 9 wherein the first dimension comprises a first keyfigure.

11. A computer system comprising:

one or more processors;

a software program, executable on said computer system, the software program configured to cause an engine of an in-memory database to:

receive a request for a first tuple from a planning application, the first tuple comprising a first dimension comprising a keyfigure including a time attribute, the in-memory database comprising a time series table including the time attribute;

based upon the first dimension, reference a dependency table stored in the in-memory database to produce dimension dependency information stored in the dependency table, the dimension dependency information revealing the first dimension as being related to the second dimension;

based on the dimension dependency information, transform, using a join operation, a comment stored with a second tuple to be bound at database level persistence with the first tuple stored in the in-memory database, wherein the transforming comprises

persisting in the in-memory database, a time table storing fields of the time series table including the time attribute and a reference to the comment; and

return the first tuple and the comment to the planning application.

12. A computer system as in claim 11 wherein the software program is further configured to cause the in-memory database engine to:

prior to receiving the request, receive the comment with the second tuple; and

create the comment bound to the second tuple in a comment table of the in-memory database.

13. A computer system as in claim 12 wherein the software program is further configured to cause the in memory database engine to:

bind the comment to the first tuple in another comment table of the in-memory database.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 27, 2017
From: SCHIEFNER, SANDRO; KRUPP, MAX
To: SAP SE
Reel/Frame 044493/0179 →
Continuity (1)
Related Publication 20190197170A1 · Jun 27, 2019
Cited By (1)
US 12,596,131