Spatial Solutions Architect and Database Expert
Introduction A lot has been written, positive and negative, about the speed of Oracle Spatial over the years, a lot of ill informed (I mean if you don’t use it, how can you criticize it?). But since Oracle Database 12c (12.1) there is no longer any doubt as to the speed of the product. Why?Read More
I gave a presentation on analyzing Oracle Spatial and Graph 12c’s performance by comparing it with two other spatial types known for their performance or quality. The slides from this presentation are available on this website
I have written an analysis of Oracle 12c’s new spatial performance improvements. The analysis was conducted by comparing what Oracle is offering in Oracle Spatial 12c against two other database types that have a reputation for performance and functionality. The report is available at the following link Accessing the Improvements These spatial performance improvements areRead More
In a previous article I showed how too many digits of precision for the ordinates of an sdo_geometry object – stored in its sdo_ordinate_array – has an effect on storage volume. In this article I will revisit the question of storage size while examining the effect that storage size has on performance (search and retrieval).Read More
In this article I am going look at the effect ordinate precision has on the storage space occupied by tables containing sdo_geometry data. In a related article I will also look at the effect storage precision may have on performance (ie searching and returning data in SQL). Sdo_Geometry Coordinate Precision There is a little knownRead More