in-memory database

Hybrid Transaction Analytical Processing – The Third Kind of Database

Gary Orenstein
Gary Orenstein

For years, we have lived in a data processing world with two primary kinds of database systems, one for capturing incoming data and managing transactions, and another for answering questions and analyzing the data for insight and intelligence.

The first system is what we know as a database, a system designed so you can put data in and get data out reliably and quickly. The second system is generally referred to as a data warehouse.

There has long been a historical divide between these two systems, but HTAP or Hybrid Transaction Analytical Processing, is a new approach that brings these two worlds together.

Check out the complete article on CIO Review

database HTAP in-memory

The historical data divide and HTAP unification

Databases Data Warehouses
Transactions Analytics
Online Transaction Processing Online Analytical Processing
Hybrid Transaction Analytical Processing
HTAP merges the worlds of the worlds of transactions and analytics

In a recently published article on CIO Review, we dig into more details on this new type of processing and the emergence of database platforms to fulfill HTAP requirements. Here’s a preview of the article’s table of contents.

  • Close Encounters with a Third Kind of Database
    • Database Beginnings
    • Enter the Data Warehouse
    • Origins of Transactional and Analytical Systems
    • Benefits of an HTAP Capable Systems
      • Elimination of the ETL Process
      • Data Accurate to the Last Transaction
      • An Analytical Feedback Loop for Transactions
    • Getting Started with HTAP
      • Memory-optimized or In-Memory Databases
      • Distributed Systems
      • Relational Engine
      • Look for Capabilities in Both Operational Database and Data Warehouse Workloads

Please feel free to take a look at the entire article on CIO Review.

Introducing MemSQL 6.5
The world’s fastest database.
Just got faster.