Invention Grant
- Patent Title: Executing conditions with negation operators in analytical databases
-
Application No.: US14923690Application Date: 2015-10-27
-
Publication No.: US10210223B2Publication Date: 2019-02-19
- Inventor: Thomas F. Boehme , Andreas Brodt , Daniel Martin , Oliver Schiller
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Gilbert Harmon, Jr.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Embodiments of the present invention provide a method and system for processing a query on a set of data blocks in analytical databases. The query is on a set of data blocks, having at least one attribute and specifies at least one selection condition on the attribute. The selection condition is associated with at least one selection expression. Attribute value information on each attribute is generated for each data block. Next, a condition is generated on each attribute to negate the selection expression, if the selection expression has a negation operator. Additional conditions are generated for each selection expression that does not contain a negation operation. The attribute value is used to select the positive and negative subsets of data blocks for each condition. Next, a negative subset that does not require processing to evaluate the query is skipped and the positive subsets and the non-skipped negative subsets are processed.
Public/Granted literature
- US20170116292A1 EXECUTING CONDITIONS WITH NEGATION OPERATORS IN ANALYTICAL DATABASES Public/Granted day:2017-04-27
Information query