X

Oracle Spatial and Graph – technical tips, best practices, and news from the product team

Spatial now included with all editions of Oracle Database

James Steiner
Vice President

In keeping with the Oracle mission to help people see data in new ways, discover insights, unlock endless possibilities, customers wishing to use the Machine Learning, Spatial and Graph features of Oracle Database are no longer required to purchase additional licenses.  

For decades, Oracle Database has included industry-leading multi-model and analytic capabilities.  Oracle’s converged database architecture supports multiple data types and data models (e.g. spatial, graph, JSON, XML) and algorithms (e.g. machine learning, graph and statistical functions) and workload types (e.g. operational and analytical) within a single database.  While many of these capabilities are included in Oracle Database products and cloud services today, it is our goal that all developers have the ability to use these advanced development APIs. The core spatial features in Oracle Spatial have been included in Oracle Database Locator feature for over a decade. Now, all Oracle Spatial capabilities are available with both Enterprise Edition and Standard Edition 2.

All Spatial features are included

Spatial features now available for development and deployment with Oracle Database includes:

  • 2D and 3D geometry data types to represent locations, regions, and other geometries
  • All spatial functions and operators 
  • Map authoring tools 
  • Sensor and imagery data support with Point Cloud, LiDAR and GeoRaster data types and operators 
  • Networks and parcel data management with Linear Referencing, Network and Topology data models 
  • Geocoder, Routing Server, Tracking Server, Map Server 
  • Open Geospatial Consortium web service APIs
    and
  • Spatial Studio, a self-service, no-code/low-code map canvas and spatial analysis tools 

What you can do with Spatial

At the simplest level,  spatial analysis enables better understanding of complex interactions based on geographic relationships.  This can be important to virtually every application; it can help provide better customer service, optimize the workforce, easily locate retail and distribution centers, evaluate sales and marketing campaigns, just to name a few!

Every Oracle Database now includes comprehensive spatial analytics and data models.  For traditional business analysis, you can perform queries based on proximity (how near or far something may be) and containment (whether something is within or outside a given region).  In fact, there are hundreds of functions and operations to filter data, measure distance relationships, and combine and/or transform geometries.  Powerful visualization and self-service map-based analysis tools and APIs let developers, data scientists and analysts easily benefit from these capabilities.  For example, Neustar, a real-time provider of cloud-based information systems and data analytics, gives clients spatially-informed marketing insights for retail site analysis, market potential sizing, marketing campaign creation, and more to acquire and retain customers and improve site location strategies. 

For more specialized analysis and applications, often referred to as GIS or geographic information systems, the spatial features in Oracle Database also support large scale and complex geospatial applications.  For example, a global construction and engineering firm uses Oracle Database spatial features to manage survey data and ensure they are consistent and properly aligned.  These precise measurements, based on weather sensor data, are collected and validated for renewable solar energy projects.

Other spatial use cases include:

  • The US Census Bureau ensures that every land parcel and geographic feature such as roads, railroads, geographic areas, landmarks, waterways and other relevant geographic information is accurately captured, seamlessly merging geospatial data (with associated feature attributes) with non-spatial residential and business address datasets. 
  • Ordnance Survey Ireland (OSi), the Irish national mapping agency, maintains national spatial data sets and creates mapping products for government agencies and the public.  This includes remotely sensed data, point clouds, aerial photos and satellite imagery, needing to automate complex workflow processes, and sharing data widely with the public. OSi addressed these challenges with the Oracle Cloud Infrastructure (OCI), Oracle Spatial and Graph, and Oracle Exadata platform.  

Oracle Database now makes it easy for developers to add spatial capabilities to applications using modern application frameworks  with standards-based SQL and Java APIs, JSON and REST support, and integration with database tools, analytics, and applications. Watch this introductory video to appreciate just how easy it is to integrate spatial data and analytics into database applications. 

 

 

 

 


Join the discussion

Comments ( 6 )
  • Buck Sunday, December 22, 2019
  • Simon Greener Sunday, December 22, 2019
    Jim,

    Thanks to you, and to Oracle, for this momentous news.

    I hope this creates new opportunities for Oracle and the Spatial team.

    Regards
    Simon Greener
  • Roy Reijnen Monday, December 30, 2019
    It is nice that Spatial is free for all editions but I don't see specified for which versions this is applicable or is it applicable for all versions? This makes the message complete.
  • Jim Steiner Thursday, January 2, 2020
    Thank you for your comments.

    Here are some answers to your questions:

    -All licensed users of Oracle Database EE under Premier or Extended Support, Oracle Database SE2, and Oracle Database Cloud Service (all editions) are now licensed to use these options. (SE, and SE1 will not include these features).

    This will include Oracle Cloud Free Tier as well.

    For SE2 and some of the Cloud Service tiers may require patches/updates that are being applied shortly (if they are not already in place). Customers with ULAs should consult their sales reps regarding version support.
  • Andrew Keating Thursday, January 9, 2020
    This is great news, in the past many clients made DB architecture decisions to reduce licensing costs (separating out areas requiring spatial).

    Does this change only apply to 19c and onwards? Or all versions?

    Thanks!
  • Jim Steiner Thursday, January 9, 2020
    Andrew-

    I'm glad you like this change. We want all Oracle Database users to be able to benefit from these capabilities.

    All licensed users of Oracle Database EE under Premier or Extended Support, Oracle Database SE2, and Oracle Database Cloud Service (all editions including the Free Tier) are now licensed to use these options. (SE, and SE1 will not include these features).

    SE2 and some of the Cloud Service tiers may require patches/updates that are being applied shortly (if they are not already in place). Customers with ULAs should consult their sales reps regarding version support.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.