Invention Grant
- Patent Title: Background index bimapping for faster query performance
- Patent Title (中): 背景索引双击以更快的查询性能
-
Application No.: US12027067Application Date: 2008-02-06
-
Publication No.: US07890495B2Publication Date: 2011-02-15
- Inventor: Paul Reuben Day , Brian Robert Muras
- Applicant: Paul Reuben Day , Brian Robert Muras
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Wood, Herron & Evans, LLP
- Agent James R. Nock
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A database engine and a system running a database engine utilize a dynamic bitmap updating routine to avoid the delay associated with building an entire bitmap. When running a query on a table, the database engine can build a bitmap over a column of the table that helps avoid unnecessary I/O operations to retrieve records. The database engine initializes the bitmap so that all elements have a value of “1”, or active, and proceeds to scan and retrieve the records of the table according to the bitmap using a first process. Any retrieved record is further analyzed to determine if it is part of the result set. Concurrently, a second process is initiated which continually updates the values within the bitmap according to a set of selection criteria. As the first process continues to operate, more and more elements of the bitmap are set to “0”, or inactive, so that the first process can avoid unnecessary I/O operations.
Public/Granted literature
- US20080133470A1 BACKGROUND INDEX BIMAPPING FOR FASTER QUERY PERFORMANCE Public/Granted day:2008-06-05
Information query