Executing stored procedures at parallel databases

A computer system, the computer system comprising:

• one or more processors;
• system memory coupled to the one or more processors, the system memory storing instructions that are executable by the one or more processors;
• and
• the one or more processors executing the instructions stored in the system memory to execute a stored procedure, including the following:
• receive, from a database coordinator, an execution request requesting execution of the stored procedure at the database server, the stored procedure including a data access statement and a non-data access statement, the stored procedure having been transformed by enclosing the data access statement in a command in the stored procedure, the command referencing the database coordinator as a linked server so that when the stored procedure is executed at the database server the data access statement is passed back to the database coordinator;
• and
• split execution of the stored procedure between the database server and the database coordinator, including:
• send a request to execute the data access statement back to the database coordinator based on the command referencing the database coordinator as a linked server, the request requesting execution of the data access statement against a parallel database;
• receive results from the database coordinator, the results derived by executing the data access statement against the parallel database;
• and
• use the results during execution of the non-data access statement at the database server.

A computer program product for use at a computer system, the computer program product for implementing a method for executing a stored procedure, the computer program product comprising one or more computer storage devices having stored thereon computer-executable instructions, which in response to execution at a processor, cause the computer system to perform the method, including the following:

• receive, from a database coordinator, an execution request requesting execution of the stored procedure at the database server, the stored procedure including a data access statement and a non-data access statement, the stored procedure having been transformed at the database coordinator by enclosing the data access statement in a command in the stored procedure, the command referencing the database coordinator as a linked server so that when the stored procedure is executed at the database server the data access statement is passed back to the database coordinator;
• and
• split execution of the stored procedure between the database server and the database coordinator, including:
• send a request to execute the data access statement back to the database coordinator based on the command referencing the database coordinator as a linked server, the request requesting execution of the data access statement against a parallel database;
• receive results from the database coordinator, the results derived by executing the data access statement against the parallel database;
• and
• use the results during execution of the non-data access statement at the database server.