System and method for analyzing and reporting extensible data from multiple sources in multiple formats
First Claim
1. An extended online analytical server, comprising:
- one or more adaptors, each adaptor converting one or more pieces of data from a particular data source having a particular data format into the common data format;
an aggregator that aggregates the one or more pieces of data from the data sources to generate aggregated pieces of data;
a virtual schema generator that generates a virtual schema from the aggregated pieces of data;
an indexing engine and a scheduler that update the virtual schema when new pieces of data are received by the aggregator;
an analytical cube generator that generates an analytical cube based on the virtual schema; and
an application programming interface to an external tool wherein the application programming interface permits the external tool to access the piece of data in the analytical cube.
11 Assignments
0 Petitions
Accused Products
Abstract
A system and method for analyzing and reporting data from multiple sources is provided. The system is a foundation for an analytical platform that covers not only traditional relational data, but also a new generation of extensible data formats designed for the web, such as those based on XML (FIXML, FpML, ebXML, XBRL, ACORD, etc.), as well as HTML, E-mail, Excel, PDF, and others. In a preferred embodiment, the eXtensible on-line analytical processing (XOLAP), is a scalable client/server platform that allows the multi-dimensional analysis of modern data types, as well as traditional relational data, by bringing them all into an internal common XML-based model, without the time and expense of creating a data warehouse.
-
Citations
16 Claims
-
1. An extended online analytical server, comprising:
-
one or more adaptors, each adaptor converting one or more pieces of data from a particular data source having a particular data format into the common data format;
an aggregator that aggregates the one or more pieces of data from the data sources to generate aggregated pieces of data;
a virtual schema generator that generates a virtual schema from the aggregated pieces of data;
an indexing engine and a scheduler that update the virtual schema when new pieces of data are received by the aggregator;
an analytical cube generator that generates an analytical cube based on the virtual schema; and
an application programming interface to an external tool wherein the application programming interface permits the external tool to access the piece of data in the analytical cube. - View Dependent Claims (2, 3)
-
-
4. A computer-implemented method for analyzing and reporting data from multiple data sources, the method comprising:
-
storing one or more pieces of data from one or more data sources wherein the data sources include at least relational data sources and non-relational data sources;
converting one or more pieces of data from the data sources into a common data format;
generating an analytical cube based on the one or more pieces of data in the common data format using a declarative language; and
providing an application programming interface to an external tool wherein the application programming interface permits the external tool to access the piece of data in the analytic cube. - View Dependent Claims (5, 6, 7, 8, 9)
-
-
10. An apparatus for analyzing and reporting data from multiple data sources, the apparatus comprising:
-
an adaptor that allows a data source with one or more data items having a particular data format to be loaded into an extended online analytical processing system that converts the data items from the different data sources into a common format and generates a multidimensional analytical cube based on the data items; and
an application programming interface to an external tool wherein the application programming interface permits the external tool to access the piece of data in the analytical cube.
-
-
11. A computer-implemented method for generating dimensional analytical models from extensible data, the method comprising:
-
receiving one or more pieces of data from one or more data sources wherein the data sources include at least one of a relational data source and a non-relational data sources;
converting the one or more pieces of data from the one or more data sources into a common data format;
forming a dimensional analytical model for the one or more pieces of data stored in the common format; and
wherein forming the dimensional analytical model further comprises using a declarative language to describe the dimensional analytical model. - View Dependent Claims (12, 13, 14, 15, 16)
-
Specification