What is the differences between the term SSTable and LSM Tree
Are these two terms used interchangeably?
I have read about how SSTable works, and usually, articles just start mentioning LSM Tree. However, they seem to be the same thing.
When should I use one term over the other?
Sorted Strings Table (SSTable) is a key/value string pair based file, sorted by keys.
However, LSM Tree is different:
In computer science, the log-structured merge-tree (or LSM tree) is a data structure with performance characteristics that make it attractive for providing indexed access to files with high insert volume, such as transactional log data. LSM trees, like other search trees, maintain key-value pairs. LSM trees maintain data in two or more separate structures, each of which is optimized for its respective underlying storage medium; data is synchronized between the two structures efficiently, in batches.
https://en.wikipedia.org/wiki/Log-structured_merge-tree
- Database design: Calculating the Account Balance
- Viewing a very large CSV file?
- How to get the mysql database relationship diagram
- Is TRUNCATE a DML statement?
- Derived account balance vs stored account balance for a simple bank account?
- DB Design: how to indicate if a column data is public or private
- Trim multiple trailing and leading keyword off string MYSQL
- Paging with a data set that can be changing?
- Making instances of Django records with a through model
- Django 5.0: How GeneratedField actually works?
- How does paging on a web page work?
- Run sql file in database from terminal
- What is the best way to do incremental backups in MySQL?
- Is there a command to clear screen in SQLite3?
- How to write this SQL query to find each account balance?
- How to add multiple columns in AWS redshift with alter table query
- Autoincrement separately for each foreign key
- How should international geographical addresses be stored in a relational database?
- Main size file database SQLite doesn't update, but -wal file does
- MySQL union - alias not visible
- How to index a non unique key in mongodb?
- User registration with CodeIgniter
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- How to submit a form that is the result of an XMLHttpRequest inside an empty div, without page refresh?
- "FATAL: remaining connection slots are reserved for non-replication superuser connections" triggers despite closing connections
- "Unsupported OP_QUERY command: insert" in Elixir project when trying to insert into Mongo DB
- Sql Server ldf files growing very fast
- How do I change the timezone to UTC in postgres permanently?
- What performance gains can I expect from database paging?