{"title":"外存储器中二维正交范围聚合的新结果","authors":"Cheng Sheng, Yufei Tao","doi":"10.1145/1989284.1989297","DOIUrl":null,"url":null,"abstract":"We consider the <i>orthogonal range aggregation</i> problem. The dataset <i>S</i> consists of <i>N</i> axis-parallel rectangles in R<sup>2</sup>, each of which is associated with an integer <i>weight</i>. Given an axis-parallel rectangle <i>Q</i> and an aggregate function <i>F</i>, a query reports the aggregated result of the weights of the rectangles in <i>S</i> intersecting <i>Q</i>. The goal is to preprocess <i>S</i> into a structure such that all queries can be answered efficiently. We present indexing schemes to solve the problem in external memory when <i>F</i> = <i>max</i> (hence, <i>min</i>) and <i>F</i> = <i>sum</i> (hence, <i>count</i> and <i>average</i>), respectively. Our schemes have linear or near-linear space, and answer a query in <i>O</i>(log<i><sub>B</sub></i><i>N</i>) or <i>O</i>(log<i>B</i><sup>2</sup>/<i>B</i><i>N</i>) I/Os, where <i>B</i> is the disk block size.","PeriodicalId":92118,"journal":{"name":"Proceedings of the ... ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems","volume":"21 1","pages":"129-139"},"PeriodicalIF":0.0000,"publicationDate":"2011-06-13","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"22","resultStr":"{\"title\":\"New results on two-dimensional orthogonal range aggregation in external memory\",\"authors\":\"Cheng Sheng, Yufei Tao\",\"doi\":\"10.1145/1989284.1989297\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"We consider the <i>orthogonal range aggregation</i> problem. The dataset <i>S</i> consists of <i>N</i> axis-parallel rectangles in R<sup>2</sup>, each of which is associated with an integer <i>weight</i>. Given an axis-parallel rectangle <i>Q</i> and an aggregate function <i>F</i>, a query reports the aggregated result of the weights of the rectangles in <i>S</i> intersecting <i>Q</i>. The goal is to preprocess <i>S</i> into a structure such that all queries can be answered efficiently. We present indexing schemes to solve the problem in external memory when <i>F</i> = <i>max</i> (hence, <i>min</i>) and <i>F</i> = <i>sum</i> (hence, <i>count</i> and <i>average</i>), respectively. Our schemes have linear or near-linear space, and answer a query in <i>O</i>(log<i><sub>B</sub></i><i>N</i>) or <i>O</i>(log<i>B</i><sup>2</sup>/<i>B</i><i>N</i>) I/Os, where <i>B</i> is the disk block size.\",\"PeriodicalId\":92118,\"journal\":{\"name\":\"Proceedings of the ... ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems\",\"volume\":\"21 1\",\"pages\":\"129-139\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2011-06-13\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"22\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the ... ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/1989284.1989297\",\"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 ... ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/1989284.1989297","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 22

摘要

研究正交距离聚合问题。数据集S由R2中的N个轴平行矩形组成,每个矩形都与一个整数权值相关联。给定一个轴平行的矩形Q和一个聚合函数F,查询报告S中与Q相交的矩形权重的聚合结果。目标是将S预处理成一个结构,这样所有查询都可以有效地回答。我们提出了分别解决F = max(因此,min)和F = sum(因此,count和average)时外部存储器中的索引问题的方案。我们的方案具有线性或近线性空间,并且在O(logBN)或O(logB2/BN) I/O中回答查询,其中B是磁盘块大小。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
New results on two-dimensional orthogonal range aggregation in external memory
We consider the orthogonal range aggregation problem. The dataset S consists of N axis-parallel rectangles in R2, each of which is associated with an integer weight. Given an axis-parallel rectangle Q and an aggregate function F, a query reports the aggregated result of the weights of the rectangles in S intersecting Q. The goal is to preprocess S into a structure such that all queries can be answered efficiently. We present indexing schemes to solve the problem in external memory when F = max (hence, min) and F = sum (hence, count and average), respectively. Our schemes have linear or near-linear space, and answer a query in O(logBN) or O(logB2/BN) I/Os, where B is the disk block size.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
CiteScore
4.40
自引率
0.00%
发文量
0
期刊最新文献
Subspace exploration: Bounds on Projected Frequency Estimation. PODS'21: Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, Virtual Event, China, June 20-25, 2021 Computing Optimal Repairs for Functional Dependencies. Relational database behavior: utilizing relational discrete event systems and models Data Citation: a Computational Challenge.
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1