发明授权
US07289978B2 Substituting parameter markers for literals in database query language statement to promote reuse of previously generated access plans
失效
在数据库查询语言语句中替换文字的参数标记,以促进先前生成的访问计划的重用
- 专利标题: Substituting parameter markers for literals in database query language statement to promote reuse of previously generated access plans
- 专利标题(中): 在数据库查询语言语句中替换文字的参数标记,以促进先前生成的访问计划的重用
-
申请号: US10389315申请日: 2003-03-13
-
公开(公告)号: US07289978B2公开(公告)日: 2007-10-30
- 发明人: Joseph Serge Limoges , Robert A. Begg , Dominique J. Evans , William T. O'Connell , Klaus Bernhard Schiefer , Timothy J. Vincent
- 申请人: Joseph Serge Limoges , Robert A. Begg , Dominique J. Evans , William T. O'Connell , Klaus Bernhard Schiefer , Timothy J. Vincent
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Coporation
- 当前专利权人: International Business Machines Coporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Sawyer Law Group LLP
- 优先权: CA2382714 20020419
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
公开/授权文献
信息查询