Business Intelligence & Analytics
Wednesday, 16. October 2019., 16:30
Analytic 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 does not have this problem because just the columns in the query need to be accessed. In addition, columnar formatted data tends to compress well and work well with vectorized processing like Single Instruction Multiple Data (SIMD).Oracle Database In-Memory can transform existing row-format database objects into an in-memory columnar format. These columnar formatted objects can be queried at orders of magnitude faster speed than the equivalent row format. This session will explore how this columnar format provides such a dramatic performance improvement for analytic queries, how it can be used in mixed workload environments and not impact OLTP and how it works with the rest of Oracle Database so that no application changes are required.