DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CrateDB vs. Elasticsearch vs. Google Cloud Spanner vs. searchxml

System Properties Comparison CrateDB vs. Elasticsearch vs. Google Cloud Spanner vs. searchxml

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonElasticsearch  Xexclude from comparisonGoogle Cloud Spanner  Xexclude from comparisonsearchxml  Xexclude from comparison
DescriptionDistributed Date Store based on LuceneA distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricA horizontally scalable, globally consistent, relational database service. It is the externalization of the core Google database that runs the biggest aspects of Google, like Ads and Google Play.DBMS for structured and unstructured content wrapped with an application server
Primary database modelRelational DBMS
Search engine
Search engineRelational DBMSNative XML DBMS
Search engine
Secondary database modelsDocument store
Time Series DBMS
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.09
Rank#198  Overall
#95  Relational DBMS
#13  Search engines
Score150.32
Rank#7  Overall
#1  Search engines
Score4.24
Rank#91  Overall
#46  Relational DBMS
Score0.00
Rank#377  Overall
#7  Native XML DBMS
#24  Search engines
Websitecrate.iowww.elastic.co/­elasticsearchcloud.google.com/­spannerwww.searchxml.net/­category/­products
Technical documentationcrate.io/­docswww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlcloud.google.com/­spanner/­docswww.searchxml.net/­support/­handouts
DeveloperCrateElasticGoogleinformationpartners gmbh
Initial release2013201020172015
Current release7.8.0, June 20201.0
License infoCommercial or Open SourceOpen SourceOpen Source infoElastic Licensecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC++
Server operating systemsAll OS with a Java 7 (and higher) VMAll OS with a Java VMhostedWindows
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-free infoFlexible type definitions. Once a type is defined, it is persistentyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyes
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.nononoyes
Secondary indexesyesyes infoAll search fields are automatically indexedyesyes
SQL infoSupport of SQLyes, but no triggers and constraintsSQL-like query languageyes infoQuery statements complying to ANSI 2011no
APIs and other access methodsADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
Java API
RESTful HTTP/JSON API
gRPC (using protocol buffers) API
JDBC infoAt present, JDBC supports read-only queries. No support for DDL or DML statements.
RESTful HTTP API
RESTful HTTP API
WebDAV
XQuery
XSLT
Supported programming languagesErlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
Go
Java
JavaScript (Node.js)
Python
C++ infomost other programming languages supported via APIs
Server-side scripts infoStored proceduresuser defined functionsyesnoyes infoon the application server
Triggersnoyes infoby using the 'percolation' featurenono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryesMulti-source replication with 3 replicas for regional instances.yes infosychronisation to multiple collections
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectoryes infousing Google Cloud Dataflowno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Eventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyes infoby using interleaved tables, this features focuses more on performance improvements than on referential integrityno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infounique row identifiers can be used for implementing an optimistic concurrency control strategynoACID infoStrict serializable isolationmultiple readers, single writer
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.noMemcached and Redis integrationnono
User concepts infoAccess controlrights management via user accountsAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)Domain, group and role-based access control at the document level and for application services
More information provided by the system vendor
CrateDBElasticsearchGoogle Cloud Spannersearchxml
Specific characteristicsCrateDB is an open source distributed SQL database that spreads data and processing...
» more
Competitive advantagesCrateDB is typically used in operational analytics applications, particularly those...
» more
Typical application scenariosCrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
Licensing and pricing modelsCrateDB pricing CrateDB Community Edition is open source and free to use under the...
» more

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
CrateDBElasticsearchGoogle Cloud Spannersearchxml
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

MindsDB is now the leading and fastest growing applied ML platform in the world
3 November 2022, PR Newswire UK

Crate.io Expands CrateDB Cloud with the Launch of CrateDB Edge
15 April 2021, GlobeNewswire

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io Introduces CrateDB 2.0 Enterprise and Open Source Editions
16 May 2017, Business Wire

provided by Google News

Searching for search: UK Gov wants to dump GOV.UK Elasticsearch
17 November 2022, The Stack

IronCore Labs Launches Advanced Searchable Encryption Features
15 November 2022, PR Newswire

Leaked Amazon Prime Video Server Exposed Users Viewing Habits
1 November 2022, HackRead

Configuring rsyslog to send data to your LogScale repository
31 October 2022, CrowdStrike

Jetpack Search Adds Free Tier and 3-Month Free Trial
18 November 2022, WP Tavern

provided by Google News

Google Cloud Spanner Introduces Free Trial Instances and Fine-Grained Access Control
24 September 2022, InfoQ.com

Google rolls out cloud database innovations, including free trial instances for Spanner
15 September 2022, SiliconANGLE News

Cloud Spanner Introduces Committed Use Discounts
19 March 2022, InfoQ.com

Akamai and Macrometa In Global Data Network Hookup
10 November 2022, Datanami

Google Cloud Spanner Adds PostgreSQL Interface: Is PostgreSQL Now Standard for Cloud Databases?
29 October 2021, InfoQ.com

provided by Google News

Job opportunities

Elasticsearch Engineer, Mid
Booz Allen Hamilton, Chantilly, VA

Mid-Level Java / Elasticsearch Developer (Remote)
cloudteam, Jacksonville, FL

Engineer - Stores and Supply Chain (Full-Time Remote or Hybrid)
TARGET, Brooklyn Park, MN

Applications Support
JPMorgan Chase Bank, N.A., Columbus, OH

Security Engineer
NOKIA, Sunnyvale, CA

Database Administrator, Senior, Google Cloud Platform (GCP)- REMOTE
Kroger General Office, Cincinnati, OH

Cloud Relational Database Engineer
Ford Motor Company, Dearborn, MI

Architect - Cloud Infrastructure and Databases
Ford Motor Company, Dearborn, MI

Software Engineer, Cloud - Front-End
YugabyteDB, United States

Lead Applications Developer - Remote
UNITED PARCEL SERVICE, Parsippany, NJ

jobs by Indeed



Share this page

Featured Products

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

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

Present your product here