OPTIMIZATION BASED METHOD FOR ESTIMATING THE RESULTS OF AGGREGATE QUERIES

Patent №

US 7,120,624

Granted

2006-10-10

Filed 2001

Owner

MICROSOFT CORPORATION

AI components

3

ml · kr · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

09861960

A method for estimating the result of a query on a database having data records arranged in tables. The database has an expected workload that includes a set of queries that can be executed on the database. A sample is constructed by selecting data records for inclusion in the sample in a manner that minimizes an estimation error when the data records are acted upon by a query in the expected workload to provide an estimated result. The query accesses the sample and is executed on the sample, returning an estimated query result. The expected workload can be constructed by specifying a degree of overlap between records selected by queries in the given workload and records selected by queries in the expected workload.

Machine learningKnowledge representationAI hardwareG06F 16/2462G06F 16/24556Y10S 707/99933Y10S 707/99934Y10S 707/99936Y10S 707/99937Y10S 707/99943Y10S 707/99945

AI classification

AI hardware0.98
Machine learning0.57
Knowledge representation0.51
Planning0.49
Evolutionary computation0.11
Natural language0.04
Vision0.00
Speech0.00

Ownership

MICROSOFT CORPORATION

assignment · 118410518

Assignors

CHAUDHURI, SURAJIT, NARASAYYA, VIVEK, DAS, GAUTAM

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC