Server side bucketization of parameterized queries

Details Server side bucketization of parameterized queries Server side bucketization of parameterized queries

2011-01-04

2011-01-04

Channavajjala, Srirama (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S791000, C707S802000

Reexamination Certificate

active

07865515

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.

REFERENCES:
patent: 5590324 (1996-12-01), Leung et al.
patent: 5822747 (1998-10-01), Graefe et al.
patent: 5893104 (1999-04-01), Srinivasan et al.
patent: 6006214 (1999-12-01), Carey et al.
patent: 6115705 (2000-09-01), Larson
patent: 6356887 (2002-03-01), Berenson et al.
patent: 6601058 (2003-07-01), Forster et al.
patent: 7254575 (2007-08-01), Li et al.
patent: 7310638 (2007-12-01), Blair
patent: 7395270 (2008-07-01), Lim et al.
patent: 7505985 (2009-03-01), Kilroy
patent: 2003/0154191 (2003-08-01), Fish et al.
patent: 2003/0225759 (2003-12-01), Nonko et al.
patent: 2004/0143581 (2004-07-01), Bohannon et al.
patent: 2005/0222980 (2005-10-01), Lee
patent: 2005/0234878 (2005-10-01), Dettinger et al.
patent: 2006/0224563 (2006-10-01), Hanson et al.
patent: 2008/0033960 (2008-02-01), Banks et al.
patent: 2008/0033967 (2008-02-01), Murthy
patent: 2227339 (1990-07-01), None
Du—Mouza et al., Efficient Evaluation of Parameterized Pattern Queries, Oct. 2005, ACM, pp. 728-735.
Cohen et al., Automatic High-Quality Reengineering of Database Programs by Abstraction, Transformation and Reimplementation, Jul. 2003, vol. 12, Issue 3, pp. 285-316.
Sanjay Kaluskar, et al., “Boost SQL Performance with cursor—sharing”. Oracle Corporation, Jul. 2001. http://www.oracle.com/technology/tech/oci/pdf/cursor—sharing.pdf.

Affiliated with

Also associated with

Rating

Server side bucketization of parameterized queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Server side bucketization of parameterized queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Server side bucketization of parameterized queries will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2705484