Compacting Transactional Data in Hybrid OLTP & OLAP Databases
Source: VLD Digital
Growing main memory sizes have facilitated database management systems that keep the entire database in main memory. The drastic performance improvements that came along with these in-memory systems have made it possible to reunite the two areas of OnLine Transaction Processing (OLTP) and OnLine Analytical Processing (OLAP): An emerging class of hybrid OLTP and OLAP database systems allows to process analytical queries directly on the transactional data. By offering arbitrarily current snapshots of the transactional data for OLAP, these systems enable real-time business intelligence.