发明授权
- 专利标题: Scalable index build techniques for column stores
- 专利标题(中): 列存储的可扩展索引构建技术
-
申请号: US12727266申请日: 2010-03-19
-
公开(公告)号: US08990216B2公开(公告)日: 2015-03-24
- 发明人: Artem Oks , Qingqing Zhou , Srikumar Rangarajan , Aleksandras Surna , Wey Guy , Cipri Clinciu , Ashit Gosalia
- 申请人: Artem Oks , Qingqing Zhou , Srikumar Rangarajan , Aleksandras Surna , Wey Guy , Cipri Clinciu , Ashit Gosalia
- 申请人地址: US WA Redmond
- 专利权人: Microsoft Corporation
- 当前专利权人: Microsoft Corporation
- 当前专利权人地址: US WA Redmond
- 代理商 Ben Tabor; David Andrews; Micky Minhas
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F9/50
摘要:
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.
公开/授权文献
- US20110231403A1 SCALABLE INDEX BUILD TECHNIQUES FOR COLUMN STORES 公开/授权日:2011-09-22
信息查询