Skip to main content

Oracle Spatial, Geometries

  • Reference work entry
Encyclopedia of GIS

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...

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Notes

  1. 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. 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. 3.

    Structured Query Language (Multimedia)

  4. 4.

    International Organization for Standardization/International Electrotechnical Commission.

Recommended Reading

  1. 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

    Google Scholar 

  2. Kothuri, R., Godfrind, A., Beinat, E: Pro Oracle Spatial. Apress, Berkeley, CA (2004)

    Google Scholar 

  3. 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

    Google Scholar 

  4. 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

    Google Scholar 

  5. Samet H.: The Design and Analysis of Spatial Data Structures. Addison-Wesley, Reading (1989)

    Google Scholar 

  6. 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

    Google Scholar 

  7. 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

    Google Scholar 

  8. Oracle. (2006) 10g Release 2 Spatial User's Guide and Reference. http://www.oracle.com/products/spatial. Accesed 2006

  9. White, D.A., Jain, R.: Similary Indexing Algorithms and Performance. In: Proc. SPIE. 2670, pp. 62–73 (1996)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics