US 7,003,512 B1Granted

System and method for multiple pass cooperative processing

AssigneeMicroStrategy Incorporated

InventorsJeffrey A. Bedell, William Hurwood, Benjamin Z. Li, Sadanand Sahasrabudhe, Xinyi Wang, Jun Yuan

Life of this patent

Estimating the term…

Loading patent…

Abstract

A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

Claims21

Dependent claims

A computer-based system for collaborative processing, comprising:

a controlling module operating on computer hardware with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database;
wherein the controlling module performs the following steps:
receiving a request to generate a report based on data in the relational database, the request including at least one multi-step calculation to be performed on data in the relational database;
querying first data in the relational database to resolve a first step of the multi-step calculation;
passing data generated by the querying act to the external analytical engine, wherein the external analytical engine is directed to perform at least one operation on the data;
receiving externally-operated data from the external analytical engine after the at least one operation;
querying the relational database to resolve another step in the multi-step calculation, the query operating on at least part of the first data and at least part of the externally-operated data;
and
generating a report in response to the request after the second querying step has been performed.

6 more elements

A computer-implemented method for collaborative processing in system with access to a relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database, the computer-implemented method comprising the following steps performed on a computer;

receiving at a controlling module external to a relational database a request to generate a report based on data in the relational database, the request including at least one multi-step calculation to be performed on data in the relational database;
querying first data in the relational database to resolve a first step of the multi-step calculation;
passing data generated by the first querying step to the external analytical engine, wherein the external analytical engine is directed to perform at least one operation on the data;
receiving externally-operated data from the external analytical engine after the at least one operation;
querying the relational database to resolve another step in the multi-step calculation, the second query operating on at least part of the fist data and at least part of the externally-operated data;
and
generating a report in response to the request after the second querying step has been performed.

4 more elements

Dependencies are inferred from the claim text.

Facts

Application: 10/912,174Filed 6 Aug 2004 · continuation
Priority: 20 Jun 2001
Granted: 21 Feb 2006
Term ends: Not estimatedThe source records don’t support an estimate.

Classification10 codes

G06Q 10/10
Administration; Management: office automation; Time management
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…
G06F 16/284
Databases characterised by their database models, e.g. relational or object models: relational databases
Y10S 707/99932
Database or file accessing: access augmentation or optimizing

Family

Application09/884,443Parent of this continuation · filed 20 Jun 2001
Application10/043,285Parent of this continuation-in-part · filed 14 Jan 2002
Application10/101,488Parent of this continuation · filed 20 Mar 2002
US 6,820,073 B1Parent of this continuation
Application10/101,488Parent of this continuation-in-part
Application10/043,285Parent of this continuation
US 7,003,512 B1This patent

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