Invention Grant
- Patent Title: Sampling for queries
- Patent Title (中): 查询抽样
-
Application No.: US11296034Application Date: 2005-12-07
-
Publication No.: US07577638B2Publication Date: 2009-08-18
- 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:
An outlier index for a database and a given workload is generated by identifying sub-relations of tuples in the database induced by selection and group by conditions in queries in the workload. A variance is then generated for values in each sub-relation. Sub-relations having higher variances are selected, and outliers from such sub-relations having higher variances are generated.
Public/Granted literature
- US20060085463A1 Sampling for queries Public/Granted day:2006-04-20
Information query