Invention Grant
- Patent Title: Scalable index build techniques for column stores
-
Application No.: US15407110Application Date: 2017-01-16
-
Publication No.: US10216777B2Publication Date: 2019-02-26
- Inventor: Artem Oks , Qingqing Zhou , Srikumar Rangarajan , Aleksandras Surna , Wey Guy , Cipri Clinciu , Ashit Gosalia
- 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: Chin IP, PLLC
- Agent Davin Chin
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F9/50 ; H04L12/911

Abstract:
Architecture that includes an index creation algorithm that utilizes available resources and dynamically adjusts to successfully scale with increased resources and be able to do so for any data distribution. The resources can be processing resources, memory, and/or input/output, for example. A finer level of granularity, called a segment, is utilized to process tuples in a partition while creating an index. The segment also aligns with compression techniques for the index. By choosing an appropriate size for a segment and using load balancing the overall time for index creation can be reduced. Each segment can then be processed by a single thread thereby limiting segment skew. Skew is further limited by breaking down the work done by a thread into parallelizable stages.
Public/Granted literature
- US20170124128A1 SCALABLE INDEX BUILD TECHNIQUES FOR COLUMN STORES Public/Granted day:2017-05-04
Information query