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原型评估了多个系统方面,包括可扩展性、配置影响和跨平台性能比较。我们的结果突显了面向应用的基准测试在为实际场景选择合适的时空数据库系统中的重要性。