demonstration

MobilityDB: A Mainstream Moving Object Database System

Authors:

Esteban Zimányi,

Mahmoud Sakr,

Arthur Lesuisse,

Mohamed BakliAuthors Info & Claims

SSTD '19: Proceedings of the 16th International Symposium on Spatial and Temporal Databases

Pages 206 - 209

https://doi.org/10.1145/3340964.3340991

Published: 19 August 2019 Publication History

Get Access

Abstract

This paper demonstrates the MobilityDB moving object database system. It is an extensive implementation on top of PostgreSQL and PostGIS with multiple novel aspects. MobilityDB defines multiple spatiotemporal types for moving geometry and geography points, as well as for temporal integers, reals, Booleans, and strings. It also defines a rich set of operations on these types. The types are supported with spatiotemporal index access methods by extending GiST (Generalized Search Tree) and SP-GiST (Space Partitioning GiST). The query interface is SQL. MobilityDB thus extends the PostgreSQL optimizer with statistics collectors and selectivity estimation functions. It is available as open source. The demonstration includes a scenario with multiple queries, and a publicly accessible query interface on the Web.

References

[1]

Christian Düntgen, Thomas Behr, and Ralf Hartmut Güting. 2009. BerlinMOD: a benchmark for moving object databases. The VLDB Journal 18, 6 (2009), 1335--1368.

Digital Library

Google Scholar

[2]

Luca Forlizzi, Ralf Hartmut Güting, Enrico Nardelli, and Markus Schneider. 2000. A data model and data structures for moving objects databases. In SIGMOD '00: Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data. ACM, New York, NY, USA, 319--330.

Digital Library

Google Scholar

[3]

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 ICDE '05: Proceedings of the 21st International Conference on Data Engineering. IEEE Computer Society, Washington, DC, USA, 1115--1116.

Digital Library

Google Scholar

[4]

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 Trans. Database Syst. 25, 1 (2000), 1--42.

Digital Library

Google Scholar

[5]

Nikos Pelekis, Elias Frentzos, Nikos Giatrakos, and Yannis Theodoridis. 2015. HERMES: A Trajectory DB Engine for Mobility-Centric Applications. International Journal of Knowledge-Based Organizations 5, 2 (2015), 19--41.

Digital Library

Google Scholar

Cited By

View all

Yang YZuo XZhao KLi Y(2024)Non-Uniform Spatial Partitions and Optimized Trajectory Segments for Storage and Indexing of Massive GPS Trajectory DataISPRS International Journal of Geo-Information10.3390/ijgi1306019713:6(197)Online publication date: 12-Jun-2024
https://doi.org/10.3390/ijgi13060197
Heinz F(2024)Robust Interpolation of Arbitrary-Dimensional Moving Regions in DatabasesProceedings of the 3rd ACM SIGSPATIAL International Workshop on Searching and Mining Large Collections of Geospatial Data10.1145/3681769.3698579(13-21)Online publication date: 29-Oct-2024
https://dl.acm.org/doi/10.1145/3681769.3698579
Garcez Duarte MSakr M(2024)An experimental study of existing tools for outlier detection and cleaning in trajectoriesGeoInformatica10.1007/s10707-024-00522-yOnline publication date: 18-May-2024
https://doi.org/10.1007/s10707-024-00522-y
Show More Cited By

Index Terms

MobilityDB: A Mainstream Moving Object Database System
1. Information systems
  1. Information systems applications
    1. Spatial-temporal systems

Recommendations

MobilityDB: hands on tutorial on managing and visualizing geospatial trajectories in SQL
SpatialAPI '21: Proceedings of the 3rd ACM SIGSPATIAL International Workshop on APIs and Libraries for Geospatial Data Science

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: A Mobility Database Based on PostgreSQL and PostGIS
SIGMOD 2019 Best Paper, PODS 2019 Best Paper, and Regular Papers

Despite 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 ...
Distributed moving object data management in MobilityDB
BigSpatial '19: Proceedings of the 8th ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data

The availability of moving object data that is being collected nowadays, and the demand of using them in applications, have generated the need for spatiotemporal data management systems. MobilityDB is an open source moving object database system. Its ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

SSTD '19: Proceedings of the 16th International Symposium on Spatial and Temporal Databases

August 2019

245 pages

ISBN:9781450362801

DOI:10.1145/3340964

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.

In-Cooperation

TU Wien: TU Wien

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 19 August 2019

Check for updates

Author Tags

Qualifiers

Demonstration
Research
Refereed limited

Funding Sources

Innoviris

Conference

SSTD '19

SSTD '19: 16th International Symposium on Spatial and Temporal Databases

August 19 - 21, 2019

Vienna, Austria

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

11
Total Citations
View Citations
208
Total Downloads

Downloads (Last 12 months)21
Downloads (Last 6 weeks)2

Reflects downloads up to 16 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Yang YZuo XZhao KLi Y(2024)Non-Uniform Spatial Partitions and Optimized Trajectory Segments for Storage and Indexing of Massive GPS Trajectory DataISPRS International Journal of Geo-Information10.3390/ijgi1306019713:6(197)Online publication date: 12-Jun-2024
https://doi.org/10.3390/ijgi13060197
Heinz F(2024)Robust Interpolation of Arbitrary-Dimensional Moving Regions in DatabasesProceedings of the 3rd ACM SIGSPATIAL International Workshop on Searching and Mining Large Collections of Geospatial Data10.1145/3681769.3698579(13-21)Online publication date: 29-Oct-2024
https://dl.acm.org/doi/10.1145/3681769.3698579
Garcez Duarte MSakr M(2024)An experimental study of existing tools for outlier detection and cleaning in trajectoriesGeoInformatica10.1007/s10707-024-00522-yOnline publication date: 18-May-2024
https://doi.org/10.1007/s10707-024-00522-y
Silva ADantas ARocha RLopes FCacho N(2023)An End-to-End Framework for Moving Objects in Smart Cities2023 IEEE International Smart Cities Conference (ISC2)10.1109/ISC257844.2023.10293425(1-7)Online publication date: 24-Sep-2023
https://doi.org/10.1109/ISC257844.2023.10293425
Bao YHuang ZGong XZhang YYin GWang H(2023)Optimizing segmented trajectory data storage with HBase for improved spatio-temporal query efficiencyInternational Journal of Digital Earth10.1080/17538947.2023.219297916:1(1124-1143)Online publication date: 5-Apr-2023
https://doi.org/10.1080/17538947.2023.2192979
Alam MTorgo LBifet A(2022)A Survey on Spatio-temporal Data Analytics SystemsACM Computing Surveys10.1145/3507904Online publication date: 14-Jan-2022
https://doi.org/10.1145/3507904
Sakr MZimányi EVaisman ABakli M(2022) User‐centered road network traffic analysis with MobilityDB Transactions in GIS10.1111/tgis.1297227:2(323-346)Online publication date: 24-Aug-2022
https://doi.org/10.1111/tgis.12972
Sakr MRay CRenso C(2022)Big mobility data analytics: recent advances and open problemsGeoInformatica10.1007/s10707-022-00483-026:4(541-549)Online publication date: 18-Nov-2022
https://doi.org/10.1007/s10707-022-00483-0
de Wynckel MSigner B(2021)Indoor Positioning Using the OpenHPS Framework2021 International Conference on Indoor Positioning and Indoor Navigation (IPIN)10.1109/IPIN51156.2021.9662569(1-8)Online publication date: 29-Nov-2021
https://doi.org/10.1109/IPIN51156.2021.9662569
Bakli MSakr MZimanyi E(2020)Distributed Mobility Data Management in MobilityDB2020 21st IEEE International Conference on Mobile Data Management (MDM)10.1109/MDM48529.2020.00052(238-239)Online publication date: Jun-2020
https://doi.org/10.1109/MDM48529.2020.00052
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

MobilityDB: hands on tutorial on managing and visualizing geospatial trajectories in SQL

MobilityDB: A Mobility Database Based on PostgreSQL and PostGIS

Distributed moving object data management in MobilityDB