Invention Grant
- Patent Title: Scalable implementations of multi-dimensional aggregations with input blending in distributed query processing systems
-
Application No.: US16206934Application Date: 2018-11-30
-
Publication No.: US11256686B2Publication Date: 2022-02-22
- Inventor: Sreenivasa Viswanadha
- 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: Fiala & Weaver P.L.L.C.
- Main IPC: G06F16/242
- IPC: G06F16/242 ; G06F16/2458 ; G06F16/22 ; G06F16/27 ; G06F16/28

Abstract:
Systems and devices implement scalable implementations of multi-dimensional aggregations with input blending in distributed query processing systems. Multi-dimensional aggregations for identifiers/values designated fields in datasets are performed based on keys. Datasets are sorted by identifier/value and divided into first partitions. Each row of data with a specific sorted-by-identifier/value is only present in one of the first partitions. Keys are generated from each combination of two or more dataset fields, and a blended table of data is generated over the partitions based on each different key combination. Designated data field characteristics are determined for the blended table based on the different key combinations. The characteristics are divided into second partitions based on the keys, where each key is present in only one of the second partitions. A final designated data field characteristic is determined for each row of data in each of the second partitions as the multi-dimensional aggregation.
Public/Granted literature
Information query