Dubai, Sun. 27/03/05 Dubai GIS Center staff attended a training course in “Oracle9i Database: Spatial”
Dubai, Sun. 27/03/05
Dubai GIS Center organized a training course in “Oracle9i Database: Spatial”, from 6 - 9th of March at DM Club from 9am to 2:30pm.
The purpose of this course was to teach employees how to model and create tables with spatial data index spatial data, and discuss how to spatially enable applications. This course was taught on Oracle10g.
The employees learned about Oracle's native data type for spatial data (SDO_GEOMETRY) and the geometric primitives it supports. Additionally, they learned:
How to load spatial data into Oracle with various Oracle utilities.
How to appropriately create spatial indexes for optimal performance.
How to query spatial data and perform spatial analysis with spatial operators, functions and procedures.
The training included additional topics like: Oracle Spatial's Linear Referencing System (LRS), coordinate systems support in Oracle Spatial, function-based and partitioned indexes with Oracle Spatial, publishing maps to the web with AS MapViewer, Network Modeling, Geocoding, Georaster and Topology.
