Wednesday, September 25, 2013

Open World 2013 - Monday: Focus on Spatial

Oracle's Theme of the Day is: there be a lot of data out there.  Larry's keynote yesterday was about the hardware and hardware-consuming products that support chewing through huge amounts of data - from the Sparc M6 through the In-Memory Database.   Monday was about big data, scalable solutions with a lot of emphasis on crunching and analytics.

My Theme of the Day is Oracle Spatial and Graph.  Many of you know that Spatial is one of my major interests.

For me, the exciting new information is two-fold:

Nearly all of SDO_GEOMETRY-related functionality (except for LRS) previously available in 11gR2 and below is added to the free Locator stack.  The full description for Locator 12c is in the documentation at http://docs.oracle.com/cd/E16655_01/appdev.121/e17896/sdo_locator.htm#i632018

Related to that is that the existing functionality has been supplemented with a complete rewrite, from ground up, of nearly everything in SDO_GEOMETRY with a focus on performance.  Discussed benchmarks indicate performance improvements can range from 5x to 100x in all areas from indexing through analysis using any of the rewritten functions. 

A number of these performance improvements are available simply by upgrading.

However, some of these performance improvements are available only in Enterprise Edition, with the Spatial Option, by setting the 'Go Fast' parameter to 'True'

ALTER SYSTEM SET SPATIAL_VECTOR_ACCELERATION = TRUE;
 
as described at http://docs.oracle.com/cd/E16655_01/appdev.121/e17896/sdo_intro.htm#sthref136
 
 
It definitely is time for me to get back to Spatial, and get more involved in the IOUG Spatial SIG.


No comments: