EXECUTING STORED PROCEDURES AT PARALLEL DATABASES

摘要

The present invention extends to methods, systems, and computer program products for executed stored procedures at parallel databases. Stored procedures are transformed so that execution of the stored procedure is split between a standalone database server and a parallel database coordinator. Execution of the stored procedure is initiated at the standalone database server. At execution time, control-flow statements, variable assignment, expression evaluation, etc., are handled by the standalone database server. SQL statements are passed from the standalone database server to the database for the execution. Results from executed SQL statements can be returned to the standalone database server or to a client. The parallel database coordinator can be added as a linked server to the standalone database server. In some embodiments, a session token is used to share session state between different parties.

主权项

1. At a computer system, the computer system including a parallel database coordinator, the parallel database coordinator configured to issue SQL statements against a parallel database, the parallel database including a plurality of database partitions spread across a plurality of compute nodes, the parallel database coordinator connected to an instance of standalone database server, a method for executing a stored procedure, the method comprising:
receiving an execution request, the execution request requesting execution of a previously created stored procedure; forwarding the execution request to the standalone database server; receiving a request from the standalone database server to execute a SQL statement against the parallel database, the request issued from a corresponding transformed stored procedure executing at the standalone database server in response to receiving the execution request, the transformed stored procedure including one or more SQL statements and at least one other non-SQL statement, the standalone database server handling execution of the at least one other non-SQL statement; executing the SQL statement against the parallel database; receiving results from executing the SQL statement against the parallel database; and returning the results to an appropriate destination based on the type of the SQL statement.