Autonomous Database – Now with Spatial Intelligence

We are pleased to announce that Oracle Autonomous Database now comes with spatial intelligence! If you are completely new to Oracle Autonomous Database then firstly: where have you been for the last 18 months?, secondly: here is a quick recap of the key features:

What is Oracle Autonomous Database

Oracle Autonomous Database provides a self-driving, self-securing, self-repairing cloud service that eliminate the overhead and human errors associated with traditional database administration. Oracle Autonomous Database takes care of configuration, tuning, backup, patching, encryption, scaling, and more. Additional information can be found at https://www.oracle.com/database/autonomous-database.html.

Special Thanks…

This post has been prepared by David Lapp who is part of the Oracle Spatial and Graph product management team.He is extremely well known within our spatial and graph community. If you want to follow David’s posts on the Spatial and Graph blog then use this link and the spatial and graph blog is here.

Spatial Features

The core set of Spatial features have been enabled on Oracle Autonomous Database. Highlights of the enabled features are; native storage and indexing of point/line/polygon geometries, spatial analysis and processing, such as proximity, containment, combining geometries, distance/area calculations, geofencing to monitor objects entering and exiting areas of interest, and linear referencing to analyze events and activities located along linear networks such as roads and utilities. For details on enabled Spatial features, please see the Oracle Autonomous Database. documentation.

Loading Your Spatial Data into Autonomous Database

In Oracle Autonomous Database, data loading is typically performed using either Oracle Data Pump or Oracle/3rd party data integration tools. There are a few different ways to load and configure your spatial data sets:

  • Load existing spatial data
  • Load GeoJSON, WKT, or WKB and convert to Spatial using SQL.
  • Load coordinates and convert to Spatial using SQL.

Obviously the files containing your spatial data sets can be located in your on-premise data center or maybe your desktop computer, but for the fastest data loading performance Oracle Autonomous Database also supports loading from files stored in Oracle Cloud Infrastructure Object Storage and other cloud file stores. Details can be found here for ATP: https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/load-data.html and here if you are using ADW: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html.

Configuring Your Spatial Data

Routine Spatial data configuration is performed using Oracle SQL Developer GUIs or SQL commands for:

  • Insertion of Spatial metadata
  • Creation of Spatial index
  • Validation of Spatial data

Example Use Case for ATP

For the purposes of this post lets focus on an ATP-style use case. OLTP applications commonly require calculations that are invoked upon changes to data to support business functions and enforce business rules. For example:

  • Permitting system transactions require validation that the activity complies with regulations
  • Financial transactions require checks against known pattern of fraud
  • Service transactions require determination of optimal resources

In these and many other transaction processing scenarios, location plays an important role and are supported by the Spatial features of Oracle Autonomous Transaction Processing. Using the permitting scenario as an example, the major steps for location-based transaction validations are:

  • Load geospatial reference data for regulation enforcement such as environmentally sensitive areas, school zones, redevelopment zones.
  • In the permit transaction process, capture the proposed activity locations
  • Use Spatial to perform location-based validations of proposed activities, for example the proximity of an activity involving hazardous materials to environmentally sensitive areas:

— Proximity for validation



— Use a SQL statement with SDO_WITHIN_DISTANCE

— and geometry constructor to validate the proximity rule



SELECT DECODE(count(*), 0, ‘PASSED’, FAILED’) as location_validation

FROM environmental_sensitive_areas

WHERE SDO_WITHIN_DISTANCE(

geometry,

sdo_geometry(2001,4326,sdo_point_type(permit_longitude,permit_latitude,null),null,null),

‘distance=5 unit=MILE’) = ‘TRUE’;

  • Use Spatial to determine notification requirements for a permitted activity. For example, notify public safety jurisdictions within the proximity of proposed hazardous materials transport routes:


— Proximity for notification



— Use a SQL statement with SDO_WITHIN_DISTANCE

— and route geometries to determine notifications



SELECT hazmat_route, jurisdiction

FROM jurisdictions, hazmat_routes

WHERE SDO_WITHIN_DISTANCE(

jurisdictions.geometry,

hazmat_routes.geometry,

‘distance=5 unit=MILE’) = ‘TRUE’;

ROUTE JURISDICTION

2017-03-A AL_REGION_7

2017-03-A AL_REGION_9

2017-03-B AL_REGION_9

2017-04-A AL_REGION_2

2017-04-B AL_REGION_3

2017-04-B AL_REGION_9

These and any other location-based transactions may be operationalized as triggers and procedures invoking more involved business logic. As a fully integrated feature of Oracle Autonomous Transaction Processing, location-based operations can be seamlessly blended with the mainstream aspects of transaction processing logic.

What about data warehouse use cases?

If you are interested in spatial use cases relating to data warehousing projects then click over to this blog post on the Data Warehouse Insider blog: Autonomous Data Warehouse – Now With Spatial Intelligence

Summary

For important best practices and further details on the use of these and many other Spatial operations, please refer to Oracle Autonomous Transaction Processing documentation and the Autonomous Data Warehousing documentation.

Related:

Analyze crime data with Apache Spark and Hive ETL, Part 2: Explore the analyses

In this second part of the “Analyze crime data with Apache Spark and
Hive ETL” tutorial series, you will learn how to integrate data from different
sources. You will also see the computation of normalized statistics for crime
rates enabling easy comparison of crime rates across different geographic
areas.

Related:

CALL FOR SPEAKERS is Now Open for Oracle BIWA Summit’18 User Community Meeting in March, 2018

BIWA Summit 2018

The Big Data + Cloud + Machine Learning + Spatial + Graph + Analytics + IoT

Oracle User Conference

featuring Oracle Spatial and Graph Summit

March 20 – 22, 2018

Oracle Conference Center at Oracle Headquarters Campus, Redwood Shores, CA

Share your successes…

We want to hear your story. Submit your proposal today for OracleBIWA Summit 2018, featuring Oracle Spatial and Graph Summit, March 20 – 22, 2018 and share your successes with Oracle technology. The call for speakers is now open through December 3, 2017. Submit now for possible early acceptance and publication in OracleBIWA Summit 2018 promotion materials.

Click HERE to submit your abstract(s) for OracleBIWA Summit 2018.

Oracle Spatial and Graph Summit will be held in partnership with BIWA Summit. BIWA Summits are organized and managed by the Oracle Business Intelligence, Data Warehousing and Analytics (BIWA) User Community and the Oracle Spatial and Graph SIG – a Special Interest Group in the Independent Oracle User Group (IOUG).

BIWA Summits attract presentations and talks from the top Business Intelligence, Data Warehousing, Advanced Analytics, Spatial and Graph, and Big Data experts. The 3-day BIWA Summit 2017 event involved Keynotes by Industry experts, Educational sessions, Hands-on Labs and networking events. Click HERE to see presentations and content from BIWA Summit 2017.

Call for Speaker DEADLINE is December 3, 2017 at midnight Pacific Time.

Presentations and Hands-on Labs must be non-commercial. Sales promotions for products or services disguised as proposals will be eliminated. Speakers whose abstracts are accepted will be expected to submit their presentation as PDF slide deck for posting on the BIWA Summit conference website. Accompanying technical and use case papers are encouraged, but not required.

Complimentary registration to OracleBIWA Summit 2018 is provided to the primary speaker of each accepted presentation. Note: Any additional co-presenters need to register for the event separately and provide appropriate registration fees.

Please submit session proposals in one of the following areas:

  • Machine Learning
  • Analytics
  • Big Data
  • Data Warehousing and ETL
  • Cloud
  • Internet of Things
  • Spatial and Graph (Oracle Spatial and Graph Summit)
  • …Anything else “Cool” using Oracle technologies in “novel and interesting” ways

Proposals that cover multiple areas are acceptable and highly encouraged. On your submission, please indicate a primary track and any secondary tracks for consideration. The content committee strongly encourages technical/how to sessions, strategic guidance sessions, and real world customer end user case studies, all using Oracle technologies.

If you submitted a session last year, your login should carry over for 2018. We will be accepting abstracts on a rolling basis, so please submit your abstracts as soon as possible.

Learn from Industry Experts from Oracle, Partners, and Customers

Come join hundreds of professionals with shared interests in the successful deployment

of Oracle technology on premises, on Cloud, hybrid Cloud, and infrastructure:

Cloud &

Infrastructure

Spatial & Graph

Analytics

Big Data & Machine Learning

Internet of Things

  • Database Cloud Service
  • Big Data Cloud Service
  • Data Visualization Cloud Service
  • Hadoop
  • Spark
  • Big Data Connectors

    (Hadoop & R)
  • IaaS, PaaS, SaaS
  • Spatial and Graph for Big Data and Database
  • GIS and smart cities features
  • Location intelligence
  • Geocoding & routing
  • Property graph DB
  • Social network, fraud detection, deep learning graph analytics
  • RDF graph
  • Oracle Data Visualization
  • Big Data Discovery
  • OBIEE
  • OBIA Applications
  • Exalytics
  • Real-Time Decisions
  • Machine Learning

  • Advanced Analytics

  • Data Mining

  • R Enterprise

  • Fraud detection

  • Text Mining

  • SQL Patterns

  • Clustering

  • Market Basket Analysis

  • Big Data Preparation

  • Big Data from sensors
  • Edge Analytics
  • Industrial Internet
  • IoT Cloud
  • Monetizing IoT
  • Security
  • Standards

What To Expect

400+ Attendees | 90+ Speakers | Hands on Labs | Technical Content| Networking

New at this year’s BIWA Summit:

  • Strategy track – targeted at the C-level audience, how to assess and plan for new Oracle Technology in meeting enterprise objectives
  • Oracle Global Leaders track – sessions by Oracle’s Global Leader customers on their use of Oracle Technology, and targeted product managers on latest Oracle products and features
  • Grad-student track – sessions on cutting edge university work using Oracle Technology, continuing Oracle Academy’s sponsorship of graduate student participation

Exciting Topics Include:

  • Database, Data Warehouse, and Cloud, Big Data Architecture
  • Deep Dives on existing Oracle BI, DW and Analytics products and Hands on Labs
  • Updates on the latest Oracle products and technologies e.g. Oracle Big Data Discovery, Oracle Visual Analyzer, Oracle Big Data SQL
  • Novel and Interesting Use Cases of Spatial and Graph, Text, Data Mining, ETL, Security, Cloud
  • Working with Big Data: Hadoop, “Internet of Things”, SQL, R, Sentiment Analysis
  • Oracle Business Intelligence (OBIEE), Oracle Spatial and Graph, Oracle Advanced Analytics

    AllBetter Together

Example Talks from BIWA Summit 2017:

[Visit www.biwasummit.org to see the Full Agenda from BIWA’17 and to download copies of BIWA’17 presentations and HOLs.]

Machine Learning

  • Taking R to new heights for scalability and performance
  • Introducing Oracle Machine Learning Zeppelin Notebooks
  • Oracle’s Advanced Analytics 12.2c New Features & Road Map: Bigger, Better, Faster, More!
  • An Post — Big Data Analytics platform and use of Oracle Advanced Analytics
  • Customer Analytics POC for a global retailer, using Oracle Advanced Analytics
  • Oracle Marketing Advanced Analytics Use of OAA in Propensity to Buy Models
  • Clustering Data with Oracle Data Mining and Oracle Business Intelligence
  • How Option Traders leverage Oracle R Enterprise to maximize trading strategies
  • From Beginning to End – Oracle’s Cloud Services and New Customer Acquisition Marketing
  • K12 Student Early Warning System
  • Business Process Optimization Using Reinforcement Learning
  • Advanced Analytics & Graph: Transparently taking advantage of HW innovations in the Cloud
  • Dynamic Traffic Prediction in Road Networks
  • Context Aware GeoSocial Graph Mining

Analytics

  • Uncovering Complex Spatial and Graph Relationships: On Database, Big Data, and Cloud
  • Make the most of Oracle DV (DVD / DVCS / BICS)
  • Data Visualization at SoundExchange – A Case Study
  • Custom Maps in Oracle Big Data Discovery with Oracle Spatial and Graph 12c
  • Does Your Data Have a Story? Find out with Oracle Data Visualization Desktop
  • Social Services Reporting, Visualization, and Analytics Using OBIEE
  • Leadership Essentials in Successful Business Intelligence (BI) Programs

Big Data

  • Uncovering Complex Spatial and Graph Relationships: On Database, Big Data, and Cloud
  • Why Apache Spark has become the darling in Big Data space?
  • Custom Maps in Oracle Big Data Discovery with Oracle Spatial and Graph 12c
  • A Shortest Path to Using Graph Technologies– Best Practices in Graph Construction, Indexing, Analytics and Visualization

Cloud Computing

  • Oracle Big Data Management in the Cloud
  • Oracle Cloud Cookbook for Professionals
  • Uncovering Complex Spatial and Graph Relationships: On Database, Big Data, and Cloud
  • Deploying Oracle Database in the Cloud with Exadata: Technical Deep Dive
  • Employee Onboarding: Onboard – Faster, Smarter & Greener
  • Deploying Spatial Applications in Oracle Public Cloud
  • Analytics in the Oracle Cloud: A Case Study Deploying SAS Retail Analytics in the Oracle Cloud
  • BICS – For Departmental Data Mart or Enterprise Data Warehouse?
  • Cloud Transition and Lift and Shift of Oracle BI Applications

Data Warehousing and ETL

  • Business Analytics in the Oracle 12.2 Database: Analytic Views
  • Maximizing Join and Sort Performance in Oracle Data Warehouses
  • Turbocharging Data Visualization and Analyses with Oracle In-Memory 12.2
  • Oracle Data Integrator 12c: Getting Started
  • Analytic Functions in SQL
  • My Favorite Scripts 2017

Internet of Things

  • Introduction to IoT and IoT Platforms
  • The State of Industrial IoT
  • Complex Data Mashups: an Example Use Case from the Transportation Industry
  • Monetizable Value Creation from Industrial-IoT Analytics

Spatial and Graph Summit

  • Uncovering Complex Spatial and Graph Relationships: On Database, Big Data, and Cloud
  • A Shortest Path to Using Graph Technologies– Best Practices in Graph Construction, Indexing, Analytics and Visualization
  • Build Recommender Systems, Detect Fraud, and Integrate Deep Learning with Graph Technologies
  • Building a Tax Fraud Detection Platform with Big Data Spatial and Graph technologies
  • Maps, 3-D, Tracking, JSON, and Location Analysis: What’s New with Oracle’s Spatial Technologies
  • Deploying Spatial Applications in Oracle Public Cloud
  • RESTful Spatial services with Oracle Database as a Service and ORDS
  • Custom Maps in Oracle Big Data Discovery with Oracle Spatial and Graph 12c
  • Smart Parking for a Smart City
  • Using Oracle Spatial and Graph at Los Angeles and Munich Airports
  • Analysing the Panama Papers with Oracle Big Data Spatial and Graph
  • Apply Location Intelligence and Spatial Analysis to Big Data with Java

Example Hands-on Labs from BIWA Summit 2017:

  • Using R for Big Data Advanced Analytics and Machine Learning
  • Learn Predictive Analytics in 2 hours! Oracle Data Miner Hands on Lab
  • Deploy Custom Maps in OBIEE for Free
  • Apply Location Intelligence and Spatial Analysis to Big Data with Java
  • Use Oracle Big Data SQL to Analyze Data Across Oracle Database, Hadoop, and NoSQL
  • Make the most of Oracle DV (DVD / DVCS / BICS)
  • Analyzing a social network using Big Data Spatial and Graph Property Graph

Submit your abstract(s) today, good luck and hope to see you there!

See last year’s Full Agenda from BIWA’17.

Related: