Invention Grant
- Patent Title: Database configuration analysis
- Patent Title (中): 数据库配置分析
-
Application No.: US11275657Application Date: 2006-01-20
-
Publication No.: US07805443B2Publication Date: 2010-09-28
- Inventor: Arnd Christian Konig , Shubha Umesh Nabar
- Applicant: Arnd Christian Konig , Shubha Umesh Nabar
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
To determine a configuration for a database system, a plurality of queries may be sampled from a representative workload using statistical inference to compute the probability of correctly selecting one of a plurality of evaluation configurations. The probability of correctly selecting may determine which and/or how many queries to sample, and/or may be compared to a target probability threshold to determine if more queries must be sampled. The configuration from the plurality of configurations with the lowest estimated cost of executing the representative workload may be determined based on the probability of selecting correctly. Estimator variance may be reduced through a stratified sampling scheme that leverages commonality, such as an average cost of execution, between queries based on query templates. The applicability of the Central Limit Theorem may be verified and used to determine which and/or how many queries to sample.
Public/Granted literature
- US20070174335A1 DATABASE CONFIGURATION ANALYSIS Public/Granted day:2007-07-26
Information query