Content deleted Content added
Two examples of popular HTAP databases are added. Tags: Reverted Visual edit |
|||
Line 23:
Some challenges for HTAP include limited industry experience and skills, as well as undefined best practices.<ref name=Pezzini />
== Popular HTAP databases ==
Examples of some well-known HTAP databases include SAP HANA, TiDB, etc.
SAP HANA is a column store, yet optimised and tuned for OLTP queries. SAP HANA's query processing engine operate on dictionary-compressed data representations <ref>{{Cite web |last=Goel |first=Anil |date=2019.May |title=SAP HANA: A Data Platform for Enterprise Applications Purpose Built for Modern Hardware |url=https://15721.courses.cs.cmu.edu/spring2019/slides/26-saphana.pdf}}</ref>.
TiDB is a Raft-based HTAP database. It has two storage engines: TiKV (row-store) and TiFlash (column-store). TiKV uses Raft protocol to replicate data and maintain High Availability. TiFlash is a non-voting member in the Raft Group. The data in TiFlash is always up-to-dated. TiKV and TiFlash uses separate hardwares. Thus, analytical workloads will not impact OLTP queries<ref>{{Cite journal |last=Huang |first=Dongxu |last2=Liu |first2=Qi |last3=Cui |first3=Qiu |last4=Fang |first4=Zhuhe |last5=Ma |first5=Xiaoyu |last6=Xu |first6=Fei |last7=Shen |first7=Li |last8=Tang |first8=Liu |last9=Zhou |first9=Yuxing |last10=Huang |first10=Menglong |last11=Wei |first11=Wan |date=2020-08 |title=TiDB |url=http://dx.doi.org/10.14778/3415478.3415535 |journal=Proceedings of the VLDB Endowment |volume=13 |issue=12 |pages=3072–3084 |doi=10.14778/3415478.3415535 |issn=2150-8097}}</ref>.
==References==
| |||