# Htap Characteristics Of Tidb

+ matrix mixing
  + column store (TiFlash) supports real-time updates based on primary keys
  + TiFlash as a column store replica
  + Isolation of OLTP and OLAP services
+ Smart selection (CBO automatic or manual selection)
+ MPP architecture
------------------------------------------------------------
HTAP characteristics of TiDB
Let's summarize the HTAP features of the TiDB database:
1. Rows and rows are mixed. TiKV and TiFlash have completed row and column store respectively.
  1. column store (TiFlash) supports real-time updates based on the primary key.
  2. TiFlash serves as a replica of column store.
  3. OLTP is isolated from OLAP services.
2. smart selection (CBO automatic or manual selection), CBO realizes the function of automatically routing data to TiKV or TiFlash in the environment of complex spot check and range scanning. For OLTP and OLAP business clear scenario, we can also support manual specification.
3. MPP architecture that accelerates aggregation and connection operations on TiFlash (note: it can only be done on TiFlash).