发明名称 Method and system decoding user defined functions
摘要 A database engine and optimizer framework includes a decoder to identify and process SQL queries or statements that reference a UDF before they are executed. Once such a statement is detected, the decoder determines if the UDF is capable of being merged into an SQL statement and, if so, performs such a merge. In some embodiments, the decoder may not use a pre-cached version of the UDF but, instead, may include a component that locates and retrieves the latest version of the UDF for use when performing the merge. Also, for UDFs that cannot easily be merged into an SQL statement, the decoder may not merge the UDF into an SQL statement but may allow the optimizer and execution engine to retrieve and execute the UDF in the usual manner.
申请公布号 US7155432(B2) 申请公布日期 2006.12.26
申请号 US20040757787 申请日期 2004.01.15
申请人 INTERNATIONAL BUSINESS MACHINES CORPORATION 发明人 EIKENHORST JOEL DAVID;SANTOSUOSSO JOHN MATTHEW
分类号 G06F17/30;G06F7/00 主分类号 G06F17/30
代理机构 代理人
主权项
地址