DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EsgynDB vs. Google Cloud Bigtable vs. Hive vs. InterSystems Caché vs. PouchDB

System Properties Comparison EsgynDB vs. Google Cloud Bigtable vs. Hive vs. InterSystems Caché vs. PouchDB

Editorial information provided by DB-Engines
NameEsgynDB  Xexclude from comparisonGoogle Cloud Bigtable  Xexclude from comparisonHive  Xexclude from comparisonInterSystems Caché  Xexclude from comparisonPouchDB  Xexclude from comparison
Caché is a deprecated database engine which is substituted with InterSystems IRIS. It therefore is removed from the DB-Engines Ranking.
DescriptionEnterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionGoogle's NoSQL Big Data database service. It's the same database that powers many core Google services, including Search, Analytics, Maps, and Gmail.data warehouse software for querying and managing large distributed datasets, built on HadoopA multi-model DBMS and application serverJavaScript DBMS with an API inspired by CouchDB
Primary database modelRelational DBMSKey-value store
Wide column store
Relational DBMSKey-value store
Object oriented DBMS
Relational DBMS
Document store
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.26
Rank#311  Overall
#141  Relational DBMS
Score3.86
Rank#90  Overall
#13  Key-value stores
#7  Wide column stores
Score64.82
Rank#18  Overall
#12  Relational DBMS
Score2.70
Rank#114  Overall
#22  Document stores
Websitewww.esgyn.cncloud.google.com/­bigtablehive.apache.orgwww.intersystems.com/­products/­cachepouchdb.com
Technical documentationcloud.google.com/­bigtable/­docscwiki.apache.org/­confluence/­display/­Hive/­Homedocs.intersystems.compouchdb.com/­guides
DeveloperEsgynGoogleApache Software Foundation infoinitially developed by FacebookInterSystemsApache Software Foundation
Initial release20152015201219972012
Current release3.1.3, April 20222018.1.4, May 20207.1.1, June 2019
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2commercialOpen Source
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++, JavaJavaJavaScript
Server operating systemsLinuxhostedAll OS with a Java VMAIX
HP Open VMS
HP-UX
Linux
OS X
Solaris
Windows
server-less, requires a JavaScript environment (browser, Node.js)
Data schemeyesschema-freeyesdepending on used data modelschema-free
Typing infopredefined data types such as float or dateyesnoyesyesno
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonoyesno
Secondary indexesyesnoyesyesyes infovia views
SQL infoSupport of SQLyesnoSQL-like DML and DDL statementsyesno
APIs and other access methodsADO.NET
JDBC
ODBC
gRPC (using protocol buffers) API
HappyBase (Python library)
HBase compatible API (Java)
JDBC
ODBC
Thrift
.NET Client API
JDBC
ODBC
RESTful HTTP API
HTTP REST infoonly for PouchDB Server
JavaScript API
Supported programming languagesAll languages supporting JDBC/ODBC/ADO.NetC#
C++
Go
Java
JavaScript (Node.js)
Python
C++
Java
PHP
Python
C#
C++
Java
JavaScript
Server-side scripts infoStored proceduresJava Stored Proceduresnoyes infouser defined functions and integration of map-reduceyesView functions in JavaScript
Triggersnononoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingnoneSharding infowith a proxy-based framework, named couchdb-lounge
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication between multi datacentersInternal replication in Colossus, and regional replication between two clusters in different zonesselectable replication factorSource-replica replicationMulti-source replication infoalso with CouchDB databases
Source-replica replication infoalso with CouchDB databases
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesyesyes infoquery execution via MapReducenoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate consistency (for a single cluster), Eventual consistency (for two or more replicated clusters)Eventual ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integrityyesnonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic single-row operationsnoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infoby using IndexedDB, WebSQL or LevelDB as backend
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)Access rights for users, groups and rolesAccess rights for users, groups and rolesno

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
EsgynDBGoogle Cloud BigtableHiveInterSystems CachéPouchDB
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

What is Google Bigtable? | Definition from TechTarget
1 March 2022, TechTarget

Review: Google Bigtable scales with ease
7 September 2016, InfoWorld

Google Introduces Autoscaling for Cloud Bigtable for Optimizing Costs
31 January 2022, InfoQ.com

Fire, water, knock out Google Cloud in Paris
27 April 2023, The Stack

Google introduces Cloud Bigtable managed NoSQL database to process data at scale
6 May 2015, VentureBeat

provided by Google News

Altiscale Becomes First Hadoop-as-a-Service to Deliver Apache Hive 0.13
25 March 2024, Yahoo Singapore News

Run Apache Hive workloads using Spark SQL with Amazon EMR on EKS | Amazon Web Services
18 October 2023, AWS Blog

Data Engineering in 2024: Predictions For Data Lakes and The Serving Layer
23 January 2024, Datanami

Top 80 Hadoop Interview Questions and Answers for 2024
15 February 2024, Simplilearn

18 Top Big Data Tools and Technologies to Know About in 2024
24 January 2024, TechTarget

provided by Google News

CeBIT 2003 – InterSystems Caché 5 on show with development partners | bobsguide
20 March 2024, Bobsguide

Defense Health Agency Awards Four Points Technology $39 Million for Intersystems Software Licenses and Maintenance
21 September 2023, ClearanceJobs

AWS, GCP, Oracle, Azure, SAP Lead Cloud DBMS Market: Gartner
12 February 2022, CRN

VMware Surges Ahead in the Virtual SAN Sector with vSAN 6.6
30 May 2017, Server Watch

Associative Data Modeling Demystified - Part1 - DataScienceCentral.com
9 July 2016, Data Science Central

provided by Google News

Getting Started with PouchDB Client-Side JavaScript Database — SitePoint
7 September 2016, SitePoint

Building an Offline First App with PouchDB — SitePoint
10 March 2014, SitePoint

3 Reasons To Think Offline First
22 March 2017, ibm.com

Create Offline Web Apps Using Service Workers & PouchDB — SitePoint
7 March 2017, SitePoint

Offline-first web and mobile apps: Top frameworks and components
22 January 2019, TechBeacon

provided by Google News



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here