Ranges, Ranges Everywhere!

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.

The session will start by an analysis of ranges, which will focus on the fundamental difference between data that allows overlapping ranges and data that does not.
It will continue with queries and DML on one table: analysis of gaps and overlaps, and “packing” of data with contiguous ranges.
Finally, problems with multiple tables will be addressed: joining range-based tables such as temporal tables and range-based DML.
Techniques will be presented to greatly reduce CPU consumption by range-based queries, in particular by avoiding JOINs with inequality conditions.

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.

Wednesday, 2016-11-16
09:00 am - 09:45 am
Stew Ashton is one of the top SQL developers in the Oracle community, to which he has contributed for over a decade through the AskTom site, the OTN forum dedicated to SQL and PL/SQL, and his blog. He is also an award-winning conference speaker and an Oracle Ace. Stew has been a developer and application architect for 35 years, working in mainframe, client-server and web architectures. Since 2005 he has focused on proper use of the Oracle database in OLTP applications and batch processing, improving performance up to 300-fold.

Further lectures of Stew Ashton

Meet your Match: Advanced Row Pattern Matching
Tuesday , 15.11.2016
08:30 am - 09:15 am

These lectures could also interest you