Patent ID: 6507834
Filing Date: 2003-01-14
Classification: G06F,Y10S

Abstract:
A method of parallel execution of SQL in a stored procedure comprising:executing a stored procedure on a first data server; determining when a nested SQL command is encountered in the stored procedure; transmitting at least a portion of the nested SQL command from the first data server to a query coordinator; the query coordinator generating an execution plan that provides for parallel execution of the portion of the nested SQL command; transmitting at least a portion of the execution plan from the query coordinator to a plurality of dispatcher instances on a plurality of data servers; the plurality of dispatchers executing the transmitted portions of the execution plan on the plurality of data servers; the plurality of dispatchers transmitting results from the executed portions of the execution plan to an input stream at an endpoint on the first data server; and the stored procedure obtaining the results at the endpoint from the input stream.