Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-10-30
2007-10-30
Wong, Leslie (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C709S219000
Reexamination Certificate
active
10389315
ABSTRACT:
A method, computer program product and computing device for promoting reuse of previously generated access plans are disclosed. SQL statements containing literals are amended so as to substitute a parameter marker for each literal. Amended statements are provided to the DBMS along with parameters including the substituted literals and a substitution indicator indicating that the substitution has been performed. The DBMS assesses the soundness of the substitutions that are performed. Soundness may be measured in terms of the semantic correctness of the amended statement and the likelihood that the literal substitution will improve DBMS efficiency. If a substitution is unsound, the DBMS may obtain and optimize the original version of the amended SQL statement. Otherwise, the amended statement is optimized. Advantageously, SQL statements originally differing only in the value of one or more literals may become functionally equivalent, and the reuse of cached, previously generated access plans is thus promoted.
REFERENCES:
patent: 5257366 (1993-10-01), Adair et al.
patent: 5596748 (1997-01-01), Kleewein et al.
patent: 5640555 (1997-06-01), Kleewein et al.
patent: 5649168 (1997-07-01), Huang et al.
patent: 5706499 (1998-01-01), Kleewein et al.
patent: 5764949 (1998-06-01), Huang et al.
patent: 5768577 (1998-06-01), Kleewein et al.
patent: 5930793 (1999-07-01), Kleewein et al.
patent: 5943671 (1999-08-01), Kleewein et al.
patent: 5950188 (1999-09-01), Wildermuth
patent: 5987465 (1999-11-01), Kleewein et al.
patent: 5995957 (1999-11-01), Beavin et al.
patent: 6199047 (2001-03-01), Dimino et al.
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6356887 (2002-03-01), Berenson et al.
patent: 6556990 (2003-04-01), Lane
patent: 6567803 (2003-05-01), Ramasamy et al.
patent: 6598038 (2003-07-01), Guay et al.
patent: 6985904 (2006-01-01), Kaluskar et al.
patent: 2283052 (1999-09-01), None
Post SQL (Postgre SQL 7.1 User's Guide, 2001 by Postgre SQL Global Development Group, hereafter “Post SQL”).
Begg Robert A.
Evans Dominique J.
Limoges Joseph Serge
O'Connell William T.
Schiefer Klaus Bernhard
International Business Machines Coporation
Sawyer Law Group LLP
Wong Leslie
LandOfFree
Substituting parameter markers for literals in database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Substituting parameter markers for literals in database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Substituting parameter markers for literals in database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3900490