In the last 14 months I delivered a dozen of presentations covering the In-Memory Column Store. During many of them, I spent most of the time showing the audience several demos. The aim of this post is to share with you the scripts and a recording (MP4) of those demos.
Warning about Demos
The recordings show the results of running the scripts on an Exadata system. The performance figures are intended only to explain and compare different kinds of processing and to give you a feel for their impact. Since every system and every application has its own characteristics, the relevance of using each technique might be very different, depending on where it’s applied. Simply put, the scripts were engineered to clearly show specific behaviors.
In case you want to run the scripts, to setup the environment run imcs_prepare_schema.sql.
On 10 December 2015 I’ll give an online training entitled Oracle Database 12c – New Performance Features. This short post provides key information about it.
With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12.1 is no exception to the rule. Notably, it introduces key improvements in three areas.
I’m glad to be home after a couple weeks in Europe, speaking at both the Harmony 15 conference in beautiful Tallinn, Estonia and then as a keynote speaker at AOUG in lovely Vienna, Austria the week after. I get to pretty much stay close to home for the next two months, traveling only a bit, but I want to go over the upcoming conferences that I’ll be speaking at the next couple months.
Trivadis, the company I work for, just opened a new branch in Denmark (the press release, in German, is available here). On the 14th of April (09:00-15:00) takes place, in the Oracle’s office in Ballerup, the opening event. Two colleagues of mine and I will be there to deliver the following presentations:
Big Data versus Conventional Techniques – Decision Criteria (Peter Welker, Senior Principal Consultant)
Just a quick note that I posted slides for the 2 talks I did at ECO in Raleigh this week:
Great crowd. I really enjoyed myself.
Note: You can also find other presentations on my Whitepapers/Presentations page via the link at the top of the screen.
I spoke at a one day DOUG meeting yesterday. It was pretty cool. Very small intimate group of about 50. The speakers were Nitin Vengurlekar, Charles Kim, Cary Millsap and myself. All are Ace Directors and either work at Viscosity or Enkitec. As a bonus, Tanel Poder showed up to weigh in on some open discussion. Anyway, I thoroughly enjoyed it. I promised the group I would post my slides and a zip file with some of my scripts that I demoed. So here it is (click on the image to download a zip file with PDF and scripts):
Here’s a quick rundown of places I plan to be during the week.
After about four months without any speaking engagements, over the next three months I’ll have the opportunity to speak at several events. I’m looking forward to meet you at one of them!
April 3, I’ll be in Baden-Dättwil to speak about “ASH Analytics” at an event organized by SOUG. Since this is a new presentation covering some stuff that I wrote for the second edition of TOP, I’m looking forward to see how it works.
April 29/30, I’ll be in Berlin for presenting a 2-day seminar about the query optimizer. The event is organized by DOAG. Also in this case the content is based on the second edition of TOP. By the way, there are still a handful of free seats… so, if you are interested, don’t wait too long to subscribe.
May 20, during the evening, I’ll be in Birmingham to speak at an event organized by Oracle Midlands. I’ll give two presentations: “Adaptive Query Optimization” and “Row Chaining and Row Migration Internals”.
The company I work for, Trivadis, is very pleased to organize, on the 10th and 11th of June, an outstanding seminar with top guest speakers in Zurich. This year’s focus will be on the Oracle query optimizer, also known as a cost-based optimizer (CBO).
The query optimizer is not only one of the most complex pieces of software that constitutes the Oracle kernel; it is also one of the most unappreciated. Why? To make the best and most efficient use of the query optimizer, you definitely need to understand how it works. This is exactly what we are aiming for at the CBO Days.
Enjoy the two days with:
Since everyone seems to be all twitterpated about Oracle Database 12c this week, I thought I’d post a quick note to let you know that the slides from the presentation on 12c Adaptive Optimization I did at the Hotsos Symposium 2013 (with a lot of help from Maria) are now available in the Whitepapers / Presentations section of this blog.
While I’m on the topic, I found this little blurb in the Oracle Database 12c Release 1 New Features Guide: