Skip to main content

HyPer: Hybrid OLTP&OLAP High ­Performance Database System

Ref-Nr: TA-B70096


  • Simultaneous OLAP-transactions andOLTP-queries
  • Arbitrarily current and consistent snapshotsof OLTP data
  • Guarantees the ACID properties


Online transaction processing (OLTP) and online analytical processing (OLAP) present ­different challenges for database architectures. Currently, customers with high rates of mission-­critical transactions have split their data into two separate systems, one database for OLTP and one so-called data warehouse for OLAP. While allowing for decent transaction rates, this ­separation has many disadvantages including data freshness issues due to the delay caused by only periodically initiating the Extract, Transform, Load-data staging and excessive resource consumption due to maintaining two separate information systems.

Bilder & Videos


We offer an efficient hybrid system, called HyPer, that can handle both OLTP and OLAP simultaneously by using hardware-assisted replication mechanisms to maintain consistent snapshots of the transactional data. It is a main-memory database system that guarantees the ACID properties of OLTP transactions and executes OLAP query sessions (multiple queries) on the same, arbitrarily current and consistent snapshot.


The invention provides a main-memory database system that

  • processes OLTP transactions at rates of tens of thousands per second, and, at the same time,
  • processes OLAP queries on up-to-date snapshots of the transactional data
  • guarantees the ACID properties
  • creates transaction consistent backup archives of the entire database on non-volatile storage.

Bayerische Patentallianz GmbH

089 5480177-0
Destouchesstr. 68
80796 München



Angebot Anbieter-Website

Kontakt | Geschäftsstelle

TransferAllianz e. V.
Christiane Bach-Kaienburg

c/o TransMIT GmbH
Kerkrader Straße 3
D-35394 Gießen