Synonyms
Oracle locator; Oracle spatial; Oracle geographic information system; Reference system, spatial; OGC, OGC simple features; SQL/MM; ISO/IEC; Minimum bounding rectangles; Indexing, spatial; Populating, topology
Definition
A geometry in Oracle Spatial can be one of the followingFootnote 1:
Point
Linestring connecting two or more points
Polygon specified as a closed linestring and indicating an area bounded by the linestring (with zero or more holes inside the outer bounding linestring)
Multipoint collection
Multiline collection consisting of unconnected linestrings
Multipolygon collection consisting of nonoverlapping polygons, or
Heterogeneous collection consisting of a mixture of point, linestring, and/or polygon geometries
Each geometry can be specified in the context of a spatial reference system, also referred to as a coordinate system. Typical coordinate systems are local or geographic. Geographic coordinate systems are geodetic or projected. Whereas local and...
Notes
- 1.
Additional types to model geometric shapes in three‐dimensional space are being added in subsequent releases of Oracle. This entry focuses only on two‐dimensional geometries.
- 2.
Open GIS Consortium, OpenGIS Simple Features Specification for SQL Revision 1.1, http://www.opengis.org/docs/99-049.pdf, May 5, 1999.
- 3.
Structured Query Language (Multimedia)
- 4.
International Organization for Standardization/International Electrotechnical Commission.
Recommended Reading
Kothuri, R., Ravada, S.: Efficient processing of large spatial queries. In: Proceedings of the Symposium of Spatial and Temporal Databases, Redondo Beach, CA, 12–15 July 2001
Kothuri, R., Godfrind, A., Beinat, E: Pro Oracle Spatial. Apress, Berkeley, CA (2004)
Kothuri, R., Ravada, S., Sharma, J., Banerjee, J.: Indexing medium dimensionality data in Oracle. In: Proceedings of the ACM SIGMOD International Conference on Management of Data. Philadelphia, PA, 1–3 June 1999
Beckmann, N., Kriegel, H., Schneider, R., Seeger, B.: The R* tree: An Efficient and Robust Access method for points and rectangles. In: Proceedings of the ACM SIGMOD International Conference on Management of Data. Atlantic City, NY 23–25 May, 1990
Samet H.: The Design and Analysis of Spatial Data Structures. Addison-Wesley, Reading (1989)
Brinkoff, T., Kreigel, H.-P., Schneider, R., Seegar, B.: Multi-step processing of spatial joins. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Minneapolis, MN, 24–27 May 1994
An, N., Kothuri, R., Ravada, S.: Improving performance with bulk inserts in Oracle R-trees. In: Proceedings of the International Conference on Very Large Data Bases (VLDB), Berlin, Germany, 9–12 Sept 2003
Oracle. (2006) 10g Release 2 Spatial User's Guide and Reference. http://www.oracle.com/products/spatial. Accesed 2006
White, D.A., Jain, R.: Similary Indexing Algorithms and Performance. In: Proc. SPIE. 2670, pp. 62–73 (1996)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag
About this entry
Cite this entry
Kothuri, R., Ravada, S. (2008). Oracle Spatial, Geometries. In: Shekhar, S., Xiong, H. (eds) Encyclopedia of GIS. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35973-1_936
Download citation
DOI: https://doi.org/10.1007/978-0-387-35973-1_936
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-30858-6
Online ISBN: 978-0-387-35973-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering