When people hear about geospatial features, they might think about mobile ad-tech, or even hard science, but location is creeping into applications all around us.
Location is a huge part of fraud detection; telecommunications are more mobile than ever; smart grids are even bringing hyper-locality to the electricity we use. This trend isn’t slowing down; as AI and Machine learning spread into every corner of our lives, our drone deliveries, self-driving rideshares, and virtual assistants will rely all on location and geospatial queries.
VoltDB has native support for geospatial SQL queries such as GEOGRAPHY and GEOGRAPHY_POINT. Geospatial applications work with polygons that define a region (perhaps the boundary of a shopping mall, a sports arena, or a neighborhood or city), and points, which are a latitude/longitude pair defining a specific location (i.e., person or device).
VoltDB also supports a set of geospatial column functions, including CONTAINS, DISTANCE, and AREA among others. Use geospatial indexes for multiple dimensions or use single-dimensional indexes that embed geospatial calculations. Pull coordinates from JSON documents and aggregate them by regions defines in another table. You can even materialize that aggregation.