Using Oracle columnar data across the Information Lifecycle
Track
Development & Middleware
Date and time
Friday, 20. October 2017., 09:30
Room
Hall C
Duration
45'
This talk follows from from the \"When to use Oracle In-Memory\" talk. Oracle has built a set of columnar technologies that are designed to keep the benefits of columnar processing as data gets older and colder and automation for moving data between these storage technologies at the most appropriate time.This talk will look at how Oracle In-Memory can overflow to columnar on flash, to hybrid columnar compression, and support for columnar data using Big Data SQL and how each of these fit into the information lifecycle: when to use them, when to move data between them, and how to determine which is the best for each use case.Finally we will show practically how to use the tools Oracle provided to help with these decision.
Lecture details
About speaker
Roger MacNicol, author
After 5 years at a startup in the UK I moved to the US and spent 5 years working on ANSI SQL support for multi-dimensional databases. In 1995, I moved to Sybase and became the query engine architect for the world's first commercial pure columnar database and chair of the TPC-H subcommittee.In 2005, I moved to Oracle, spending first 2 years in the Data Guard group at the last 10 years in the Data Storage Technologies where I am now the Architect for Exadata Smart Scan, co-owner of the table scan driver, and a member of both the In-Memory and Big Data SQL teams.
Best Sponsor
Better Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.