二属性无偏、孤立CP定理和大规模并行连接

Miao Qiao, Yufei Tao
{"title":"二属性无偏、孤立CP定理和大规模并行连接","authors":"Miao Qiao, Yufei Tao","doi":"10.1145/3452021.3458321","DOIUrl":null,"url":null,"abstract":"This paper presents an algorithm to process a multi-way join with load $\\tO(n/p^2/(α φ) )$ under the MPC model, where n is the number of tuples in the input relations, α the maximum arity of those relations, p the number of machines, and φ a newly introduced parameter called the \\em generalized vertex packing number. The algorithm owes to two new findings. The first is a \\em two-attribute skew free technique to partition the join result for parallel computation. The second is an \\em isolated cartesian product theorem, which provides fresh graph-theoretic insights on joins with α \\ge 3$ and generalizes an existing theorem on α = 2$.","PeriodicalId":405398,"journal":{"name":"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","volume":"85 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-06-20","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"3","resultStr":"{\"title\":\"Two-Attribute Skew Free, Isolated CP Theorem, and Massively Parallel Joins\",\"authors\":\"Miao Qiao, Yufei Tao\",\"doi\":\"10.1145/3452021.3458321\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper presents an algorithm to process a multi-way join with load $\\\\tO(n/p^2/(α φ) )$ under the MPC model, where n is the number of tuples in the input relations, α the maximum arity of those relations, p the number of machines, and φ a newly introduced parameter called the \\\\em generalized vertex packing number. The algorithm owes to two new findings. The first is a \\\\em two-attribute skew free technique to partition the join result for parallel computation. The second is an \\\\em isolated cartesian product theorem, which provides fresh graph-theoretic insights on joins with α \\\\ge 3$ and generalizes an existing theorem on α = 2$.\",\"PeriodicalId\":405398,\"journal\":{\"name\":\"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems\",\"volume\":\"85 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-06-20\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"3\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3452021.3458321\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3452021.3458321","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 3

摘要

本文在MPC模型下提出了一种处理负载$\ to (n/p^2/(α φ))$的多路连接的算法,其中n为输入关系中的元组个数,α为这些关系的最大次数,p为机器数量,φ为新引入的参数\em广义顶点填充数。该算法得益于两项新发现。第一种是一种无双属性倾斜的技术,用于为并行计算划分连接结果。二是孤立笛卡尔积定理,它提供了关于α = 3$连接的新的图论见解,并推广了关于α = 2$的已有定理。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
Two-Attribute Skew Free, Isolated CP Theorem, and Massively Parallel Joins
This paper presents an algorithm to process a multi-way join with load $\tO(n/p^2/(α φ) )$ under the MPC model, where n is the number of tuples in the input relations, α the maximum arity of those relations, p the number of machines, and φ a newly introduced parameter called the \em generalized vertex packing number. The algorithm owes to two new findings. The first is a \em two-attribute skew free technique to partition the join result for parallel computation. The second is an \em isolated cartesian product theorem, which provides fresh graph-theoretic insights on joins with α \ge 3$ and generalizes an existing theorem on α = 2$.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信