MobilityDB: hands on tutorial on managing and visualizing geospatial trajectories in SQL
Authors: 
Esteban Zimányi, Mahmoud Sakr, Mohamed Bakli, Maxime Schomans, Dimitris Tsesmelis, Robin ChoquetAuthors Info & Claims
Article No.: 2, Pages 1 - 2
Abstract
MobilityDB is an open source moving object database. It extends PostgreSQL and PostGIS with types and operations for managing continuous geospatial trajectories. This hand-on tutorial will introduce the attendees to: (1) trajectory data management in MobilityDB, (2) visualization of moving object data in QGIS, and (3) distributed spatiotemporal query processing using MobilityDB. All the tutorial queries will be in SQL.
References
[1]
Louai Alarabi, Mohamed F. Mokbel, and Mashaal Musleh. 2017. ST-Hadoop: A MapReduce Framework for Spatio-Temporal Data. In Proceedings of the 15th International Symposium on Advances in Spatial and Temporal Databases, SSTD 2017. Springer, Arlington, VA, USA, 84--104.
[2]
QGIS.ORG association. 2002--2021. The QGIS project. https://qgis.org/
[3]
Mohamed Bakli, Mahmoud Sakr, and Taysir Hassan A. Soliman. 2019. Hadoop-Trajectory: a Hadoop spatiotemporal data processing extension. Journal of Geographical Systems 21, 2 (2019), 211--235.
[4]
Mohamed Bakli, Mahmoud Sakr, and Esteban Zimanyi. 2019. Distributed Moving Object Data Management in MobilityDB. In Proceedings of the 8th ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data (Chicago, Illinois) (BigSpatial '19). ACM, New York, NY, USA, Article 1, 10 pages.
[5]
Mohamed Bakli, Mahmoud Sakr, and Esteban Zimányi. 2020. Distributed Spatiotemporal Trajectory Query Processing in SQL. In Proceedings of the 28th International Conference on Advances in Geographic Information Systems (Seattle, WA, USA) (SIGSPATIAL '20). ACM, New York, NY, USA, 87--98.
[6]
OGC Open Geospatial Consortium. 2013. OGC Moving Features. https://www.opengeospatial.org/standards/movingfeatures
[7]
Umur Cubukcu, Ozgun Erdogan, Sumedh Pathak, Sudhakar Sannakkayala, and Marco Slot. 2021. Citus: Distributed PostgreSQL for Data-Intensive Applications. In Proc. of the 2021 International Conference on Management of Data, SIGMOD Conference 2021. ACM. To appear.
[8]
X. Ding, L. Chen, Y. Gao, C.S. Jensen, and H. Bao. 2018. UlTraMan: A Unified Platform for Big Trajectory Data Management and Analytics. Proc. of the VLDB Endowment 11, 7 (2018), 787--799.
[9]
Ralf Hartmut Güting, Victor Almeida, Dirk Ansorge, Thomas Behr, Zhiming Ding, Thomas Höse, Frank Hoffmann, Markus Spiekermann, and Ulrich Telle. 2005. SECONDO: An Extensible DBMS Platform for Research Prototyping and Teaching. In Proceedings of the 21st International Conference on Data Engineering, ICDE'05. IEEE Computer Society, 1115--1116.
[10]
Ralf Hartmut Güting, Michael H. Böhlen, Martin Erwig, Christian S. Jensen, Nikos A. Lorentzos, Markus Schneider, and Michalis Vazirgiannis. 2000. A foundation for representing and querying moving objects. ACM Transactions on Database Systems 25, 1 (2000), 1--42.
[11]
Postgres Professional. 2015--2021. PGConf.Online 2021 - Managing moving objects data with MobilityDB. https://pgconf.ru/en/2021/291542
[12]
Maxime SCHOEMANS. 2021. MOVE: QGIS Plugin to display MobilityDB query results. https://github.com/mschoema/move
[13]
Jia Yu, Zongsi Zhang, and Mohamed Sarwat. 2019. Spatial Data Management in Apache Spark: The GeoSpark Perspective and Beyond. Geoinformatica 23, 1 (Jan. 2019), 37--78.
[14]
Zhigang Zhang, Cheqing Jin, Jiali Mao, Xiaolin Yang, and Aoying Zhou. 2017. TrajSpark: A Scalable and Efficient In-Memory Management System for Big Trajectory Data. In Proc. of the APWeb-WAIM Joint Conference on Web and Big Data (Beijing, China). Springer, 11--26.
[15]
Esteban Zimányi, Mahmoud Attia Sakr, and Arthur Lesuisse. 2020. MobilityDB: A Mobility Database Based on PostgreSQL and PostGIS. ACM Transactions on Database Systems 45, 4 (2020), 19:1--19:42.
Index Terms
- MobilityDB: hands on tutorial on managing and visualizing geospatial trajectories in SQL
Recommendations
MobilityDB: A Mobility Database Based on PostgreSQL and PostGIS
SIGMOD 2019 Best Paper, PODS 2019 Best Paper, and Regular PapersDespite two decades of research in moving object databases and a few research prototypes that have been proposed, there is not yet a mainstream system targeted for industrial use. In this article, we present MobilityDB, a moving object database that ...
Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st annual ACM Southeast ConferenceNoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
Indexing in-network trajectory flows
Indexing moving objects (MO) is a hot topic in the field of moving objects databases since many years. An impressive number of access methods have been proposed to optimize the processing of MO-related queries. Several methods have focused on spatio-...
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
Copyright © 2021 Owner/Author.
Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 18 November 2021
Check for updates
Author Tags
Qualifiers
- Abstract
Conference
SIGSPATIAL '21
Sponsor:
SIGSPATIAL '21: 29th International Conference on Advances in Geographic Information Systems
November 2, 2021
Beijing, China
Acceptance Rates
Overall Acceptance Rate 7 of 11 submissions, 64%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 72Total Downloads
- Downloads (Last 12 months)10
- Downloads (Last 6 weeks)0
Reflects downloads up to 23 Nov 2024
Other Metrics
Citations
View Options
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in