In Memory Database Warehouse

• US 20150074037A1
• Filed: 09/12/2013
• Published: 03/12/2015
• Est. Priority Date: 09/12/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Sarferaz, Siar
• Granted Patent: US 9,734,221 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

An in memory database system includes a random access memory to store an in memory database table, a stored set of defined views over the database tables, a stored set of analytical services adapted to provide transaction services and database warehouse services, an engine to run the analytical services on the database table, and an interface to interact with users and provide access to the engine, analytical services, and views to perform transactions and data warehouse functions on the database table.

Claims

1. An in memory data warehouse system comprising:

a random access memory to store and manage in memory database tables;

a stored set of defined views of the database tables;

a stored set of analytical services adapted to provide transaction services and database warehouse services; and

an engine to run the analytical services on the database table.

2. The in memory data warehouse system of claim 1 and further comprising an interface to interact with users and provide access to the engine, analytical services, and views to perform transactions and data warehouse functions on the database table.

3. The in memory data warehouse system of claim 2 wherein the user interface comprises:

a specific analytical user interface utilizing HTML/OData; and

a generic analytical user interface utilizing SQL/MDX.

4. The in memory data warehouse system of claim 1 wherein the defined views comprise:

query views; and

reuse views.

5. The in memory data warehouse system of claim 1 wherein the analytical services include a calculation and aggregation engine.

6. The in memory data warehouse system of claim 1 wherein the analytical services include a predictive analysis services.

7. The in memory data warehouse system of claim 1 wherein the analytical services include a history and hierarchy handling services.

8. The in memory data warehouse system of claim 1 wherein the analytical services include cross system analytics services.

9. The in memory data warehouse system of claim 1 wherein the analytical services include security services.

10. The in memory data warehouse system of claim 1 wherein the analytical services include planning and simulation services.

11. An in memory data warehouse system executed method comprising:

storing transaction related data in an in memory database table on random access computer readable memory;

storing a set of defined views in computer readable memory over the database table;

executing transaction services and database warehouse services via the in memory database system; and

running analytical services on the database table via the in memory warehouse system.

12. The method of claim 11 and further comprising providing an interface to interact with users and provide access to the engine, analytical services, and views to perform transactions and data warehouse functions on the database table.

13. The method of claim 12 wherein providing a user interface comprises:

providing a specific analytical user interface utilizing HTML/OData; and

providing a generic analytical user interface utilizing SQL/MDX.

14. The method of claim 11 wherein the defined views comprise:

query views; and

reuse views.

15. The method of claim 11 wherein the analytical services include a calculation and aggregation engine.

16. The method of claim 11 wherein the analytical services include a predictive analysis services, a history and hierarchy handling services, cross system analytics services, security services, and planning and simulation services.

17. A computer readable storage device having instructions to cause a computer to perform an in memory database executed method, the method comprising:

storing transaction related data in an in memory database table;

storing a set of defined views over the database table;

executing analytical services adapted to provide transaction services and database warehouse services; and

using an engine to run the analytical services on the database table.

18. The computer readable storage device of claim 17 wherein the method further comprises providing an interface to interact with users and provide access to the engine, analytical services, and views to perform transactions and data warehouse functions on the database table, wherein providing a user interface comprises:

providing a specific analytical user interface utilizing HTML/OData; and

providing a generic analytical user interface utilizing SQL/MDX.

19. The computer readable storage device of claim 17 wherein the defined views comprise:

query views; and

reuse views.

20. The computer readable storage device of claim 17 wherein the analytical services include a calculation and aggregation engine, a predictive analysis services, a history and hierarchy handling services, cross system analytics services, security services, and planning and simulation services.

21. An in memory data warehouse system comprising:

a random access memory to store and manage in memory database tables;

a stored set of defined views of the database tables;

a stored set of analytical services adapted to provide transaction services and predictive analytics, wherein predictive algorithms are invoked via script code; and

an engine to run the analytical services on the database table.

22. The in memory database warehouse system of claim 21 wherein the script code comprises SQL script code.

23. The in memory database warehouse system of claim 22 wherein the SQL script code reads input data in an order and format expected by a predictive algorithm and calls the predictive algorithm.

24. The in memory database warehouse system of claim 23 wherein the SQL script code further reads stored control parameters of the predictive algorithm.

25. The in memory database warehouse system of claim 23 wherein the SQL script code identifies a results variable to assign to a view'"'"'s output structure.

26. The in memory database warehouse system of claim 21 wherein the stored set of defined views includes a control view to expose stored control parameters, a result view, and a query view for predictive analytics algorithms.