Invention Grant
- Patent Title: Representing an outlier value in a non-nullable column as null in metadata
-
Application No.: US14288884Application Date: 2014-05-28
-
Publication No.: US09672241B2Publication Date: 2017-06-06
- Inventor: Garth A. Dickie
- 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
- Agency: Edell, Shapiro & Finnan, LLC
- Agent Erik K. Johnson
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
According to embodiments of the present invention, methods, systems and computer-readable media are presented for accessing data within a database object, wherein an element of the database object is stored among a plurality of different storage regions with each storage region being associated with first and second range values indicating a value range for element values within that storage region. One or more element values within a storage region are identified residing outside a range of values of remaining elements within that storage region. Each identified element value is mapped to a second value. The first and second range values are determined for the storage region in accordance with the range of values of the remaining elements within that storage region. The storage region is scanned in accordance with a comparison of a requested value to at least one of the determined first and second range values of those storage regions.
Public/Granted literature
- US20150347492A1 REPRESENTING AN OUTLIER VALUE IN A NON-NULLABLE COLUMN AS NULL IN METADATA Public/Granted day:2015-12-03
Information query