Back to results
US 10,649,973 B2Granted
Method for performing in-database distributed advanced predictive analytics modeling via common queries
AssigneeTIBCO Software Inc.
InventorsGeorge R. Butler, Thomas Hill, Vladimir S. Rastunkov
Life of this patent
Estimating the term…
Abstract
A system, method, and computer-readable medium for performing a distributed analytics operation. The distributed analytics operation uses interface technologies to de-couple an actual data storage technology from an implementation of distributed analytics. Such a distributed analytics operation obviates requirements to deploy specific computer code onto a data storage platform to specifically target that platform for distributed predictive analytics computations.
Claims18
A computer-implementable method for performing in-database processing operations, comprising:
- generating an in-database processing operation according to user-selected decision variables and a database source description table;
- instantiating the in-database processing operation within a node of a workspace environment, the node of the workspace environment being located away from a storage system and having a user interface for communicating with a user, the in-database processing operation comprising a storage system-agnostic operation performable without deployment of a storage system-specific agent;
- converting, at the node of the workspace environment, the instantiation of the in-database processing operation to at least one SQL statement;
- providing the at least one SQL statement to the storage system, wherein the at least one SQL statement is executed in-database within the storage system, and wherein the storage system executes a query language for initiating and controlling the in-database execution of the at least SQL statement;
- receiving, at the node of the workspace environment, results from the in-database execution of the at least one SQL statement, wherein the results comprise aggregate values;
- and
- performing, at the node of the workspace environment, mathematical and statistical computations for a predictive analytics modeling operation, the mathematical and statistical computations selected from a plurality of predictive analytics model operation using the aggregate values.
4 more elements
A system for performing in-database processing operations, the system comprising:
- a processor;
- a data bus coupled to the processor;
- and
- a memory comprising instructions executable by the processor and configured for:
- generating an in-database processing operation according to user-selected decision variables and a database source description table;
- instantiating the in-database processing operation within a node of a workspace environment, the node of the workspace environment being located away from a storage system and having a user interface for communicating with a user, the in-database processing operation comprising a storage system-agnostic operation performable without deployment of a storage system-specific agent;
- converting, at the node of the workspace environment, the instantiation of the in-database processing operation to at least one SQL statement;
- providing the at least one SQL statement to the storage system, wherein the at least one SQL statement is executed in-database within the storage system, and wherein the storage system executes a query language for initiating and controlling the in-database execution of the at least SQL statement;
- receiving, at the node of the workspace environment, results from the in-database execution of the at least one SQL statement, wherein the results comprise aggregate values;
- and
- performing, at the node of the workspace environment, mathematical and statistical computations for a predictive analytics modeling operation, the mathematical and statistical computations selected from a plurality of predictive analytics model operations using the aggregate values.
8 more elements
A non-transitory, computer-readable storage medium embodying computer program code, the computer program code comprising computer executable instructions configured for:
- generating an in-database processing operation according to user-selected decision variables and a database source description table;
- instantiating the in-database processing operation within a node of a workspace environment, the node of the workspace environment being located away from a storage system and having a user interface for communicating with a user, the in-database processing operation comprising a storage system-agnostic operation performable without deployment of a storage system-specific agent;
- converting, at the node of the workspace environment, the instantiation of the in-database processing operation to at least one SQL statement;
- providing the at least one SQL statement to the storage system, wherein the at least one SQL statement is executed in-database within the storage system, and wherein the storage system executes a query language for initiating and controlling the In-database execution of the at least SQL statement;
- receiving, at the node of the workspace environment, results from the in-database execution of the at least one SQL statement, wherein the results comprise aggregate values;
- and
- performing, at the node of the workspace environment, mathematical and statistical computations for a predictive analytics modeling operation, the mathematical and statistical computations selected from a plurality of predictive analytics mod& operations using the aggregate values.
4 more elements
Dependencies are inferred from the claim text.