Databases Reference
In-Depth Information
Network Data Model Graph
Support for modeling and analyzing link-node graphs in the database useful in
transportation modeling and similar applications
Semantic Database Management
Support for W3C Resource Description Framework (RDF) semantic graphs and
Web Ontology Language (OWL)
Spatial data can be most simply defined as data that contains location information.
Spatial data support has existed in the Oracle database for decades. The Oracle Spatial
and Graph Option provides functions and procedures used to enable spatial data ap‐
plications and is only available for Oracle Enterprise Edition.
Spatial queries can combine spatial and standard relational conditions, a typical example
being “find all homes within two square miles of the intersection of Main Street and
First Avenue in which the residents' income is greater than $100,000, and show their
location.” This query might return a list of home addresses or, when used with a Geo‐
graphic Information System (GIS), plot the home locations on a map, as shown in
Figure 14-2
. Geocoding matches references such as addresses, phone numbers (includ‐
ing area codes), and postal codes (with longitude and latitude), which are then stored
in the database.
Figure 14-2. Geographic Information System display of a spatial query
