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.