Invention Grant
- Patent Title: Optimizing queries using global statistics for distributed databases
-
Application No.: US14631735Application Date: 2015-02-25
-
Publication No.: US09940357B2Publication Date: 2018-04-10
- Inventor: Alan Dale Halverson , Eric R. Robinson , Srinath Shankar , Jeffrey F. Naughton
- 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: Dodd Law Group
- Agent Michael B. Dodd
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present invention extends to methods, systems, and computer program products for formulating global statistics for parallel databases. In general, embodiments of the invention merge (combine) information in multiple compute node level histograms to create a global histogram for a table that is distributed across a number of compute nodes. Merging can include aligning histogram step boundaries across the compute node histograms. Merging can include aggregating histogram step-level information, such as, for example, equality rows and average range rows (or alternately equality rows, range rows, and distinct range rows), across the compute node histograms into a single global step. Merging can account for distinct values that do not appear at one or more compute nodes as well as distinct values that are counted at multiple compute nodes. A resulting global histogram can be coalesced to reduce the step count.
Public/Granted literature
- US20150169688A1 FORMULATING GLOBAL STATISTICS FOR DISTRIBUTED DATABASES Public/Granted day:2015-06-18
Information query