Invention Grant
US08949224B2 Efficient query processing using histograms in a columnar database
有权
使用柱状数据库中的直方图进行有效的查询处理
- Patent Title: Efficient query processing using histograms in a columnar database
- Patent Title (中): 使用柱状数据库中的直方图进行有效的查询处理
-
Application No.: US13742287Application Date: 2013-01-15
-
Publication No.: US08949224B2Publication Date: 2015-02-03
- Inventor: Anurag Windlass Gupta
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US NV Reno
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US NV Reno
- Agency: Meyertons, Hood, Kivlin, Kowert & Goetzel, P.C.
- Agent Robert C. Kowert
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A probabilistic data structure is generated for efficient query processing using a histogram for unsorted data in a column of a columnar database. A bucket range size is determined for multiples buckets of a histogram of a column in a columnar database table. In at least some embodiments, the histogram may be a height-balanced histogram. A probabilistic data structure is generated to indicate for which particular buckets in the histogram there is a data value stored in the data block. When an indication of a query directed to the column for select data is received, the probabilistic data structure for each of the data blocks storing data for the column may be examined to determine particular ones of the data blocks which do not need to be read in order to service the query for the select data.
Public/Granted literature
- US20140201129A1 EFFICIENT QUERY PROCESSING USING HISTOGRAMS IN A COLUMNAR DATABASE Public/Granted day:2014-07-17
Information query