Patent ID: 6820073
Filing Date: 2004-11-16
Classification: G06F,Y10S

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; 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; generating a first SQL statement to resolve a first step of the multi-step calculation on first data in the relational database; receiving results from the first SQL statement; passing data generated by the first SQL statement 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; inserting the externally-operated data into a relational database; generating a second SQL statement to resolve another step in the multi-step calculation, the second SQL statement 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 SQL statement has been resolved.