Before Oracle introduced dual format memory architecture, it was very challenging to find the best approach to accelerate the performance of OLAP and OLTP in the same database. We witnessed two types of DBMS in the market, columnar oriented and row-major oriented. Columnar oriented DBMS is treated as a proven practice for traditional Data Warehouse, however the pure columnar format is not suited for the real time analytics demanding on high volume transactional data. The traditional row-major DBMS is suited for OLTP workloads, however to retrieve high performance analytics, it requires analytic indexes, such as Oracle bitmap indexes to achieve this goal. Additionally, the overhead of index maintenance is expensive and bitmap indexes are not recommended for high transactional tables. The new Oracle 12c In-Memory option brings the dual format memory structure into one single database. The mixed OLTAP solution combining with the rapid advancement of hardware system can bring the data processing to a dramatic fast speed and a much higher scalability.

Before Oracle introduced dual format memory architecture, it was very challenging to find the best approach to accelerate the performance of OLAP and OLTP in the same database. We witnessed two types of DBMS in the market, columnar oriented and row-major oriented. Columnar oriented DBMS is treated as a proven practice for traditional Data Warehouse, however the pure columnar format is not suited for the real time analytics demanding on high volume transactional data. The traditional row-major DBMS is suited for OLTP workloads, however to retrieve high performance analytics, it requires analytic indexes, such as Oracle bitmap indexes to achieve this goal. Additionally, the overhead of index maintenance is expensive and bitmap indexes are not recommended for high transactional tables. The new Oracle 12c In-Memory option brings the dual format memory structure into one single database. The mixed OLTAP solution combining with the rapid advancement of hardware system can bring the data processing to a dramatic fast speed and a much higher scalability.

By Rich Niemiec, Viscosity North America  ◾ Michelle Malcher, Editor This is part one of an article series focused on new Oracle 12c R1 and R2 new features that I cover in my new book, Oracle 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press). This first part will cover upgrade paths, INMEMORY_SIZE, In-Memory Column…

By Rich Niemiec, Viscosity North America  ◾ Michelle Malcher, Editor This is part one of an article series focused on new Oracle 12c R1 and R2 new features that I cover in my new book, Oracle 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press). This first part will cover upgrade paths, INMEMORY_SIZE, In-Memory Column…