Invention Grant
- Patent Title: Salient sampling for query size estimation
-
Application No.: US14298201Application Date: 2014-06-06
-
Publication No.: US09779137B2Publication Date: 2017-10-03
- Inventor: Todd L. Veldhuizen
- Applicant: LogicBlox, Inc.
- Applicant Address: US GA Atlanta
- Assignee: LOGICBLOX INC.
- Current Assignee: LOGICBLOX INC.
- Current Assignee Address: US GA Atlanta
- Agency: Troutman Sanders LLP
- Agent James E. Schutz; Parker D. Hancock
- Main IPC: G06F7/02
- IPC: G06F7/02 ; G06F17/30

Abstract:
Salient sampling for query size estimation includes identifying two or more columns in a database table that have corresponding columns in one or more other tables. One or more hash functions are applied to domains of each of the identified columns. A first hash function is applied to a domain of the first column and a second hash function to a domain of the second column. A subset of the rows in the database table is selected. The selecting includes selecting rows in the database table where results of the first hash function meet a first numeric threshold and selecting rows in the database table where results of the second hash function meet a second numeric threshold. A sample database table corresponding to the database table is created. The sample database table includes the selected subset of the rows in the database table.
Public/Granted literature
- US20150019529A1 SALIENT SAMPLING FOR QUERY SIZE ESTIMATION Public/Granted day:2015-01-15
Information query