Invention Grant
- Patent Title: Real time query planner statistics with time based changing
-
Application No.: US15384589Application Date: 2016-12-20
-
Publication No.: US10599649B2Publication Date: 2020-03-24
- Inventor: Atri Sharma
- Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Workman Nydegger
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453

Abstract:
Systems are disclosed for modifying weighting of database components by a query planner based on component volatility. The systems obtain a plurality of snapshots of one or more datasets that include one or more data components, and from the plurality of snapshots, the system identifies the volatility of each data component. The systems further generate a plurality of separate dynamic weights for each data component and initiates application of the separate dynamic weights by the query planner to the one or more data components. In some instances, the weights differentially affect the computational cost for query plans based in a time-dependent fashion and are applied prior to calculating costs of the query plans.
Public/Granted literature
- US20180173712A1 REAL TIME QUERY PLANNER STATISTICS WITH TIME BASED CHANGING Public/Granted day:2018-06-21
Information query