Thanks for a great Analytics and Data Summit 2019 event. We hope to see you next year Feb 25-27, 2020!
To download the presentations you must first sign up with Sched for free (easy and fast!)
  • Sessions appear in the color of their primary track and can be filtered using Products on the right
  • Use the Search bar for more flexibility
See this link for hints on how to search the schedule

Wednesday, March 13 • 11:10am - 11:35am
Optimizing Parallel Spatial Data Processing of High Volume Agricultural Data

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Agrarmarkt Austria is the federal agency responsible for agriculture. A major task is calculating agricultural subsidies as part of the Common Agricultural Policy of the European Union. This challenging task involves high volume geospatial data processing and data validation annually, in a time window of only three days. In this session we will show how Oracle Database spatial partitioning and parallelism were used to process hundreds of millions of land parcels and other geometries in order to calculate agricultural subsidies. With 15 geodetic layers of land cover data containing up to 200M geometries each, and 5 billion operations in the given timeframe, Oracle Spatial and Graph features were critical. The focus of the project was to reach maximum throughput for geodetic operations in SQL and PL/SQL by optimizing read/write operations with spatial indexes while at the same time minimizing storage by means of logical compression.

avatar for Markus Flatscher

Markus Flatscher

Lead DevOps, AMA
Current: Lead of DevOps at AMA(Oracle)Lead DBDev (Oracle/Sqlserver) at bwinLead Development (Sqlserver) at Wiener ZeitungDeveloper/DBA/Teamlead (Oracle) at AMAFree Consultant (Oracle)

Wednesday March 13, 2019 11:10am - 11:35am
2-Rm 103