How do associations work in the Cloud Spanner database?

Question

How do associations work in the Cloud Spanner database?

How do connections in the Google Cloud Spanner database work?

Will a quick connection request be executed? Is there any comparison between SQL (MySql, Oracle, MSSQL) and NewSQL (Cloud Spanner / TiDB / CockroachDB)?

+4

sql google-cloud-platform google-cloud-spanner cockroachdb tidb

Kumar siva Mar 24 '17 at 17:32

source share

3 answers

shenli3514 · Answer 1 · 2017-05-22T12:35:31+0000

TiDB supports connection. TiDB stores data in a tikv server and processes sql in a tidb server. tidb-server will retrieve data from the tikv server and process the SQL logic.

TiDB HashJoin . SortMergeJoin IndexLookupJoin, SQL-. HashJoin - . SortMergeJoin IndexLookupJoin . . TiDB , .

, HashJoin TiDB.

Albert Cui · Answer 2 · 2017-03-24T17:58:50+0000

Cloud Spanner , , , . , Cloud Spanner , , , . Cloud Spanner , .

Alex Robinson · Answer 3 · 2017-03-24T18:15:38+0000

, Spanner, , NewSQL, CockroachDB :

https://www.cockroachlabs.com/blog/cockroachdbs-first-join/ https://www.cockroachlabs.com/blog/better-sql-joins-in-cockroachdb/

How do associations work in the Cloud Spanner database?

More articles: