Maps in apps - database-driven development with Oracle Spatial in Autonomous Database
In this Autonomous Database Learning Lounge session, Oracle Spatial and Autonomous Database Product Management how to do database-driven development with geospatial capabilities in Autonomous Database.
Register for our bi-weekly sessions at https://bit.ly/adb-learning-lounge
Slides for this session at:: https://bit.ly/adbll-slides-maps
Outline
Autonomous Database Learning Lounge series presents “Maps in apps - database-driven development with Oracle Spatial”
David Lapp, Senior Principal Product Manager will explain how location is an essential component of modern business applications in both operational and analytics scenarios, and how location is a key to understanding the relationships between business entities such as trade areas, demographics, and traffic patterns. Whether represented as maps, reports, or notifications, the results of location-based analysis, such as "which properties are within a flood hazard zone", are often the only means of relating diverse sources of data.
The Spatial features of Oracle Autonomous Database provide robust geospatial data management and analysis. These features are accessed programmatically with SQL, or using the no-code Oracle Spatial Studio web tool. As a feature of Oracle's converged database, these geospatial capabilities co-exist with a wide range of features supporting database-driven application development.
This session explains how to include maps and location-based analysis in your applications with Oracle Spatial in combination combined with Oracle Application Express (APEX) for low-code application development and Oracle REST Data Services (ORDS) for creating spatial services.minutes.
Open Q&A
Autonomous Database product managers answered technical questions about the Autonomous Database service, its features, integration capabilities and use cases.
Video highlights:
00:45 Agenda
02:08 Important links on Autonomous Database
02:32 Maps in Apps
03:21 Introduction to Oracle Spatial capabilities
07:00 Oracle Spatial in the practical sense
09:21 Native spatial data types and operations
13:26 Oracle Spatial's 100s of spatial SQL operations
16:11 Geocoding SQL API for Autonomous Database
22:33 Leverage in-database JSON features
27:28 Integration with other Apps, Tools and third party Data Providers
32:20 Oracle Spatial Studio
35:24 Live Demo of Oracle Spatial Studio
41:05 Spatial and Oracle REST Data Services (ORDS)
43:35 Spatial and ORDS example
46:07 Spatial and Oracle Application Express (APEX)
48:29 Spatial and APEX example
51:43 Spatial and Python
53:49 Spatial Resources
54:49 Q&A
58:50 Important links on Autonomous Database
59:09 Final thoughts