Invention Grant
- Patent Title: Sampling for queries
- Patent Title (中): 查询抽样
-
Application No.: US11296036Application Date: 2005-12-07
-
Publication No.: US07493316B2Publication Date: 2009-02-17
- Inventor: Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
- Applicant: Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method of estimating results of a database query, the results are estimated by performing a sampling of weighted tuples in a database based on a probability of usage of tuples required in executing a workload. A probability is associated with each tuple sampled. An aggregate is computed over values in each sampled tuple while multiplying by the inverses of the probabilities associated with each tuple sampled.
Public/Granted literature
- US20060085410A1 Sampling for queries Public/Granted day:2006-04-20
Information query