DBMS > Google BigQuery vs. Hive vs. Informix
System Properties Comparison Google BigQuery vs. Hive vs. Informix
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Google BigQuery Xexclude from comparison||Hive Xexclude from comparison||Informix Xexclude from comparison|
|Description||Large scale data warehouse service with append-only tables||data warehouse software for querying and managing large distributed datasets, built on Hadoop||A secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things data|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS Since Version 12.10 support for JSON/BSON datatypes compatible with MongoDB|
|Secondary database models||Document store|
Time Series DBMS with Informix TimeSeries Extension
|Developer||Apache Software Foundation initially developed by Facebook||IBM, HCL Technologies Effective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.|
|Current release||3.1.3, April 2022||14.10.FC5, November 2020|
|License Commercial or Open Source||commercial||Open Source Apache Version 2||commercial free developer edition available|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||Java||C, C++ and Java|
|Server operating systems||hosted||All OS with a Java VM||AIX|
|Typing predefined data types such as float or date||yes||yes||yes Since Version 12.10 support for JSON/BSON datatypes|
|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|
|SQL Support of SQL||yes||SQL-like DML and DDL statements||yes|
|APIs and other access methods||RESTful HTTP/JSON API||JDBC|
JSON API MongoDB compatible
MQTT (Message Queue Telemetry Transport)
RESTful HTTP API
|Supported programming languages||.Net|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes query execution via MapReduce||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no Since BigQuery is designed for querying data||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes|
|User concepts Access control||Access privileges (owner, writer, reader) on dataset, table or view level Google Cloud Identity & Access Management (IAM)||Access rights for users, groups and roles||Users with fine-grained authentication, authorization, and auditing controls|
More information provided by the system vendor
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
Why is Hadoop not listed in the DB-Engines Ranking?
|Recent citations in the news|
Comparing Redshift and BigQuery in various terms
Great Google BigQuery Date Functions to Know - Software connecting all databases
Google BigQuery catalogs
4 Ways MongoDB Enhances Your Google BigQuery Experience
Google Cloud Technology Nuggets — January 16–31, 2023 Edition | by Romin Irani | Google Cloud - Community
provided by Google News
Global Open-Source Database Software Market Size and Forecast ...
Precisely targets data quality with triple release -
Spark vs. Presto: Unleashing the Power of Data
What Is Apache Hive? (Definition, Benefits, Challenges)
IBM Embraces Iceberg, Presto in New Watsonx Data Lakehouse
provided by Google News
Relational Databases Software Market International Business ...
Top ICT tenders: A focus on software for social safety
Relational Database Management System Market 2023 Growth ...
Global Relational Databases Software Market Size and Forecast ...
Fugitive Silicon Valley tech executive hauled into federal court
provided by Google News
Sales and Revenue Analyst
Data Scientist - Battlefield
[ No Corp-to-Corp ] Cloudera Administrator
Big Data Engineer
2nd Shift Shipping Clerk
1st Shift Shipping Clerk, CSD
1st Shift Receiving Clerk
Share this page