TiDB

TiDB

TiDB is a Chinese open source distributed and scalable hybrid transactional, and analytical processing database (HTAP). The database is built for infinite horizontal scalability and strong consistency while keeping a high availability. TiDB is compatible with MySQL and other relational databases.

What is TiDB?

TiDB is a Chinese open source distributed and scalable hybrid transactional, and analytical processing database (HTAP). The database is built for infinite horizontal scalability and strong consistency while keeping a high availability. TiDB is compatible with MySQL and other relational databases.

What type of data base is TiDB?

TiDB is a key-value database which is built for horizontal scalability. The database can be distributed across machine and used for analytical processing of time sensitive data.

What is a key-value database?

A key-value database is a type of NoSQL database that uses key-value pairs to store data. This method of storing and retrieving data is known to scale extremely well. Key-value Databases are also known as Key-value stores.

What join types does TiDB support?

TiDB is a RDBMS that supports sort-merge joins and hash joins.

What is a Sort-merge Join?

Sort-merge joins is a type of join found and used in a relational database management system (RDBMS). A Sort-merge join needs the same indexes as a hash join to combine two sorted list kind of like a zipper on a jacket. However, one thing that sets the sort-merge join apart is absolute symmetry. So the join order has no effect on performance, which makes the sort-merge join a perfect fit for outer joins, both left and right.

What is a Hash Join?

The hash join is a join algorithm and is used in the implementation of a relational database management system. They are typically faster than nested loop joins.

To learn more about the topic you can check out the best tutorials for TiDB (the topic). Or see what TiDB books are currently trending.