Invention Grant
- Patent Title: Method and database computer system for performing a database query using a bitmap index
-
Application No.: US15573079Application Date: 2016-04-28
-
Publication No.: US10810197B2Publication Date: 2020-10-20
- Inventor: Jörg Bienert , Michael Hummel , Norbert Heusser
- Applicant: PARSTREAM GMBH
- Applicant Address: US CA San Jose
- Assignee: Cisco Technology, Inc.
- Current Assignee: Cisco Technology, Inc.
- Current Assignee Address: US CA San Jose
- Agency: Behmke Innovation Group LLC
- Agent James M. Behmke; Jonathon P. Western
- Priority: com.zzzhc.datahub.patent.etl.us.BibliographicData$PriorityClaim@34b2695c
- International Application: PCT/EP2016/059558 WO 20160428
- International Announcement: WO2016/174171 WO 20161103
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/22 ; G06F16/2455

Abstract:
Method and apparatus for performing a database query using a bitmap index in a data-base having a plurality of bitmap vectors, the method comprising the steps of: upon receipt of a query containing a selection condition, creating a filter bitmap based on the query input; performing a bitmap scan for the filter bitmap in order to determine at least one value of an existing matching data-base entry; determining a bitmap of the determined at least one value; creating a filtered bitmap by combining the filter bitmap with the bitmap of the determined at least one value; determining all entries in the database matching the filtered bitmap; sub-tracting the filtered bitmap from the filter bitmap, thus creating a new filter bitmap; repeating the steps, starting with the step of performing a bitmap scan based on the new filter bitmap, until the step of sub-tracting results in an empty bitmap.
Public/Granted literature
- US20180121504A1 METHOD AND DATABASE COMPUTER SYSTEM FOR PERFORMING A DATABASE QUERY USING A BITMAP INDEX Public/Granted day:2018-05-03
Information query