Invention Grant
- Patent Title: Deriving cardinality values from approximate quantile summaries
-
Application No.: US15650704Application Date: 2017-07-14
-
Publication No.: US10776368B1Publication Date: 2020-09-15
- Inventor: George Constantin Caragea , Andrew Edward Caldwell , Anurag Windlass Gupta , Michail Petropoulos
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US WA Seattle
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US WA Seattle
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent Robert C. Kowert
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/2458 ; G06F16/2453

Abstract:
Cardinality values can be derived from an approximate quantile summary. An approximate quantile summary can be generated for a column of a database table at data ingestion, data update, upon request, in response to a query, and in various other scenarios. When a query is received that includes a predicate directed to the column of the approximate quantile summary, a cardinality value may be derived from the boundary values of one or more quantiles that include the predicate. The cardinality value may then be used to select a query plan. The query may be performed according to the selected query plan.
Information query