Oracle Database 20c, is now available for preview on Oracle Cloud (Database Cloud Service Virtual Machine). As with every major release it includes new features and enhancements that further extend its multi-model capabilities.
This post outlines a few of the new (and now free) Spatial features in this release which address ease of use, developer productivity, and performance.
Spatial Studio is a self-service low-code web application. It simplifies the use of the database’s vast array of spatial analysis and query functionality. It makes it easy to create and publish interactive maps to display the results of these queries and analyses. This video shows how to use with Oracle Analytics Cloud.
Newly added support for queries on spatial data stored in the OCI Object Storage service provides more flexibility for developers. They no longer need to load data into Oracle Database before performing spatial analysis on ad hoc data sets. They can keep these data sets in place (as GeoJSON or shapefiles) and run spatial queries directly against them.
Enhanced Spatial support for Database In-Memory (DBIM), in this release, address both ease of use and performance. Spatial filter (sdo_filter) operations can be performed on tables stored in DBIM. Users do not have to create and maintain spatial indexes when spatial tables are stored using Database In-Memory for faster query performance.
The Network Data Model now supports contraction hierarchies. A contraction hierarchy is a precomputed in-memory approach that can significantly speed up path computations. Shortest-path, drive time polygon analysis, and traveling salesperson computations may be between 10 to 100 time faster with this approach. It also enables the execution of more network analyses and concurrent requests with fewer CPUs as compared to previous releases.
In keeping with the Oracle mission to help people see data in new ways, discover insights, unlock endless possibilities the Oracle Database 20c makes it even easier for users to include spatial capabilities in their applications and business workflows.
Watch this introductory video to appreciate just how easy it is to integrate spatial data and analytics into database applications.