Distributed Execution of Spatial SQL Queries

被引:0
|
作者
Giannousis, Konstantinos [1 ]
Bereta, Konstantina [1 ]
Karalis, Nikolaos [1 ]
Koubarakis, Manolis [1 ]
机构
[1] Univ Athens, Dept Informat & Telecommun, Athens, Greece
关键词
geospatial; big data; spatial data; apache spark; exareme;
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
The volume of available spatial data that is generated and collected has significantly increased in the last few years. A number of applications based on Map-Reduce-like systems and cloud infrastructure have emerged. These applications offer a variety of features, however they differ in terms of spatial functions, partitioning and indexing. In this paper we present our own implementation that enables spatial support for distributed execution of spatial SQL queries as part of the system Exareme. Then, we evaluate some of the State-of-the-Art existing geospatial distributed systems, emphasizing on systems based on Apache Spark. We conduct detailed functional and performance benchmarks that include corner cases that stress the systems in comparison and reveal their advantages and weaknesses in both functionality and performance.
引用
收藏
页码:528 / 533
页数:6
相关论文
共 50 条
  • [1] Sphinx: Distributed Execution of Interactive SQL Queries on Big Spatial Data
    Eldawy, Ahmed
    Elganainy, Mostafa
    Bakeer, Ammar
    Abdelmotaleb, Ahmed
    Mokbel, Mohamed
    [J]. 23RD ACM SIGSPATIAL INTERNATIONAL CONFERENCE ON ADVANCES IN GEOGRAPHIC INFORMATION SYSTEMS (ACM SIGSPATIAL GIS 2015), 2015,
  • [2] Sphinx: Empowering Impala for Efficient Execution of SQL Queries on Big Spatial Data
    Eldawy, Ahmed
    Sabek, Ibrahim
    Elganainy, Mostafa
    Bakeer, Ammar
    Abdelmotaleb, Ahmed
    Mokbel, Mohamed F.
    [J]. ADVANCES IN SPATIAL AND TEMPORAL DATABASES, SSTD 2017, 2017, 10411 : 65 - 83
  • [3] Distributed Execution of Continuous Queries
    Gupta, Rajeev
    Ramamritham, Krithi
    [J]. 2014 IEEE 30TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2014, : 1306 - 1309
  • [4] Execution of distributed queries in the web environment
    Hu, Gongzhu
    Zhang, David
    [J]. JOURNAL OF COMPUTATIONAL METHODS IN SCIENCES AND ENGINEERING, 2006, 6 (5-6) : S243 - S254
  • [5] OPTIMAL DISTRIBUTED EXECUTION OF JOIN QUERIES
    REID, DJ
    [J]. COMPUTERS & MATHEMATICS WITH APPLICATIONS, 1994, 27 (11) : 27 - 40
  • [6] Execution of distributed queries in the web environment
    Department of Computer Science, Central Michigan University, Pleasant
    MI
    48859, United States
    不详
    MI
    48859, United States
    [J]. J. Comput. Methods Sci. Eng., 2006, 5-6 (S243-S254):
  • [7] Efficient Execution of User-Defined Functions in SQL Queries
    Foufoulas, Yannis
    Simitsis, Alkis
    [J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2023, 16 (12): : 3874 - 3877
  • [8] CorrectMR: Authentication of Distributed SQL Execution on MapReduce
    Zhang, Bo
    Dong, Boxiang
    Wang, Wendy Hui
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2021, 33 (03) : 897 - 908
  • [9] Optimising the distributed execution of join queries in polynomial time
    Reid, DJ
    [J]. COMPUTERS & MATHEMATICS WITH APPLICATIONS, 1999, 37 (03) : 105 - 126
  • [10] Coupling Distributed and Symbolic Execution for Natural Language Queries
    Mou, Lili
    Lu, Zhengdong
    Li, Hang
    Jin, Zhi
    [J]. INTERNATIONAL CONFERENCE ON MACHINE LEARNING, VOL 70, 2017, 70