When Where Is What Matters： New Spatial Features in Oracle Database 23ai [LRN3341].pdf

1、When Where Is What Matters New Spatial Features in Oracle Database 23aiLRN3341Siva Ravada,Vice President,Software DevelopmentDavid Lapp,Product ManagerSept 11,2024Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates1Oracle SpatialEverything happens somewhereData type in converged Oracle Dat

2、abaseRelate and analyze data by location In the context of business workflowsOracle CloudWorld Copyright 2024,Oracle and/or its affiliates2Spatial data and queriesOracle CloudWorld Copyright 2024,Oracle and/or its affiliates3PointsLinesPolygonsAddress locationsGPS locationsEarthquake locationsRoadsU

3、tility linesStorm pathCountiesFlood zoneSales regionsWhich address locations are within a flood zone?Which utility lines are within a mile of an earthquake location?How far from storm damage is the nearest emergency response center?Oracle SpatialSpatial data and queriesOracle CloudWorld Copyright 20

4、24,Oracle and/or its affiliates43DRasterNetworksPoint cloudsLiDARSurfaces,solidsSatellite imageryDrone imageryGridded dataRoadsRailUtilityHow close is the tree canopy to our utility lines?Which areas of farmland have been inundated by flooding?Which locations can be reached within 10 min drive time?

5、Oracle SpatialSpatial data and queriesOracle CloudWorld Copyright 2024,Oracle and/or its affiliates5Linear ReferencingSecurityLogisticsMobile marketingRoadsRailUtilitiesDuration of proximityPeople“Things”When did a vehicle enter a secure area?Where is the section of roadway with planned maintenance?

6、Were two people located within 20 ft of each other for over 5 min?GeofencingSpatiotemporalOracle Spatial.and moreSpatial type and SQL APIs Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates6Native spatial data typeNative spatial operations100s of spatial SQL operationsSearch:which are nea