IP Library Granted Patent US 9,058,215
Granted Patent B2
US 9,058,215 · App. 13/655,469 · Granted Jun 16, 2015

Integration of a calculation engine with a software component

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 9,058,215
App. No.
13/655,469
Granted
Jun 16, 2015
Kind
B2
Abstract

Various embodiments of systems and methods for integrating a calculation engine of an in-memory database with a software component are described herein. A control unit schedules and triggers jobs to be processed by an operational unit. The control unit and the operational unit are at an application level. The operational unit divides a job workload corresponding to a job trigger into work packages based on one or more parameters. The work packages are sent to a calculation engine in an in-memory database. At the in-memory database, operations are performed on the work packages and an output is generated. A log in the control unit is updated based on the output.

Claims (61)

1. A computer system implementing software framework related to an in-memory database, the computer system comprising:

a memory storing computer instructions; and

a processor reading the instructions stored in the memory to generate the software framework comprising:

a user interface component in an application layer to schedule jobs and configure a calculation engine of an in-memory database;

an application level component comprising an operational unit and a control unit, wherein:

the control unit performs operations comprising:

triggering jobs to be processed by the operational unit; and

updating a log based on output of the calculation engine;

the operational unit performs operations comprising:

receiving a job trigger input from the control unit;

dividing a job workload into work packages based on one or more parameters, wherein the workload comprises data stored in the in-memory database; and

sending the work packages to the calculation engine; and

the calculation engine in the in-memory database to perform operations on the work packages and generating the output.

2. The computer system of claim 1 , wherein performing the operations on the work packages, comprises:

dividing the work packages into parallel processes in the in-memory database based on the one or more parameters; and

performing the operations on the parallel processes.

3. The computer system of claim 2 , wherein the one or more parameters comprise a store location and a product category.

4. The computer system of claim 3 , wherein the data comprises point-of-sale data; and

dividing the one or more of the work packages into the parallel processes comprises:

creating the parallel processes such that each of the parallel processes includes point-of-sale data of one or more products.

5. The computer system of claim 4 , wherein the operations comprise on-shelf availability calculations and the output of the calculation engine comprises an out-of-shelf alert for a product.

6. The computer system of claim 1 , wherein the application level component further comprises a customization unit that receives and persists configuration parameters of the calculation engine.

7. The computer system of claim 1 , wherein the operational unit performs further operations comprising:

persisting the output of the calculation engine.

8. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:

by a control unit at an application level, trigger jobs to be processed by an operational unit at the application level;

receive a job trigger input at the operational unit from the control unit;

by the operational unit, divide a job workload into work packages based on one or more parameters, wherein the workload comprises data stored in an in-memory database; and

send the work packages to a calculation engine in the in-memory database;

at the in-memory database, perform operations on the work packages and generate an output; and

update a log in the control unit based on the output of the calculation engine.

9. The article of manufacture of claim 8 , wherein the instructions to perform operations on the work packages, further comprises instructions, which when executed by a computer, cause the computer to:

divide the work packages into parallel processes in the in-memory database based on the one or more parameters; and

perform the operations on the parallel processes.

10. The article of manufacture of claim 9 , wherein the one or more parameters comprise a store location and a product category.

11. The article of manufacture of claim 10 , wherein the data comprises point-of-sale data; and

the instructions to divide the one or more of the work packages into the parallel processes, further comprises instructions, which when executed by a computer, cause the computer to:

create the parallel processes such that each of the parallel processes includes point-of-sale data of one or more products.

12. The article of manufacture of claim 11 , wherein the operations comprise on-shelf availability calculations and the output of the calculation engine comprises an out-of-shelf alert for a product.

13. The article of manufacture of claim 8 , further comprises instructions, which when executed by a computer, cause the computer to:

at the application level component, receive and persist configuration parameters of the calculation engine.

14. The article of manufacture of claim 8 , further comprises instructions, which when executed by a computer, cause the computer to:

persist the output of the calculation engine.

15. A computerized method for processing jobs in an in-memory database, method comprising:

by a control unit at an application level, triggering jobs to be processed by an operational unit at the application level;

receiving a job trigger input at the operational unit from the control unit;

by the operational unit, dividing a job workload into work packages based on one or more parameters, wherein the workload comprises data stored in an in-memory database; and

sending the work packages to a calculation engine in the in-memory database;

at the in-memory database, performing operations on the work packages and generate an output; and

updating a log in the control unit based on the output of the calculation engine.

16. The method of claim 15 , wherein performing the operations on the work packages, comprises:

dividing the work packages into parallel processes in the in-memory database based on the one or more parameters; and

performing the operations on the parallel processes.

17. The method of claim 16 , wherein the one or more parameters comprise a store location and a product category.

18. The method of claim 17 , wherein the data comprises point-of-sale data; and

dividing the one or more of the work packages into the parallel processes, further comprises:

creating the parallel processes such that each of the parallel processes includes point-of-sale data of one or more products.

19. The method of claim 18 , wherein the operations comprise on-shelf availability calculations and the output of the calculation engine comprises an out-of-shelf alert for a product.

20. The method of claim 15 , further comprising:

at the application level component, receiving and persisting configuration parameters of the calculation engine; and

persisting the output of the calculation engine.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 15, 2013
From: COLLIGAN, PETER; BOILEAU, JEAN SEBASTIEN; JIMBOREAN, COSMIN; LEHNERT, BERND; SCHUETZ, WOLFGANG
To: SAP AG
Reel/Frame 030211/0659 →