US 2010/0076977 A1 · System and Method for analyzing and reporting extensible data from multiple sources in multiple formats

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.

Claims17

Dependent claims

An extended online analytical apparatus for one or more data sources wherein each data source has a data format, comprising:

an aggregator that aggregates 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 a data warehouse data model, wherein the virtual schema is a multidimensional data model generated based on the data format of the one or more data sources;
and
an analytical cube generator that generates a multidimensional analytical cube by executing commands from a declarative language against the virtual schema.

1 more element

Dependencies are inferred from the claim text.

Facts

Application

12/630,704Filed 3 Dec 2009

Priority

7 Mar 2005

Published

25 Mar 2010

Term ends

Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 16/283
Databases characterised by their database models, e.g. relational or object models: multi-dimensional databases or data warehouses, e.g. MOLAP or…
Y10S 707/99932
Database or file accessing: access augmentation or optimizing
G06F
Computing and data processing
Y10S
Technical subjects covered by former uspc cross-reference art collections [xracs] and digests

Family

Application60/659,543Us provisional application · filed 7 Mar 2005

Application11/370,522Continuation · filed 7 Mar 2006

Application12/630,704Continuation

US 2007/0022093 A1Published application

US 7,630,956 B2Related patent

US 8,346,811 B2Related patent

US 2010/0076977 A1This patent

From the US filing history. Foreign family members aren’t listed.

System and Method for analyzing and reporting extensible data from multiple sources in multiple formats

Life of this patent

System and Method for analyzing and reporting extensible data from multiple sources in multiple formats

Life of this patent

Abstract

Claims17