Recent Posts by James Steiner

With all the information that resides in our databases and operational systems, you would think that it would be easy to answer questions about who our most important customers and suppliers are, where are the critical points in a supply chain, which business or financial transactions may be suspicious, and what patterns are visible in sales data.  But these kinds of questions, and others like them that are based on how data elements are connected to others, can be difficult...

In keeping with the Oracle mission to help people see data in new ways, discover insights, unlock endless possibilities, customers wishing to use the Machine Learning, Spatial, and Graph features of Oracle Database are no longer required to purchase additional licenses. Oracle wants every developer, every data scientist and anyone who uses Oracle Database to be able to use graph analytics, graph models, and graph querying of their data.  For decades, Oracle Database has...

In keeping with the Oracle mission to help people see data in new ways, discover insights, unlock endless possibilities, customers wishing to use the Machine Learning, Spatial and Graph features of Oracle Database are no longer required to purchase additional licenses.  For decades, Oracle Database has included industry-leading multi-model and analytic capabilities.  Oracle’s converged database architecture supports multiple data types and data models (e.g. spatial,...

Oracle Spatial Summit 2015 Moving to California as part of the Oracle BIWA Summit 2015 Save the dates! Jan 27-29, 2015 Oracle Conference Center at Oracle HQ Campus, Redwood Shores, CA Learn directly from the senior management and developers of Oracle’s industry-leading spatial technologies -- Dan Geringer, Siva Ravada, Xavier Lopez, Jayant Sharma and Jim Steiner. Participate in Hands-On-Labs for Oracle Spatial and MapViewer. Hear from leading practitioners and customers about...

 By Karin Patenge, Principal Sales Consultant, Oracle Germany I would like to briefly offer a simple function to calculate the memory allocated for SDO_GEOMETRY tables. This takes into account only tables, LOB and index segments (this is not applicable for partitioned tables). create or replace function alloc_space_in_mbytes (tablename in varchar2) return number  is table size number; begin   select      sum (bytes) into table size   from (     select        segment_name,        bytes    ...