Analytical queries typically scan large amounts of data using aggregations to find patterns or trends in the data. In a traditional row-based database this can be slow because each row must be examined to access the columns in a query. Columnar formatted data avoids this problem because just the columns in the query need to be accessed and columnar formatted data also tends to compress well and work well with vectorized processing like Single Instruction Multiple Data (SIMD) operations.
Oracle introduced Database In-Memory in Oracle Database 12c with a new in-memory columnar data format in addition to the traditional row format. Database In-Memory is compatible with all existing applications and can enable a 10x or better increase in analytic query performance. This session will use example SQL queries to demonstrate and then explain how this dual format enables both superfast analytics and online transaction processing. This session will also show you how Database In-Memory integrates with Oracle Database to enable you to run existing applications with no changes, and how you can use the new 19c Base Level feature to run Database In-Memory with up to a 16GB IM column store without having to license Database In-Memory. By attending this session, you will arm yourself with the knowledge necessary to not only get started with Database In-Memory but to dramatically improve the performance of your analytic queries.