The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 22, 2008
Filed:
Oct. 07, 2005
Surajit Chaudhuri, Redmond, WA (US);
Vivek R. Narasayya, Redmond, CA (US);
Rajeev Motwani, Palo Alto, CA (US);
Mayur D. Datar, Stanford, CA (US);
Surajit Chaudhuri, Redmond, WA (US);
Vivek R. Narasayya, Redmond, CA (US);
Rajeev Motwani, Palo Alto, CA (US);
Mayur D. Datar, Stanford, CA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
Aggregation queries are performed by first identifying outlier values, aggregating the outlier values, and sampling the remaining data after pruning the outlier values. The sampled data is extrapolated and added to the aggregated outlier values to provide an estimate for each aggregation query. Outlier values are identified by selecting values outside of a selected sliding window of data having the lowest variance. An index is created for the outlier values. The outlier data is removed from the window of data, and separately aggregated. The remaining data without the outliers is then sampled to provide a statistically relevant sample that is then aggregated and extrapolated to provide an estimate for the remaining data. This sampled estimate is combined with the outlier aggregate to form an estimate for the entire set of data.