For organizations
wanting to deploy content search without those skills, Oracle offers
Secure Enterprise Search (SES) with plug-ins for a wide variety of data
sources and commonly deployed Internet directories.
Oracle Spatial Option
Spatial data is data that contains location information. The Oracle Spatial Option
provides the functions and procedures that allow spatial data to be stored in an Oracle
database and then accessed and analyzed according to location comparisons.
328 | Chapter 14: Oracle Extended Datatypes
An example of using spatial query functions to combine spatial and standard
relational conditions would be to ???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 Geographic Information System (GIS), plot the home
locations on a map, as shown in Figure 14-2. Geocoding matches references such as
addresses, phone numbers (including area codes), and postal codes (with longitude
and latitude), which are then stored in the database.
Pages:
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713