Invention Grant
- Patent Title: Two-valued logic primitives for SQL query processing
-
Application No.: US16823632Application Date: 2020-03-19
-
Publication No.: US11269874B2Publication Date: 2022-03-08
- Inventor: Pit Fender , Benjamin Schlegel , Alexander Ulrich
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Agent Brian N. Miller
- Main IPC: G06F16/245
- IPC: G06F16/245 ; G06F16/2453

Abstract:
The present invention relates to data manipulation language (DML) acceleration. Herein are database techniques to use value range analysis and range-limited execution operators when a value is excluded. In an embodiment, a computer receives a data access request that specifies an expression that includes operator(s), including a particular operator that has argument(s) that has only three possible values. Before detecting the actual value of a particular argument, the computer detects that a particular value of the three possible values is excluded for the particular argument. Responsively, an implementation of the particular operator that never accepts the particular value for the particular argument is selected. Applying the expression to fulfil the data access request entails invoking the selected implementation of the particular operator.
Public/Granted literature
- US20210294795A1 TWO-VALUED LOGIC PRIMITIVES FOR SQL QUERY PROCESSING Public/Granted day:2021-09-23
Information query