DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud Table Store vs. Google Cloud Firestore vs. Google Search Appliance vs. IBM Db2

System Properties Comparison Alibaba Cloud Table Store vs. Google Cloud Firestore vs. Google Search Appliance vs. IBM Db2

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlibaba Cloud Table Store  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonGoogle Search Appliance  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparison
DescriptionA fully managed Wide Column Store for large quantities of semi-structured data with real-time accessCloud Firestore is an auto-scaling document database for storing, syncing, and querying data for mobile and web apps. It offers seamless integration with other Firebase and Google Cloud Platform products.The Google Search Appliance consists of hardware and software for indexing documents in local networks.Common in IBM host environments, 2 different versions for host and Windows/Linux
Primary database modelWide column storeDocument storeSearch engineRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDB
Secondary database modelsDocument store
RDF store infoin DB2 LUW (Linux, Unix, Windows)
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.31
Rank#236  Overall
#10  Wide column stores
Score5.66
Rank#57  Overall
#9  Document stores
Score2.81
Rank#91  Overall
#10  Search engines
Score168.70
Rank#6  Overall
#5  Relational DBMS
Websitewww.alibabacloud.com/­product/­table-storefirebase.google.com/­products/­firestoreenterprise.google.com/­search/­products/­gsa.htmlwww.ibm.com/­analytics/­db2
Technical documentationwww.alibabacloud.com/­help/­product/­27278.htmfirebase.google.com/­docs/­firestoresupport.google.com/­gsawww.ibm.com/­support/­knowledgecenter/­SSEPGG
DeveloperAlibabaGoogleGoogleIBM
Initial release2016201720021983 infohost version
Current release12.1, October 2016
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercial infofree version is available
Cloud-based only infoOnly available as a cloud serviceyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++
Server operating systemshostedhostedAIX
HP-UX
Linux
Solaris
Windows
z/OS
Data schemeschema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesyesyes
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.nonono
Secondary indexesnoyesyes
SQL infoSupport of SQLnononoyes
APIs and other access methodsHTTP APIAndroid
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
Administrative API
Browser interface
HTTP API
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
Supported programming languagesJava
Python
Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresnoyes, Firebase Rules & Cloud Functionsyes
Triggersnoyes, with Cloud Functionsyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingShardingSharding infoonly with Windows/Unix/Linux Version
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceMaster-master replicationMaster-slave replicationyes infowith separate tools (MQ, InfoSphere)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoUsing Cloud Dataflownono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic single-row operationsyesACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlAccess rights based on subaccounts and tokensAccess rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.User authentication via various security protocolsfine grained access rights according to SQL-standard

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
3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
Alibaba Cloud Table StoreGoogle Cloud FirestoreGoogle Search ApplianceIBM Db2 infoformerly named DB2 or IBM Database 2
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

Recent citations in the news

Top data analytics tools comparison: Alibaba Cloud, AWS, Azure, Google Cloud, IBM - Latest Digital Transformation Trends | Cloud News
5 December 2019, Wire19

Alibaba Cloud Launches Serverless, Interactive Query Service
15 November 2018, SDxCentral

What are some ways of getting free credit for Alibaba Cloud?
21 September 2018, SitePoint

Alibaba Cloud: Rising Star in the Cloud Market
21 May 2018, Datamation

provided by Google News

5 cloud database comparison tips to guide your data strategy
23 January 2020, TechTarget

Google’s Cloud Firestore NoSQL database hits general availability
31 January 2019, TechCrunch

Compare Google Cloud Firestore and Firebase Realtime Database
9 August 2019, TechTarget

Google launches Cloud Firestore, a new document database for app developers
3 October 2017, TechCrunch

Google Launches Cloud Firestore, a Serverless NoSQL Database
31 January 2019, ADT Magazine

provided by Google News

Elastic NV Search: Product Overview and Insight
15 January 2020, eWeek

So Long Google Search Appliance
4 February 2016, Fortune

Google Search Appliance May Be Gone, But Category Lives On
27 May 2016, Fortune

What is a Google Search Appliance?
8 January 2014, TechRepublic

Google Search Appliance Fades Away
9 February 2016, CMSWire

provided by Google News

Splice Machine Readies New Edition Of Its Distributed SQL Data Platform
28 January 2020, CRN: Technology news for channel partners and solution providers

Where Does SAP On IBM i Go From Here?
15 January 2020, IT Jungle

Google offers IBM AS/400 apps new home in its cloud
20 January 2020, CIO

IBM i PTF Guide, Volume 22, Number 4
27 January 2020, IT Jungle

IBM Injects 'Data Science' AI Into Its Db2 Database
4 June 2019, Forbes

provided by Google News

Job opportunities

DATA ENGINEER II
Ultimate Software, Fort Lauderdale, FL

Lead Software Engineer
Disney Parks, Experiences and Products, Kissimmee, FL

SR PROGRAMMER VMS101150
ASAP Solutions, Parsippany, NJ

Software Engineer - Career
Equifax, Alpharetta, GA

2020 UPS Technology Summer Intern-Alpharetta (GA)
UNITED PARCEL SERVICE, Alpharetta, GA

IT Architect
New York City DEPT OF INFO TECH & TELECOMM, Brooklyn, NY

.NET Developer - ICIT
University of Wisconsin System, Whitewater, WI

eComm Channel Merchandiser, Zoro
Zoro Tools, Chicago, IL

Principal Middleware Automation Engineer
Discover Financial Services, Riverwoods, IL

Lead Middleware Engineer
Discover Financial Services, Riverwoods, IL

DPS - IT - Database Administrator, DB2
TEXAS DEPARTMENT OF PUBLIC SAFETY, Austin, TX

DB2 LUW Database Administrator
Bank of America, Charlotte, NC

Database Administrator_Remote
Sawdey Solution Services, Inc., Remote

IMS Sr. Database Administrator Remote/Virtual
Unum, Remote

DATABASE ADMINISTRATOR III
TEXAS DEPARTMENT OF MOTOR VEHICLES, Austin, TX

jobs by Indeed




Share this page

Featured Products

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here