Invention Grant
US07716213B2 Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements
有权
用于有效支持通用SQL数据操作语句的设备,系统和方法
- Patent Title: Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements
- Patent Title (中): 用于有效支持通用SQL数据操作语句的设备,系统和方法
-
Application No.: US11740457Application Date: 2007-04-26
-
Publication No.: US07716213B2Publication Date: 2010-05-11
- Inventor: Curt L. Cotner , Christopher M. Farrar , Robert T. Miller , Maryela E. Weihrauch
- Applicant: Curt L. Cotner , Christopher M. Farrar , Robert T. Miller , Maryela E. Weihrauch
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Kunzler Needham Massey & Thorpe
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.
Public/Granted literature
- US20080270368A1 APPARATUS, SYSTEM, AND METHOD FOR EFFICIENTLY SUPPORTING GENERIC SQL DATA MANIPULATION STATEMENTS Public/Granted day:2008-10-30
Information query