|5th July 2016||Birmingham, UK: I’ll be doing an evening event with Oracle Midlands – it’s an all-evening event about indexing, nominally in two separate sessions: “Indexing” and “Indexing and the Impact of New Technologies”.|
|18th – 22nd Sept 2016||San Franciso, USA: . I’ve submitted an abstract for OpenWorld 2016 – and I’ll probably be attending even if it’s not accepted. The abstract title is: “Indexing and the Impact of New Technologies”, the abstract is as follows:
Over the last 8 years there have been many dramatic changes to the technology underpinning the Oracle RDBMS. We have Exadata systems, in-memory columnar storage, container databases, and the move to Cloud computing.
Despite these advances we still aim to make the most cost-effective use of the technologies we’ve chosen, and for critical systems that still means selecting the best indexing strategies – even if, in some cases, the best indexing strategy turns out to be “don’t bother”.
In this session we examine how different technologies affect how we index to minimise the workload and maximise the benefit of the technology. The fundamental questions hardly change but an examination of the unique selling points of each feature shows us variations in the cost/benefit analysis that can make a big difference to our choices.
The session will start with a 15 minute introduction to the topic, followed by 30 minutes of Q&A
|28th – 29th Sept 2016||Zurich, Switzerland: . I will be speaking at Trivadis’ annual event, this year called “Database Development and Performance Days” and consisting of two streams. My topics will be: “Just Don’t Do It” – examples of optimising your code by avoiding the work you didn’t need to do, and “Indexing” – a discussion of the benefits we hope to get from indexes (B-tree and Bitmap), why we don’t always get then, and what it costs to try.|
|17th – 21st Oct 2016||Slovenia and Croatia: . I’ve been asked to speak at the Slovenian and Croatian user group events which occur back to back over the week of 17th October. I’ve offered “Just Don’t Do It” and a short version of “Interpreting Parallel Execution Plans” for both events.|
|5th – 7th Dec 2016||Birmingham, UK: I’ve submitted four proposals for UKOUG Tech 16.
I’ll also be around for “Super Sunday” on 4th Dec – but I haven’t submitted a specific abstract for that, though I might end up doing the “Indexes and New Technology” presentation.
If the panel session is selected you’ll be able to email me questions in advance at Tech16@jlcomp.demon.co.uk