GENERIC SEMANTIC LAYER FOR IN-MEMORY DATABASE REPORTING

• US 20140114906A1
• Filed: 10/23/2012
• Published: 04/24/2014
• Est. Priority Date: 10/23/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Sumanth Hegde, V Santosh
• Inventors: V, Santosh, Hegde, Sumanth
• Granted Patent: US 8,983,900 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

The disclosure generally describes computer-implemented methods, software, and systems for providing a generic semantic layer for in-memory database reporting. One computer-implemented method for combining online transactional processing and online analytical processing in an in-memory database, comprises: retrieving two or more tables from an online transaction processing system; identifying related tables among the two or more tables; determining relationships between the related tables; determining a measure based on the relationships; and outputting the measure.

Claims

1. A system for combining online transactional processing and online analytical processing in an in-memory database, comprising:

the in-memory database that is configured to execute a method comprising;

retrieving two or more tables from an online transaction processing system;

identifying related tables among the two or more tables;

determining relationships between the related tables;

determining a measure based on the relationships; and

outputting the measure.

2. The system of claim 1, wherein the tables of the online transaction processing system are replicated in the in-memory database.

3. The system of claim 1, wherein the method further comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables.

4. The system of claim 3, wherein the business object is a representation of an intelligible business or non-business entity, such as an account, an order, employee, an invoice or a financial report.

5. The system of claim 1, wherein the method further comprises analyzing metadata of the tables to determine the relationships of the related tables.

6. The system of claim 1, wherein the determining of the measure based on the relationships comprises:

identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and

calculating the measure using the relationships of the related tables.

7. The system of claim 1, wherein the outputting of the measure comprises:

associating the measure with a subset of columns and/or rows from the related tables; and

outputting the measure with the subset of columns and/or rows.

8. A method for combining online transactional processing and online analytical processing in an in-memory database, comprising:

retrieving two or more tables from an online transaction processing system;

identifying related tables among the two or more tables;

determining relationships between the related tables;

determining a measure based on the relationships; and

outputting the measure.

9. The method of claim 8, wherein the tables of the online transaction processing system are replicated in the in-memory database.

10. The method of claim 8, wherein the method further comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables.

11. The method of claim 10, wherein the business object is a representation of an intelligible business or non-business entity, such as an account, an order, employee, an invoice or a financial report.

12. The method of claim 8, wherein the method further comprises analyzing metadata of the tables to determine the relationships of the related tables.

13. The method of claim 8, wherein the determining of the measure based on the relationships comprises:

identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and

calculating the measure using the relationships of the related tables.

14. The method of claim 8, wherein the outputting of the measure comprises:

associating the measure with a subset of columns and/or rows from the related tables; and

outputting the measure with the subset of columns and/or rows.

15. A computer-readable medium having computer-executable instructions stored thereon that, when executed by a processor, cause the processor to perform a method for combining online transactional processing and online analytical processing in an in-memory database, comprising:

retrieving two or more tables from an online transaction processing;

identifying related tables among the two or more tables;

determining relationships between the related tables;

determining a measure based on the relationships; and

outputting the measure.

16. The computer-readable medium of claim 15, wherein the tables of the online transaction processing are replicated in the in-memory database.

17. The computer-readable medium of claim 15, wherein the method further comprises determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables.

18. The computer-readable medium of claim 17, wherein the business object is a representation of an intelligible business or non-business entity, such as an account, an order, employee, an invoice or a financial report.

19. The computer-readable medium of claim 15, wherein the method further comprises analyzing metadata of the tables to determine the relationships of the related tables.

20. The computer-readable medium of claim 15, wherein the determining of the measure based on the relationships comprises:

identifying the measure in the related tables based on data types of table columns and based on semantic words used in the tables; and

calculating the measure using the relationships of the related tables.

21. The computer-readable medium of claim 15, wherein the outputting of the measure comprises:

associating the measure with a subset of columns and/or rows from the related tables; and

outputting the measure with the subset of columns and/or rows.

22. A system for combining online transactional processing and online analytical processing in an in-memory database, comprising:

the in-memory database that is configured to execute a method comprising;

retrieving two or more tables from an online transaction processing system, wherein the tables of the online transaction processing system are replicated in the in-memory database;

identifying related tables among the two or more tables, comprising;

determining a business object among the tables that identifies a main table among the tables which provides information for linking the related tables; and

/or

analyzing metadata of the tables to identify the related tables;

determining relationships between the related tables by analyzing the information and/or the metadata;

determining a measure based on the relationships; and

associating the measure with a subset of columns and/or rows from the related tables and outputting the measure with the subset of columns and/or rows.