3D Data Type Support
One of the key features introduced in Oracle Spatial 11g is support for three dimensional data types. Siva Ravada, director of software development, introduced the specific elements of 3D data support, in addition to other enhancements in Oracle 11g, which is due for release sometime before the end of this calendar year.
Ravada emphasized that Oracle targeted its software development in supporting 3-dimensional data toward specific applications such as:
- GIS for city planning and property rights
- City modeling and adopting features to support CityGML guidelines
- Business Intelligence for real estate and advertising
- Virtual Reality solutions
Operations on 3D R-trees include:
- SQL operator support
- SDO_Filter, SDO_Anyinteract, SDO_Within_Distance, SDO_NN (nearest neighbor) only
- PL/SQL functions
- Validate_geometry
- Validate_layer
- SDO_Distance
- SDO_Geom.Anyinteract
- SDO_area, SDO_volume
- SDO_CS.Transform (coordinate system transformation in 3D)
- J3D_Geometry: Java Interface
- Extends the 2D JGeometry Class for 3D
A TIN is a vector-based topological data model used to represent terrain surfaces. TINs are composed of a network of irregularly spaced triangles. The 3D surface is derived from these irregularly spaced points where each point has an x, y and z value. Oracle's data type, SDO_TIN, can block the data into small pieces. Oracle doesn't worry about the number of points; it has the mechanism to aggregate the TINs. This function reads the TIN block as an SDO_Geometry and is much more efficient to store and retrieve data. Oracle 11g will not support functions to derive slope and aspect in this release.
3D coordinate system support
Oracle 11g will associate a coordinate system with 3D data. The 3D coordinate systems are all based on European Petroleum Survey Group (EPSG) specifications (codes representing geodetic parameters for datums and projections), and the following are supported:
- Vertical coordinate systems
- Geocentric: 3-D Cartesian
- Geographic-3D: 3-d ellipsoidal
- Geographic-3D: 3-d ellipsoidal
- Compound coordinate System
Spatial Web Services
Oracle identifies two approaches for structuring spatial Web services. The first model to consider when setting up a Web service is one in which "spatial" is the primary focus of the Web service. For example, a basic Web service might entail the ability to incorporate real-time information and the result may be a map or a report, such as returning driving directions between two points. The second model is one for a business service that contains a spatial component such as performing a standard business search, query or workflow. The spatial information is not the primary focus but the result may incorporate a map as a supporting element to visualize the information.
Oracle Spatial already supports the Open Geospatial Consortium's Web Map Service (WMS 1.1). Oracle 11g will support the Web Feature Service (WFS) version 1.1 and Catalog Services Web (CSW 2.0) specifications.
Oracle Spatial's WFS implementation uses SOAP/XML over HTTP, as well as the GML filter specification for feature search and Lightweight Directory Access Protocol (LDAP) for authentication. For transactional operations, the product supports the ability to retrieve a set of features while locking some, or all, features for a certain period of time. It also supports updating or deleting existing feature instances based on filter criteria.
Web Services Security
One of the more important features of Oracle is the ability to address stringent security issues and specific levels of security. Those not familiar with the levels of security will find the following explanation useful.
- Identification - Who are you?
- Authentication - How do I know it is you?
- Authorization - Are you allowed?
- Integrity - Is the data tampered?
- Confidentiality - Did anyone else read it?
- Auditing - Can you show what happened?
- Non-repudiation - Can you prove it happened?
Enhancements to Oracle Spatial's support for raster data include:
- Supports multiple NODATA values and multiple NODATA value Ranges for any GeoRaster objects and their individual bands/layers
- Supports empty raster blocks
- Union/merging of multiple GeoRaster objects or multiple layers
- Partial update/edit of raster data inside a GeoRaster object
- GeoRaster template functions to ease third-party software integration so that the developers don't need to directly deal with database binary large object (BLOB) and XML Type
- Statistical analysis functions
- Support for sub-cell and sub-pixel addressing (floating row and column numbers) in the GeoRaster cell space
- Supports irregular raster blocking
- Loading and exporting additional formats
- GeoTIFF
- JPEG 2000
- DigitalGlobe RPC text
Oracle has made several enhancements to its network data model (NMD) that some users have been awaiting. The NDM has two components: the NMD Load-on-Demand (LOD) Network Partitions that supports dynamic data sets, and the NDM LOD Analysis Engine with a Java API that supports a suite of functions including:
- Shortest path
- Nearest neighbors
- Within cost
- Reachable and reaching nodes
- Hierarchical shortest path
- User defined data
- Duration modeling
- Sub-network support using SQL-like filters to speed up network loading and analysis
- Path arithmetic support including path addition, subtraction, intersection and comparison based on connectivity
- Partial link support on paths (sub-path) and trace out
- Workspace manager support
- Routing engine improvements include:
- Driving directions in different languages
- Generation of turn-specific geometries
- Route as a set of edges
- Works with NAVTEQ and Tele Atlas data