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.
