Presentation Title: Approximate Query Processing
Speaker: Mr Christian Antognini OakTable Member UKOUG Speaker Award Winner 2015 & 2016 ACE Director
Company: Trivadis
Presentation abstract: There are situations where approximate results are superior to exact results. It’s for example the case with exploratory queries or when results are displayed in a visual manner that don’t convey small differences. Oracle Database 12.2 introduces a number of functions as well as a query transformation that allows an application to take advantage of the new features without requiring code changes. The aim of this presentation is to describe how the approximate query processing capabilities works.
Presentation begins: 04/12/2017 16:55
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert
Speaker biography: Since 1995, Christian Antognini has focused on understanding how the Oracle Database engine works. His main interests include logical and physical database design, the query optimizer and basically everything else related to application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland. He is a proud member of the OakTable Network and an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011/2016).
Related topics: Database: 12c Database
Hall: Hall 9

ApproximateQueryProcessing_UKOUG_2017.pdf960 KB07/12/2017 19:11:15