• Home
  • Search
  • Distributed Spatiotemporal Trajectory Query Processing in SQL
  • Cite Icon15
  • https://doi.org/10.1145/3397536.3422262Copy DOI Icon

Distributed Spatiotemporal Trajectory Query Processing in SQL

  • Nov 3, 2020
  • Mohamed Bakli +2 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Nowadays, the collection of moving object data is significantly increasing due to the ubiquity of GPS-enabled devices. Managing and analyzing this kind of data is crucial in many application domains, including social mobility, pandemics, and transportation. In previous work, we have proposed the MobilityDB moving object database system. It is a production-ready system, that is built on top of PostgreSQL and PostGIS. It accepts SQL queries and offers most of the common spatiotemporal types and operations. In this paper, to address the scalability requirement of big data, we provide an architecture and an implementation of a distributed moving object database system based on MobilityDB. More specifically, we define: (1) an architecture for deploying a distributed MobilityDB database on a cluster using readily available tools, (2) two alternative trajectory data partitioning and index partitioning methods, and (3) a query optimizer that is capable of distributing spatiotemporal SQL queries over multiple MobilityDB instances. The overall outcome is that the cluster is managed in SQL at the run-time and that the user queries are transparently distributed and executed. This is validated with experiments using a real dataset, which also compares MobilityDB with other relevant systems.

Similar Papers
  • Research Article
  • Citations4

An effective multilingual retrieval with query optimization using deep learning technique

  • Aug 27, 2022
  • Advances in Engineering Software
  • P Mahalakshmi +3
  • Research Article
  • Citations11

Optimizing complex queries based on similarities of subqueries

  • Feb 02, 2005
  • Knowledge and Information Systems
  • Qiang Zhu +2
  • Research Article

How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches

  • Jul 01, 2025
  • Proceedings of the VLDB Endowment
  • Luca Gretscher +1
  • Book Chapter

A Foundational Service Framework

  • Nov 25, 2009
  • Qi Yu +1
  • Book Chapter
  • Citations1

Advanced Query Optimization

  • Jan 01, 2005
  • Antonio Badia
  • Conference Article
  • Citations12

Towards estimating the number of distinct value combinations for a set of attributes

  • Oct 31, 2005
  • Xiaohui Yu +2
  • Conference Article
  • Citations3

HyDB: Access Optimization for Data-Intensive Service

  • Jun 01, 2012
  • Qing Zhu +1
  • Research Article
  • Citations10

Extraction and optimization of classification rules for temporal sequences: Application to hospital data

  • Feb 01, 2017
  • Knowledge-Based Systems
  • M Vandromme +5
  • Research Article
  • Citations43

Referential integrity quality metrics

  • Jun 23, 2007
  • Decision Support Systems
  • Carlos Ordonez +1
  • Conference Article
  • Citations1

Towards a Multi-engine Query Optimizer for Complex SQL Queries on Big Data

  • Dec 01, 2019
  • Evdokia Kassela +2
  • Conference Article
  • Citations8

Medical Data Inquiry Using a Question Answering Model

  • Apr 01, 2020
  • Zhibin Liao +6
  • Research Article
  • Citations23

Query optimization in compressed database systems

  • May 01, 2001
  • ACM SIGMOD Record
  • Zhiyuan Chen +2
  • Conference Article
  • Citations10

STRUCT

  • May 20, 2012
  • Rajvardhan Patil +1
  • Research Article

AIA: Autoregression-Based Injection Attacks Against Text2SQL Models

  • Apr 11, 2025
  • Proceedings of the AAAI Conference on Artificial Intelligence
  • Deyin Li +4
  • Conference Article
  • Citations4

Privacy Preserving SQL Queries

  • Apr 01, 2008
  • Hyun-A Park +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.