Patent ID: 9128990
Filing Date: 2015-09-08
Classification: G06F

Abstract:
1. A processor implemented method for executing a stored procedure 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, the method comprising: receiving an execution request requesting execution of a stored procedure, the stored procedure having been transformed by wrapping one or more SQL statements included in the stored procedure in a command that references the parallel database coordinator as a linked server so that the one or more SQL statements are passed backed to the parallel database coordinator when the stored procedure is executed; forwarding the execution request to the standalone database server; receiving a request from the standalone database server to execute a SQL statement, from among the one or more SQL statements, against the parallel database, the request issued from the stored procedure executing at the standalone database server in response to receiving the execution request; 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.