Splitting transaction and analysis queries

Abstract

A system for analysis and transaction processing includes an interface and a processor. The interface is configured to receive a task. The processor is configured to determine a processing estimate associated with the task by determining required resources for a set of possible processing solutions to perform the task and to determine a task engine based at least in part on the processing estimate. The task engine comprises an analysis engine or a transaction engine. The analysis engine or the transaction engine is used to process the task. The processor is further to provide the task to the task engine.

What is claimed is: 
     
         1 . (canceled) 
     
     
         2 . A system for analysis and transaction processing, comprising:
 an interface configured to receive a task; and   a processor configured to:
 determine a processing estimate associated with the task by determining required resources for a set of possible processing solutions to perform the task, comprising to:
 select a processing solution of the set of possible processing solutions; 
 
 determine a task engine based at least in part on the processing estimate, wherein the task engine comprises an analysis engine or a transaction engine, and wherein the analysis engine or the transaction engine is used to process the task; and 
 provide the task to the task engine. 
   
     
     
         3 . The system of  claim 2 , wherein the task comprises a request in code. 
     
     
         4 . The system of  claim 2 , wherein the processing estimate comprises a cost estimate. 
     
     
         5 . The system of  claim 2 , wherein the processing estimate comprises a time estimate. 
     
     
         6 . The system of  claim 2 , wherein the processing estimate comprises a network access cost estimate. 
     
     
         7 . The system of  claim 2 , wherein the processing estimate comprises a network access time estimate. 
     
     
         8 . The system of  claim 2 , wherein the processing estimate comprises a table size estimate. 
     
     
         9 . The system of  claim 2 , wherein the processing estimate comprises a memory usage estimate. 
     
     
         10 . The system of  claim 2 , wherein the required resources comprise required time resources. 
     
     
         11 . The system of  claim 2 , wherein the required resources comprise required memory resources. 
     
     
         12 . The system of  claim 2 , wherein a possible processing solution of the set of possible processing solutions comprises a join type of a plurality of possible join types. 
     
     
         13 . The system of  claim 2 , wherein a possible processing solution of the set of possible processing solutions comprises a scan type of a plurality of scan types. 
     
     
         14 . The system of  claim 13 , wherein the scan type comprises an index search. 
     
     
         15 . The system of  claim 13 , wherein the scan type comprises a brute force search. 
     
     
         16 . The system of  claim 2 , wherein selecting a processing solution of the set of possible processing solutions comprises selecting the processing solution requiring the least resources. 
     
     
         17 . The system of  claim 2 , wherein providing the task to the task engine additionally comprises providing a selected processing solution of the set of possible processing solutions to the task engine. 
     
     
         18 . The system of  claim 2 , wherein determining a task engine based at least in part on the processing estimate comprises comparing the processing estimate with a threshold. 
     
     
         19 . A method for analysis and transaction processing, comprising:
 receiving a task;   determining, using a processor, a processing estimate associated with the task by determining required resources for a set of possible processing solutions to perform the task, comprising:
 selecting a processing solution of the set of possible processing solutions; 
   determining a task engine based at least in part on the processing estimate, wherein the task engine comprises an analysis engine or a transaction engine, and wherein the analysis engine or the transaction engine is used to process the task; and   providing the task to the task engine.   
     
     
         20 . A computer program product for analysis and transaction processing, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
 receiving a task;   determining a processing estimate associated with the task by determining required resources for a set of possible processing solutions to perform the task, comprising:
 selecting a processing solution of the set of possible processing solutions; 
   determining a task engine based at least in part on the processing estimate, wherein the task engine comprises an analysis engine or a transaction engine, and wherein the analysis engine or the transaction engine is used to process the task; and   providing the task to the task engine.