System and method of relating data and generating reports
First Claim
Patent Images
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 Assignments
0 Petitions
Accused Products
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.
40 Citations
20 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
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.
-
Specification