Which paper does the DeltaTree Index refer to?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: DeltaTree Index参考的是哪篇论文

| username: critical27

I would like to ask which paper the Delta Tree Index introduced in this blog refers to?
TiFlash Source Code Reading (6) Design and Implementation Analysis of DeltaTree Index | PingCAP

If there are references to other columnar storage systems, you can also post them, thank you~

The one I currently see as more similar is this one: Positional Update Handling in Column Stores

| username: xfworld | Original post link

They are all based on the evolution of LSM Tree. The implementation of LSM Tree can refer to Google LevelDB.

You can check these out:
https://zhuanlan.zhihu.com/p/648858037
https://zhuanlan.zhihu.com/p/640477369

| username: critical27 | Original post link

I am not asking about RocksDB. I am specifically referring to the in-memory data structure for incremental updates in TiFlash.

| username: xfworld | Original post link

You can check out the previous videos:


No more information~ :rofl:

| username: TiDBer_小阿飞 | Original post link

The DeltaTree engine of TiFlash implements the standard storage engine interface IStorage for Clickhouse data tables, allowing direct access through Clickhouse SQL. This enables simple read and write operations on the table’s data without introducing TiDB and TiKV, providing great convenience for integration testing and debugging. The standard read and write operations on the Clickhouse storage engine are implemented through BlockInputStream and BlockOutputStream, corresponding to writing and reading, respectively, and DeltaTree is no exception. The basic unit of writing and reading is Block (please refer to Block.h). Block organizes data by columns, and these columns together constitute several rows of data.

Structured Storage
https://zhuanlan.zhihu.com/p/139364833

| username: 呢莫不爱吃鱼 | Original post link

All valuable content, here to learn.

| username: Kongdom | Original post link

:astonished: A lot of valuable information to check out

| username: 健康的腰间盘 | Original post link

Bookmark, bookmark. It’s too dry.

| username: JinheLin | Original post link

It is Positional Update Handling in Column Stores.

| username: Jack-li | Original post link

Bookmark for learning

| username: 濱崎悟空 | Original post link

Bookmark for learning.

| username: zhh_912 | Original post link

Same here!

| username: 这里介绍不了我 | Original post link

Great, I’ll save this for later.

| username: jiayou64 | Original post link

:call_me_hand: Elementary school students come to recite the text :grinning:

| username: 濱崎悟空 | Original post link

Bookmark!

| username: ShawnYan | Original post link

@critical27 Welcome back to the community. If there is an answer that meets your expectations, you can mark it as the best answer.