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 associated with one or more data sources, each adaptor converting one or more pieces of data from a particular data source having a particular data format into a common data format;
an aggregator that aggregates the one or more pieces of data from the one or more data sources to generate aggregated pieces of data;
a virtual schema generator that generates a virtual schema from the aggregated pieces of data without a data warehouse and without generating a snowflake data model, wherein the virtual schema is a multidimensional data model generated based on the data format of the one or more data sources;
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 a multidimensional analytical cube by executing commands from a declarative language against 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.
10 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.
46 Citations
15 Claims
-
1. An extended online analytical server, comprising:
-
one or more adaptors associated with one or more data sources, each adaptor converting one or more pieces of data from a particular data source having a particular data format into a common data format; an aggregator that aggregates the one or more pieces of data from the one or more data sources to generate aggregated pieces of data; a virtual schema generator that generates a virtual schema from the aggregated pieces of data without a data warehouse and without generating a snowflake data model, wherein the virtual schema is a multidimensional data model generated based on the data format of the one or more data sources; 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 a multidimensional analytical cube by executing commands from a declarative language against 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, in a server, 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, using one or more adapters that are associated with the server, one or more pieces of data from the data sources into a common data format; generating, using an analytical cube generator associated with the server, a multidimensional analytical cube based on the one or more pieces of data in the common data format using a declarative language executed against a virtual schema that is a multidimensional data model generated based on the data format of the one or more data sources without a data warehouse and without generating a snowflake data model; and providing, on the server, 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 (5, 6, 7, 8, 9)
-
-
10. A computer-implemented method for generating dimensional analytical models from extensible data, the method comprising:
-
receiving, at a server, 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 source; converting, using one or more adapters that are associated with the server, the one or more pieces of data from the one or more data sources into a common data format; forming, using an analytical cube generator associated with the server, a multidimensional analytical model for the one or more pieces of data stored in the common format; and wherein forming the multidimensional analytical model further comprises using a declarative language to describe the multidimensional analytical model by executing commands from the declarative language against a virtual schema that is generated without a data warehouse and without generating a snowflake data model. - View Dependent Claims (11, 12, 13, 14, 15)
-
Specification