Oracle Spatial Database
By sameert on Mar 29, 2006
I ve been using some of Oracle 10g's new Spatial features and their Java Spatial API lately. The flexibility and features it provides for GIS type applications simply rocks. For example you can create a table and have a colum that is of type SDO_GEOMETRY and store the coordiates in terms of X,Y (like longitude and latitude) or other Geometric/GML data. The API allows you to then query that Spatially indexed colum in a variety of ways. For example you can use the JDBC API to query
slect ... where sdo_filter (mycolumname ,sdo_geometry(2003,null,null,sdo_elem_info_array(1,1003,3),sdo_ordinate_array (0,0,600,800))) = 'TRUE'returns all the points as oracle.spatial.geometry.JGeometry objects that are in the MBR (mean bounding rectangle) from 0,0 to 600,800 ! With the set of coordinates in hand you can link them up and draw a route similar to what you see in Google or mapquest when you query for driving directions. Theres a bunch of other operators that allow you to insert/query a variety of geometic shapes for range and nearest neighbour information. Pretty cool !