1.8 Spatial Temporal Query Support for Point Data

Oracle Spatial supports spatiotemporal point data, enabling applications to model, store, index, and query moving objects as first-class database entities.

Oracle Spatial Spatiotemporal Analytics combines spatial and temporal dimensions into a unified query framework. This enables applications to analyze moving objects whose locations change over time using standard SQL, without managing spatial and temporal data separately.

Oracle Spatial Spatiotemporal Analytics provides the following capabilities:

• Native representation of moving point trajectories
• Timestamp-aware spatial indexing
• Integrated spatial and temporal query processing
• Efficient storage of historical object locations
• SQL support for spatiotemporal predicates
• Compatibility with existing Oracle Spatial indexing and query infrastructure

Moving Point Data Model

A moving point represents the changing location of an object over time. It consists of an ordered sequence of timestamped spatial observations that together define the object's trajectory.

A moving point can be represented using either geographic coordinates or a geometry object together with a timestamp. For example: (object_id, longitude, latitude, timestamp) or (object_id, geometry, timestamp).

Each observation records the location of an object at a specific instant. Together, the observations form a trajectory describing the movement of the object through space and time.

This data model supports efficient analysis of moving assets, including vehicles, aircraft, vessels, mobile devices, and IoT sensors, without requiring applications to manage spatial and temporal data separately.

Integrated Spatiotemporal Indexing

Oracle Spatial supports integrated indexing for moving point observations.

Unlike traditional approaches that evaluate spatial and temporal conditions independently, Oracle Spatial processes spatial and temporal predicates together using a unified query framework. This integrated approach reduces unnecessary candidate evaluations and improves query performance for large trajectory datasets.

Applications can perform spatiotemporal analysis using standard SQL while leveraging the existing Oracle Spatial indexing and query infrastructure.