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.