Book a Demo Start Instantly

Hybrid Transactional and Analytical Processing in TiDB

TiDB provides a single source of truth for your data. Transactions are recorded swiftly in a row store and complex analytical queries are answered by a column store. Best of all, when you write the data to the database, it is recorded in both stores simultaneously.

You do not need complicated and time consuming Enhance, Transform, and Load (ETL) processes anymore since TiDB manages both the row and the column store within a single database. When a query is submitted, the optimizer determines if it is best served by the row store, column store, or a combination of the two.

TiDB Hybrid Transactional and Analytical Processing provides

  • Analytics in your database of record
  • Access to consistent data across both the row and column stores
  • No need for manual ETL processes to run, and potentially fail

Hybrid Transactional and Analytical Processing means that your data is consistently written and queried, ensuring you always get the most current information to serve your business needs.

Case Study

Why We Chose a Scale-Out Data Warehouse for Real-Time Analytics

As PatSnap's businesses developed, their data size quickly grew. To perform real-time analytics, they replaced their Segment + Amazon Redshift data analytics architecture with a TiDB + Apache Flink data warehouse solution.


Access tutorials, guides, release notes, and more

View Docs

Join our community to connect with TiDB contributors from around the world


Check out TiDB and TiDB Cloud Frequently Asked Questions