Presentation Title: Ranges, Ranges Everywhere!
Speaker: Mr Stew Ashton UKOUG Speaker Award Winner
Company: Independent
Presentation abstract: The current data explosion requires querying, summarising and managing more and more data related to time periods or other ranges. Range-based data present specific problems of coherence, query performance and scalability. This session will present typical problems and new, highly efficient SQL solutions - many using Row Pattern Matching, a feature of Oracle Database 12c.

Issues addressed include: analysis of gaps and overlaps; merging of contiguous ranges; joining range-based tables such as temporal tables; and temporal DML. Techniques will be presented to greatly reduce CPU consumption by range-based queries.

This session is geared primarily to SQL practitioners who are willing to unleash the full power of SQL in the Oracle database. They will learn how to identify specific requirements and pitfalls of range-based data, and how to apply new techniques for decreasing CPU usage and improving performance by orders of magnitude.

Presentation begins: 05/12/2016 14:10
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Product User
Speaker biography:  Stew is one of the top SQL developers in the Oracle community, to which he has contributed for a decade through the AskTom site, the OTN forum dedicated to SQL and PL/SQL, and his blog. He was “Best New Overseas Speaker” at Tech 14 and OTN “Devvy Award” finalist in 2015. Stew has been a developer and application architect for 35 years, working in mainframe, client-server and web architectures. For the last ten years at BNP Paribas, he has focused on proper use of the Oracle database in OLTP applications and batch processing,improving application performance up to 300-fold. His blog features in-depth series on such topics as comparing and synchronizing tables, handling date ranges and the MATCH_RECOGNIZE clause.
Related topics: Database: 12c New Features, Database: Performance & Internals, Database: SQL & PL/SQL
Hall: Hall 11A

Ranges,_Ranges_Everywhere.pptx1.9 MB10/12/2016 23:12:30