DBMS > Google BigQuery vs. TiDB
System Properties Comparison Google BigQuery vs. TiDB
Please select another system to include it in the comparison.
Our visitors often compare Google BigQuery and TiDB with MySQL, ClickHouse and Snowflake.
|Editorial information provided by DB-Engines|
|Name||Google BigQuery Xexclude from comparison||TiDB Xexclude from comparison|
|Description||Large scale data warehouse service with append-only tables||TiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.|
|Primary database model||Relational DBMS||Relational DBMS|
|Secondary database models||Document store|
|Current release||6.6.0, February 2023|
|License Commercial or Open Source||commercial||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.|
|Implementation language||Go, Rust|
|Server operating systems||hosted||Linux|
|Typing predefined data types such as float or date||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|SQL Support of SQL||yes||yes|
|APIs and other access methods||RESTful HTTP/JSON API||JDBC|
|Supported programming languages||.Net|
|Partitioning methods Methods for storing different data on different nodes||none||horizontal partitioning (by key range)|
|Replication methods Methods for redundantly storing data on multiple nodes||Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes with TiSpark Connector|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||no currently only supported in syntax|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no Since BigQuery is designed for querying data||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no|
|User concepts Access control||Access privileges (owner, writer, reader) on dataset, table or view level Google Cloud Identity & Access Management (IAM)||Users with fine-grained authorization concept. No user groups or roles.|
|More information provided by the system vendor|
|Specific characteristics||TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...|
|Competitive advantages||In the current database landscape, infrastructure engineers often have to use one...|
|Typical application scenarios||TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...|
|Key customers||Shopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...|
|Market metrics||25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...|
|Licensing and pricing models||Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
The popularity of cloud-based DBMSs has increased tenfold in four years
|Recent citations in the news|
Google Cloud partners Coinbase to accept crypto payments - Ledger Insights
Google BiqQuery: How delete dublicate rows from table without any extra colum
Query Google BiqQuery from a Scala console app
Connecting to Google BiqQuery · Issue #15497 · dbeaver/dbeaver · GitHub
Import Google BigQuery data | H2O Drive
provided by Google News
PingCAP’s Innovative TiDB Database – Techstrong.TV
PingCAP Announces TiDB Cloud Serverless Tier, Delivering ...
3.4 times more Oracle MySQL transactions with Pliops' SSD array ...
PingCAP to Close Out Data At Scale Roadshow 2023 with Final ...
PingCAP Announces the General Availability of TiDB Cloud to ...
provided by Google News
Sales Account Executive Bay Area - Remote
Sales Development Representative (SDR)
Web Application Architect 3
Share this page