Thread by @alexxubyte

/1 8 Data Structures That Power Your Databases. Which one should we pick?

/2 The answer will vary depending on your use case. Data can be indexed in memory or on disk. Similarly, data formats vary, such as numbers, strings, geographic coordinates, etc. The system might be write-heavy or read-heavy.

/3 All of these factors affect your choice of database index format.

The following are some of the most popular data structures used for indexing data:

🔹Skiplist: a common in-memory index type. Used in Redis

/4 🔹Hash index: a very common implementation of the “Map” data structure (or “Collection”)
🔹SSTable: immutable on-disk “Map” implementation
🔹LSM tree: Skiplist + SSTable. High write throughput
🔹B-tree: disk-based solution. Consistent read/write performance

/5 🔹Inverted index: used for document indexing. Used in Lucene
🔹Suffix tree: for string pattern search
🔹R-tree: multi-dimension search, such as finding the nearest neighbor

/6 This is not an exhaustive list of all database index types. Over to you:

1). Which one have you used and for what purpose?
2). There is another one called “reverse index”. Do you know the difference between “reverse index” and “inverted index”?

/7 I will provide a more in-depth analysis of this topic. Subscribe to our newsletter to get the latest update: bit.ly/3whEH2D

/8 I hope you've found this thread helpful.

Follow me @alexxubyte for more.

Like/Retweet the first tweet below if you can:

https://twitter.com/alexxubyte/status/1617564098820182018

Also posted the thread on hackernews. Upvote would be appreciated: news.ycombinator.com/item?id=344916…