The rapid growth of spatiotemporal data volumes needs to be handled by database systems capable of efficiently managing and querying such data. Existing systems such as PostGIS, SpaceTime, and MobilityDB offer partial solutions but differ widely in scope and performance. Also, first spatiotemporal benchmarks provide valuable insights but are limited in scope and, to our knowledge, no application-centric benchmarking suite exists. In this paper, we propose GeoBenchr, an open-source, application-centric benchmarking suite for spatiotemporal platforms. GeoBenchr enables comprehensive evaluation across diverse datasets, query types, and workload patterns, reflecting realistic use cases from domains such as cycling, aviation, and maritime tracking. We use our GeoBenchr prototype to evaluate several system aspects including scalability, configuration impact, and cross-platform performance comparison. Our results highlight the importance of application-centric benchmarking in selecting suitable spatiotemporal database systems for real-world scenarios.
翻译:时空数据量的快速增长需要能够高效管理和查询此类数据的数据库系统来处理。现有系统如PostGIS、SpaceTime和MobilityDB提供了部分解决方案,但在范围和性能上存在显著差异。此外,现有的时空基准测试虽能提供有价值的见解,但范围有限,且据我们所知,目前尚不存在面向应用的基准测试套件。本文提出GeoBenchr——一个面向时空平台的开源、以应用为中心的基准测试套件。GeoBenchr支持跨多样化数据集、查询类型和工作负载模式的综合评估,反映了来自骑行、航空和海事追踪等领域的实际用例。我们使用GeoBenchr原型评估了包括可扩展性、配置影响以及跨平台性能比较在内的多个系统维度。我们的研究结果凸显了面向应用的基准测试在为实际场景选择合适的时空数据库系统中的重要性。