Invention Grant
- Patent Title: Server side bucketization of parameterized queries
- Patent Title (中): 参数化查询的服务器端桶化
-
Application No.: US11467802Application Date: 2006-08-28
-
Publication No.: US07865515B2Publication Date: 2011-01-04
- Inventor: Adrian Birka , Ganapathy Subramaniam Krishnamoorthy
- Applicant: Adrian Birka , Ganapathy Subramaniam Krishnamoorthy
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Turocy & Watson, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Efficient server-side query statement parameter bucketization is provided for a query language, such as the structured query language (SQL). A process is applied for replacing the parameters of a parameterized query with new parameters, whose types are normalized to enable more query execution plan sharing. In one embodiment, in response to receiving a parameterized query expression of a query language, the bucketization process operates to bucketize parameter(s) of the parameterized expression based on the type(s) of the parameter(s) by replacing the type(s) with new broader, or more specific, type(s). An existing server-side parameterization framework that includes a mechanism for determining when parameterization is “safe,” is extended, and is applied to bucketize parameters by using the mechanism to determine when replacing a parameter(s) of parameterized expressions with new parameter(s) of different type(s) is safe.
Public/Granted literature
- US20080065589A1 SERVER SIDE BUCKETIZATION OF PARAMETERIZED QUERIES Public/Granted day:2008-03-13
Information query