并行流水线n-join响应时间的优化

Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications Pub Date : 1990-03-07 DOI:10.1109/PARBSE.1990.77187

N. Roussopoulos, L. Tong

{"title":"并行流水线n-join响应时间的优化","authors":"N. Roussopoulos, L. Tong","doi":"10.1109/PARBSE.1990.77187","DOIUrl":null,"url":null,"abstract":"The optimization of the response time in a parallel pipelined join of n relations is formally defined and analyzed. Multiple data-flow streams in the pipeline are captured in a parallel processing tree (PPT) that models both the parallel and the sequential aspects of the pipeline. An optimal PPT achieves minimal first-page response time by balancing the data flow in the pipeline. It is shown that the optimal PPT problem is NP-complete and that only for a very limited set of queries can one obtain optimal PPT. The authors then provide heuristic algorithms for tree and nontree queries that construct a suboptimal PPT. The dynamic feature of the PPT is developed. Experiments have been conducted to verify the performance of the PPT obtained by the heuristic algorithm.<<ETX>>","PeriodicalId":389644,"journal":{"name":"Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications","volume":"26 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1990-03-07","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Optimization of response time in parallel pipelined n-joins\",\"authors\":\"N. Roussopoulos, L. Tong\",\"doi\":\"10.1109/PARBSE.1990.77187\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The optimization of the response time in a parallel pipelined join of n relations is formally defined and analyzed. Multiple data-flow streams in the pipeline are captured in a parallel processing tree (PPT) that models both the parallel and the sequential aspects of the pipeline. An optimal PPT achieves minimal first-page response time by balancing the data flow in the pipeline. It is shown that the optimal PPT problem is NP-complete and that only for a very limited set of queries can one obtain optimal PPT. The authors then provide heuristic algorithms for tree and nontree queries that construct a suboptimal PPT. The dynamic feature of the PPT is developed. Experiments have been conducted to verify the performance of the PPT obtained by the heuristic algorithm.<<ETX>>\",\"PeriodicalId\":389644,\"journal\":{\"name\":\"Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications\",\"volume\":\"26 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1990-03-07\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/PARBSE.1990.77187\",\"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. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/PARBSE.1990.77187","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 1

摘要

正式定义并分析了n个关系的并行管道连接的响应时间优化问题。在并行处理树(PPT)中捕获管道中的多个数据流，该树对管道的并行和顺序方面进行建模。最佳的PPT通过平衡管道中的数据流来实现最小的第一页响应时间。结果表明，最优PPT问题是np完全的，只有在非常有限的查询集合下才能得到最优PPT。然后，作者为构建次优PPT的树和非树查询提供启发式算法。开发了PPT的动态特性。通过实验验证了启发式算法得到的PPT的性能。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Optimization of response time in parallel pipelined n-joins

The optimization of the response time in a parallel pipelined join of n relations is formally defined and analyzed. Multiple data-flow streams in the pipeline are captured in a parallel processing tree (PPT) that models both the parallel and the sequential aspects of the pipeline. An optimal PPT achieves minimal first-page response time by balancing the data flow in the pipeline. It is shown that the optimal PPT problem is NP-complete and that only for a very limited set of queries can one obtain optimal PPT. The authors then provide heuristic algorithms for tree and nontree queries that construct a suboptimal PPT. The dynamic feature of the PPT is developed. Experiments have been conducted to verify the performance of the PPT obtained by the heuristic algorithm.<>

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications

自引率

0.00%

发文量