O'Reilly logo

Getting Started with Oracle Event Processing 11g by Lloyd Williams, Robin J. Smith, Alexandre Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter you learned how to create different geometry types in CQL using the Spatial cartridge, such as points, rectangles, and arbitrary polygons. The geometry objects are layered on different coordinate systems. The Cartesian coordinate system and the geodetic coordinate system are supported.

Next, you learned how to use different spatial operations. These operations allow you to determine if a geometry contains, is inside, is within distance, or interacts with another geometry. Further, you can find the nearest neighbor a geometry in relation to another collection of geometries. All of these spatial operations are executed in memory during processing of CQL queries and optimized by being indexed using an R-tree data structure. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required