• 文献检索
  • 文档翻译
  • 深度研究
  • 学术资讯
  • Suppr Zotero 插件Zotero 插件
  • 邀请有礼
  • 套餐&价格
  • 历史记录
应用&插件
Suppr Zotero 插件Zotero 插件浏览器插件Mac 客户端Windows 客户端微信小程序
定价
高级版会员购买积分包购买API积分包
服务
文献检索文档翻译深度研究API 文档MCP 服务
关于我们
关于 Suppr公司介绍联系我们用户协议隐私条款
关注我们

Suppr 超能文献

核心技术专利:CN118964589B侵权必究
粤ICP备2023148730 号-1Suppr @ 2026

文献检索

告别复杂PubMed语法,用中文像聊天一样搜索,搜遍4000万医学文献。AI智能推荐,让科研检索更轻松。

立即免费搜索

文件翻译

保留排版,准确专业,支持PDF/Word/PPT等文件格式,支持 12+语言互译。

免费翻译文档

深度研究

AI帮你快速写综述,25分钟生成高质量综述,智能提取关键信息,辅助科研写作。

立即免费体验

分布式时空传感数据处理的查询优化

Query Optimization for Distributed Spatio-Temporal Sensing Data Processing.

作者信息

Li Xin, Yu Huayan, Yuan Ligang, Qin Xiaolin

机构信息

College of Computer Science and Technology, Nanjing University of Aeronautics and Astronautics, Nanjing 211106, China.

State Key Laboratory for Novel Software Technology, Nanjing University, Nanjing 210023, China.

出版信息

Sensors (Basel). 2022 Feb 23;22(5):1748. doi: 10.3390/s22051748.

DOI:10.3390/s22051748
PMID:35270891
原文链接:https://pmc.ncbi.nlm.nih.gov/articles/PMC8915072/
Abstract

The unprecedented development of Internet of Things (IoT) technology produces humongous amounts of spatio-temporal sensing data with various geometry types. However, processing such datasets is often challenging due to high-dimensional sensor data geometry characteristics, complex anomalistic spatial regions, unique query patterns, and so on. Timely and efficient spatio-temporal querying significantly improves the accuracy and intelligence of processing sensing data. Most existing query algorithms show their lack of supporting spatio-temporal queries and irregular spatial areas. In this paper, we propose two spatio-temporal query optimization algorithms based on SpatialHadoop to improve the efficiency of query spatio-temporal sensing data: (1) spatio-temporal polygon range query (STPRQ), which aims to find all records from a polygonal location in a time interval; (2) spatio-temporal nearest neighbors query (STNNQ), which directly searches the query point's closest neighbors. To optimize the STNNQ algorithm, we further propose an adaptive iterative range optimization algorithm (AIRO), which can optimize the iterative range of the algorithm according to the query time range and avoid querying irrelevant data partitions. Finally, extensive experiments based on trajectory datasets demonstrate that our proposed query algorithms can significantly improve query performance over baseline algorithms and shorten response time by 81% and 35.6%, respectively.

摘要

物联网(IoT)技术的空前发展产生了大量具有各种几何类型的时空传感数据。然而,由于高维传感器数据的几何特征、复杂的异常空间区域、独特的查询模式等,处理此类数据集往往具有挑战性。及时高效的时空查询显著提高了处理传感数据的准确性和智能性。大多数现有的查询算法都显示出缺乏对时空查询和不规则空间区域的支持。在本文中,我们提出了两种基于SpatialHadoop的时空查询优化算法,以提高查询时空传感数据的效率:(1)时空多边形范围查询(STPRQ),旨在在一个时间间隔内从多边形位置找到所有记录;(2)时空最近邻查询(STNNQ),直接搜索查询点的最近邻。为了优化STNNQ算法,我们进一步提出了一种自适应迭代范围优化算法(AIRO),它可以根据查询时间范围优化算法的迭代范围,避免查询不相关的数据分区。最后,基于轨迹数据集的大量实验表明,我们提出的查询算法比基线算法能显著提高查询性能,响应时间分别缩短了81%和35.6%。

https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/f95b96d45e30/sensors-22-01748-g012.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/b030289de942/sensors-22-01748-g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/84971586c030/sensors-22-01748-g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/907a9697edd1/sensors-22-01748-g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/d4020ac89a93/sensors-22-01748-g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/406c6c2ee42b/sensors-22-01748-g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/168f49462909/sensors-22-01748-g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/c50651c8a0e7/sensors-22-01748-g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/f1c2f3bbb0c5/sensors-22-01748-g008.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/1ce7fe1bb0a6/sensors-22-01748-g009.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/a1b17da8bf4a/sensors-22-01748-g010.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/df52c47ac429/sensors-22-01748-g011.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/f95b96d45e30/sensors-22-01748-g012.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/b030289de942/sensors-22-01748-g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/84971586c030/sensors-22-01748-g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/907a9697edd1/sensors-22-01748-g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/d4020ac89a93/sensors-22-01748-g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/406c6c2ee42b/sensors-22-01748-g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/168f49462909/sensors-22-01748-g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/c50651c8a0e7/sensors-22-01748-g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/f1c2f3bbb0c5/sensors-22-01748-g008.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/1ce7fe1bb0a6/sensors-22-01748-g009.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/a1b17da8bf4a/sensors-22-01748-g010.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/df52c47ac429/sensors-22-01748-g011.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/b32b/8915072/f95b96d45e30/sensors-22-01748-g012.jpg

相似文献

1
Query Optimization for Distributed Spatio-Temporal Sensing Data Processing.分布式时空传感数据处理的查询优化
Sensors (Basel). 2022 Feb 23;22(5):1748. doi: 10.3390/s22051748.
2
SPEAR: Dynamic Spatio-Temporal Query Processing over High Velocity Data Streams.SPEAR:高速数据流上的动态时空查询处理
Proc Int Conf Data Eng. 2021 Apr;2021:2279-2284. doi: 10.1109/icde51399.2021.00237. Epub 2021 Jun 22.
3
Bidirectional k-nearest neighbor spatial crowdsourcing allocation protocol based on edge computing.基于边缘计算的双向k近邻空间众包分配协议
PeerJ Comput Sci. 2023 Feb 20;9:e1244. doi: 10.7717/peerj-cs.1244. eCollection 2023.
4
EAGLE-A Scalable Query Processing Engine for Linked Sensor Data.EAGLE:用于链接传感器数据的可扩展查询处理引擎。
Sensors (Basel). 2019 Oct 9;19(20):4362. doi: 10.3390/s19204362.
5
A hybrid spatio-temporal data indexing method for trajectory databases.一种用于轨迹数据库的混合时空数据索引方法。
Sensors (Basel). 2014 Jul 21;14(7):12990-3005. doi: 10.3390/s140712990.
6
A Trajectory Privacy Preserving Scheme in the CANNQ Service for IoT.物联网CANNQ服务中的一种轨迹隐私保护方案。
Sensors (Basel). 2019 May 12;19(9):2190. doi: 10.3390/s19092190.
7
Distance-Constraint k-Nearest Neighbor Searching in Mobile Sensor Networks.移动传感器网络中的距离约束k近邻搜索
Sensors (Basel). 2015 Jul 27;15(8):18209-28. doi: 10.3390/s150818209.
8
DISPAQ: Distributed Profitable-Area Query from Big Taxi Trip Data.DISPAQ:基于大型出租车出行数据的分布式盈利区域查询
Sensors (Basel). 2017 Sep 25;17(10):2201. doi: 10.3390/s17102201.
9
A Robotic Context Query-Processing Framework Based on Spatio-Temporal Context Ontology.基于时空上下文本体的机器人上下文查询处理框架。
Sensors (Basel). 2018 Oct 5;18(10):3336. doi: 10.3390/s18103336.
10
Efficient Sensor Scheduling Strategy Based on Spatio-Temporal Scope Information Model.基于时空范围信息模型的高效传感器调度策略。
Sensors (Basel). 2023 Jun 8;23(12):5437. doi: 10.3390/s23125437.

本文引用的文献

1
Hadoop-GIS: A High Performance Spatial Data Warehousing System over MapReduce.Hadoop-GIS:一种基于MapReduce的高性能空间数据仓库系统。
Proceedings VLDB Endowment. 2013 Aug;6(11).
2
Unique in the Crowd: The privacy bounds of human mobility.独一无二的人群:人类流动的隐私边界。
Sci Rep. 2013;3:1376. doi: 10.1038/srep01376.