Invention Grant
- Patent Title: Database system for executing parameter-sensitive query
- Patent Title (中): 用于执行参数敏感查询的数据库系统
-
Application No.: US14514259Application Date: 2014-10-14
-
Publication No.: US09589017B2Publication Date: 2017-03-07
- Inventor: Nimish S. Khanolkar , Pawel Terlecki , Cesar A. Galindo-Legaria , Yavor V. Angelov , Mostafa Elhemali , Pooja N. Darera
- Applicant: Microsoft Corporation
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agent Aneesh Mehta; Kate Drakos; Micky Minhas
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A query is received. The query comprises a plural number of efficiency expressions. A key is generated for the query indicating a first selectivity region in multi-dimensional selectivity space comprising an array of selectivity regions arranged according to a grid with a number of dimensions equal to the plural number. The generated key is used to look up a stored query plan among a plurality of stored query plans. A stored query plan is executed for the query that is associated with a stored key determined to match the generated key.
Public/Granted literature
- US20150032723A1 DATABASE SYSTEM FOR EXECUTING PARAMETER-SENSITIVE QUERY Public/Granted day:2015-01-29
Information query