System and method of relating data and generating reports

• US 8,650,150 B2
• Filed: 03/14/2011
• Issued: 02/11/2014
• Est. Priority Date: 03/14/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Zhao, Jie, Dong, Bin, Chen, Yingyu, Xu, Xin
• Primary Examiner(s): Breene, John E
• Assistant Examiner(s): LODHI, ANDALIB FT
• Application Number:
  US13/047,573
• Publication Number:
  US 20120239609A1
• Time in Patent Office: 1,065 Days
• Field of Search: 707/600, 707/603, 707/607
• US Class Current: 707/600
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06Q 10/0637 Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals

Abstract

In one embodiment the present invention includes a computer implemented method of relating data and generating reports. The method includes storing, by an OLAP system, a network data structure that relates a plurality of data objects. The method further includes storing transactional data in an in-memory database in the OLAP system. The method further includes generating, by the OLAP system, a report using the stored transactional data according to the network data structure. In this manner, deficiencies of the traditional star schema paradigm of data warehousing may be avoided.

Claims

1. A computer implemented method of relating data and generating reports, comprising:

providing an online analytical processing (OLAP) system that includes an in-memory database, wherein the in-memory database stores data in a volatile memory and not persistently on a hard drive;

storing, by the OLAP system, a network data structure that relates a plurality of data objects, wherein the network data structure includes a table having a plurality of columns, wherein the plurality of columns includes a first column for a first data object, a second column for a second data object, a third column for a relationship type that defines how underlying database tables for the first data object and the second data object are joined during runtime data extraction, a fourth column for a forward navigation method for navigating from the first data object to the second data object, and a fifth column for a reverse navigation method for navigating from the second data object to the first data object;

storing transactional data in the in-memory database in the OLAP system as stored transactional data; and

generating, by the OLAP system, a report using the stored transactional data according to the network data structure.

2. The method of claim 1, further comprising:

providing an online transaction processing (OLTP) system; and

additionally storing the transactional data in a relational database in the OLTP system.

3. The method of claim 1, further comprising:

providing an online transaction processing (OLTP) system having a hard drive and a volatile memory; and

additionally storing the transactional data in a relational database in the OLTP system, wherein the OLTP system implements the relational database by storing the transactional data using the hard drive and caching the transactional data using the memory.

4. The method of claim 1, wherein the OLAP system implements the in-memory database using solid state devices.

5. The method of claim 1, wherein the relationship relates the first data object and the second data object.

6. The method of claim 1, wherein the relationship relates the first data object and the second data object, wherein the first data object contains a first dimension and a first key figure, and wherein the second data object contains a second dimension and a second key figure.

7. The method of claim 1, wherein the plurality of data objects correspond to tables in an online transaction processing (OLTP) system that the OLTP system delivers as business content metadata to the OLAP system.

8. The method of claim 1, wherein a data object of the plurality of data objects includes an attribute serving as a characteristic in the report.

9. The method of claim 1, wherein a data object of the plurality of data objects includes an attribute serving as a key figure in the report.

10. The method of claim 1, wherein a data object of the plurality of data objects includes an attribute serving as a key figure in the report, wherein the key figure defines a statistical calculation performed on the attribute.

11. The method of claim 1, wherein a data object of the plurality of data objects includes an attribute that triggers a second report.

12. The method of claim 1, wherein a data object of the plurality of data objects includes an attribute serving as a selector in the report.

13. The method of claim 1, wherein storing the transactional data comprises continuously storing the transactional data.

14. The method of claim 1, wherein storing the transactional data comprises storing the transactional data in a columnar format in the in-memory database.

15. The method of claim 1, wherein the network data structure is not a star schema in that the first and second data objects are linked by the relationship that is not a mere connection between a fact table and dimension tables as in the star schema.

16. The method of claim 1, wherein the network data structure includes a complex relationship, wherein the complex relationship includes information related to the forward navigation method and the reverse navigation method that are not symmetric.

17. The method of claim 1, wherein the in-memory database stores the transactional data in the volatile memory and not persistently in the hard drive.

18. The method of claim 1, wherein the forward navigation method has an input, has an output, and controls how the first object type is linked to the second object type, wherein the input is one or more keys of the first object type and the output is one or more keys of the second object type.

19. A computer program, embodied on a non-transitory recording medium, for controlling a computer system to relate data and generate reports, the computer program comprising:

an online analytical processing (OLAP) component that is configured to control an OLAP system that includes an in-memory database, wherein the in-memory database stores data in a volatile memory and not persistently on a hard drive, wherein the OLAP component is configured to control the OLAP system to store a network data structure that relates a plurality of data objects, wherein the network data structure includes a table having a plurality of columns, wherein the plurality of columns includes a first column for a first data object, a second column for a second data object, a third column for a relationship type that defines how underlying database tables for the first data object and the second data object are joined during runtime data extraction, a fourth column for a forward navigation method for navigating from the first data object to the second data object, and a fifth column for a reverse navigation method for navigating from the second data object to the first data object, and wherein the OLAP component is configured to control the OLAP system to store transactional data in the in-memory database in the OLAP system as stored transactional data; and

a reporting component that is configured to control the OLAP system to generate a report using the stored transactional data according to the network data structure.

20. A system for controlling a computer system to relate data and to generate reports, comprising:

an online analytical processing (OLAP) server that implements an OLAP system including a processor and an in-memory database, wherein the in-memory database stores data in a volatile memory and not persistently on a hard drive, and wherein the OLAP server is configured to execute processing including;

storing a network data structure that relates a plurality of data objects, wherein the network data structure includes a table having a plurality of columns, wherein the plurality of columns includes a first column for a first data object, a second column for a second data object, a third column for a relationship type that defines how underlying database tables for the first data object and the second data object are joined during runtime data extraction, a fourth column for a forward navigation method for navigating from the first data object to the second data object, and a fifth column for a reverse navigation method for navigating from the second data object to the first data object,

storing transactional data in the in-memory database as stored transactional data, and

generating a report using the stored transactional data according to the network data structure.