Invention Grant
- Patent Title: Executing stored procedures at parallel databases
- Patent Title (中): 在并行数据库中执行存储过程
-
Application No.: US13831724Application Date: 2013-03-15
-
Publication No.: US09128990B2Publication Date: 2015-09-08
- Inventor: Nikhil Teletia , Alan Dale Halverson , Artem D. Yegorov
- Applicant: Microsoft Corporation
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agent Aneesh Mehta; Kate Drakos; Micky Minhas
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
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.
Public/Granted literature
- US20140280324A1 EXECUTING STORED PROCEDURES AT PARALLEL DATABASES Public/Granted day:2014-09-18
Information query