Architecture and algorithm for parallel execution of a join operation

T. Nakayama, M. Hirakawa, T. Ichikawa
{"title":"Architecture and algorithm for parallel execution of a join operation","authors":"T. Nakayama, M. Hirakawa, T. Ichikawa","doi":"10.1109/ICDE.1984.7271268","DOIUrl":null,"url":null,"abstract":"The relational database system ARES which authors have developed can manage semantic aspects of data to be retrieved, and has two types of relations, namely, conventional and semantic relations. The semantic relation is attached to a conventional relation in terms of a join operation every time a flexible interpretation of queries, accepting a certain amount of ambiguity in query conditions, is required. In order to overcome performance degradation caused by the additional join operation, the authors present an algorithm for parallel execution of a join operation assuming an architecture composed of one master unit and n slave units which are linked to each other. Here, relations are distributed to n slave units by means of hash. According to the static analysis of performances, it is expected that the execution efficiency of a join operation is improved by the extent of o(n) and o(n2) compared with the cases of a single processor using hash for restricting source-target pairs of the subrelations, and that not using hash, respectively. Further investigation, however, is needed in a dynamic environment.","PeriodicalId":365511,"journal":{"name":"1984 IEEE First International Conference on Data Engineering","volume":"19 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1984-04-24","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"5","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"1984 IEEE First International Conference on Data Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICDE.1984.7271268","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 5

Abstract

The relational database system ARES which authors have developed can manage semantic aspects of data to be retrieved, and has two types of relations, namely, conventional and semantic relations. The semantic relation is attached to a conventional relation in terms of a join operation every time a flexible interpretation of queries, accepting a certain amount of ambiguity in query conditions, is required. In order to overcome performance degradation caused by the additional join operation, the authors present an algorithm for parallel execution of a join operation assuming an architecture composed of one master unit and n slave units which are linked to each other. Here, relations are distributed to n slave units by means of hash. According to the static analysis of performances, it is expected that the execution efficiency of a join operation is improved by the extent of o(n) and o(n2) compared with the cases of a single processor using hash for restricting source-target pairs of the subrelations, and that not using hash, respectively. Further investigation, however, is needed in a dynamic environment.
并行执行连接操作的体系结构和算法
本文开发的关系数据库系统ARES能够对被检索数据的语义方面进行管理,它有两种关系,即常规关系和语义关系。每当需要对查询进行灵活的解释,接受查询条件中的一定数量的模糊性时,就会通过连接操作将语义关系附加到传统关系上。为了克服额外的连接操作带来的性能下降,作者提出了一种并行执行连接操作的算法,假设一个架构由一个主单元和n个相互连接的从单元组成。在这里,关系通过哈希分布到n个从属单元。根据性能的静态分析,与单处理器使用哈希限制子关系的源目标对和不使用哈希的情况相比,期望连接操作的执行效率分别提高0 (n)和0 (n2)的程度。然而,需要在动态环境中进行进一步的调查。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
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学术文献互助群
群 号:604180095
Book学术官方微信