Invention Grant
US08447743B2 Techniques for processing database queries including user-defined functions
失效
用于处理数据库查询(包括用户定义的功能)的技术
- Patent Title: Techniques for processing database queries including user-defined functions
- Patent Title (中): 用于处理数据库查询(包括用户定义的功能)的技术
-
Application No.: US10920098Application Date: 2004-08-17
-
Publication No.: US08447743B2Publication Date: 2013-05-21
- Inventor: John M. Santosuosso
- Applicant: John M. Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
A method, system and article of manufacture for query execution management in a data processing system and, more particularly, for managing execution of queries including user-defined functions. One embodiment includes an operation for managing execution of a query against data of a database. The operation includes receiving a query against the data of the database, the query having at least one query condition including a user-defined function. It is determined whether the user-defined function satisfies a predefined index applicability criterion. If the user-defined function satisfies the predefined index applicability criterion, an index over relevant data of the database is created for the user-defined function. The index is suitable for use in execution of the query against the data of the database to determine a corresponding query result.
Public/Granted literature
- US20060041544A1 Techniques for processing database queries including user-defined functions Public/Granted day:2006-02-23
Information query