SYSTEMS AND METHODS FOR HIERARCHICAL AGGREGATION OF MULTI-DIMENSIONAL DATA SOURCES
First Claim
1. A method of generating a hierarchical mapping of multi-dimensional data, comprising:
- receiving a data request from at least one application;
identifying a set of multi-dimensional data sources containing data corresponding to the data request;
extracting data corresponding to the data request from the set of multi-dimensional data sources; and
aggregating the extracted data from the multi-dimensional data sources into a hierarchical mapping, the hierarchical mapping combining at least a plurality of the dimensions of the data sources in an ordered hierarchy.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments relate to systems and methods for the hierarchical aggregation of multi-dimensional data sources. A set of applications such as online analytical processing (OLAP) applications can access the combined data of a set of multi-dimensional data sources via a transform engine. The set of data sources can be configured with diverse dimensions and associated data, which in general do not reflect a strictly hierarchical structure. In embodiments, the transform engine can combine or aggregate the set of data sources using common dimensions or data points, and build an index into a transform table reflecting the hierarchical level of dimension from each data source in a combined hierarchical mapping. An OLAP or other application can therefore perform searches, sorts, and/or other operations on the combined hierarchical mapping based on the resulting ordering of data, even when the original multi-dimensional data sources do not contain an explicit common hierarchy.
164 Citations
22 Claims
-
1. A method of generating a hierarchical mapping of multi-dimensional data, comprising:
-
receiving a data request from at least one application; identifying a set of multi-dimensional data sources containing data corresponding to the data request; extracting data corresponding to the data request from the set of multi-dimensional data sources; and aggregating the extracted data from the multi-dimensional data sources into a hierarchical mapping, the hierarchical mapping combining at least a plurality of the dimensions of the data sources in an ordered hierarchy. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system for generating a hierarchical mapping of multi-dimensional data, comprising:
-
an interface to receive a data request from at least one application; a transform engine, communicating with the interface, the transform engine being configured to— identify a set of multi-dimensional data sources containing data corresponding to the data request, extract data corresponding to the data request from the set of multi-dimensional data sources, and aggregate the extracted data from the multi-dimensional data sources into a hierarchical mapping, the hierarchical mapping combining at least a plurality of the dimensions of the data sources in an ordered hierarchy. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A hierarchical data store, the hierarchical data store being generated by a method comprising:
-
receiving a data request from at least one application; identifying a set of multi-dimensional data sources containing data corresponding to the data request; extracting data corresponding to the data request from the set of multi-dimensional data sources; and aggregating the extracted data from the multi-dimensional data sources into a hierarchical mapping, the hierarchical mapping combining at least a plurality of the dimensions of the data sources in an ordered hierarchy. - View Dependent Claims (18, 19, 20, 21, 22)
-
Specification