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

DBMS > Memcached vs. OpenSearch vs. Quasardb vs. Snowflake vs. SQream DB

System Properties Comparison Memcached vs. OpenSearch vs. Quasardb vs. Snowflake vs. SQream DB

Editorial information provided by DB-Engines
NameMemcached  Xexclude from comparisonOpenSearch  Xexclude from comparisonQuasardb  Xexclude from comparisonSnowflake  Xexclude from comparisonSQream DB  Xexclude from comparison
DescriptionIn-memory key-value store, originally intended for cachingA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneDistributed, high-performance timeseries databaseCloud-based data warehousing service for structured and semi-structured dataa GPU-based, columnar RDBMS for big data analytics workloads
Primary database modelKey-value storeSearch engineTime Series DBMSRelational DBMSRelational DBMS
Secondary database modelsVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score18.08
Rank#32  Overall
#4  Key-value stores
Score16.03
Rank#37  Overall
#4  Search engines
Score0.21
Rank#322  Overall
#29  Time Series DBMS
Score130.36
Rank#8  Overall
#5  Relational DBMS
Score0.74
Rank#224  Overall
#103  Relational DBMS
Websitewww.memcached.orggithub.com/­opensearch-project
opensearch.org
quasar.aiwww.snowflake.comsqream.com
Technical documentationgithub.com/­memcached/­memcached/­wikiopensearch.org/­docs/­latestdoc.quasar.ai/­masterdocs.snowflake.net/­manuals/­index.htmldocs.sqream.com
DeveloperDanga Interactive infooriginally developed by Brad Fitzpatrick for LiveJournalAmazon Web ServicesquasardbSnowflake Computing Inc.SQream Technologies
Initial release20032021200920142017
Current release1.6.27, May 20242.5.0, January 20233.14.1, January 20242022.1.6, December 2022
License infoCommercial or Open SourceOpen Source infoBSD licenseOpen Source infoApache Version 2.0commercial infoFree community edition, Non-profit organizations and non-commercial usage are eligible for free licensescommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
  • STACKIT OpenSearch offers OpenSearch in a managed version in enterprise grade, 100% GDPR-compliant, for a wide range of applications like analytics, website search, offering scalability and fast data access.
Implementation languageCJavaC++C++, CUDA, Haskell, Java, Scala
Server operating systemsFreeBSD
Linux
OS X
Unix
Windows
All OS with a Java VMBSD
Linux
OS X
Windows
hostedLinux
Data schemeschema-freeschema-free infoFlexible type definitions. Once a type is defined, it is persistentschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)yes
Typing infopredefined data types such as float or datenoyesyes infointeger and binaryyesyes, ANSI Standard SQL Types
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.noyes
Secondary indexesnoyes infoAll search fields are automatically indexedyes infowith tagsno
SQL infoSupport of SQLnoSQL-like query languageSQL-like query languageyesyes
APIs and other access methodsProprietary protocolJava API
RESTful HTTP/JSON API
HTTP APICLI Client
JDBC
ODBC
.Net
JDBC
ODBC
Supported programming languages.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
Perl
PHP
Python
Ruby
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
.Net
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresnoyesnouser defined functionsuser defined functions in Python
Triggersnoyes infoby using the 'percolation' featurenono infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding infoconsistent hashingyeshorizontal and vertical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnone infoRepcached, a Memcached patch, provides this functionallityyesSource-replica replication with selectable replication factoryesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnowith Hadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentnoyesyes infoby using LevelDByesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infoTransient modeno
User concepts infoAccess controlyes infousing SASL (Simple Authentication and Security Layer) protocolCryptographically strong user authentication and audit trailUsers with fine-grained authorization concept, user roles and pluggable authentication
More information provided by the system vendor
MemcachedOpenSearchQuasardbSnowflakeSQream DB
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» 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
3rd partiesAiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
MemcachedOpenSearchQuasardbSnowflakeSQream DB
DB-Engines blog posts

Redis extends the lead in the DB-Engines key-value store ranking
3 February 2014, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Why DDoS Threat Actors Are Shifting Their Tactics
15 March 2024, Infosecurity Magazine

Intel Continues To Demonstrate The Importance Of Software Optimizations: Clear Linux + Xeon Max Benchmarks
23 October 2023, Phoronix

Why Redis beats Memcached for caching
14 September 2017, InfoWorld

Memcached DDoS: The biggest, baddest denial of service attacker yet
1 March 2018, ZDNet

What are memcached servers, and why are they being used to launch record-setting DDoS attacks?
6 March 2018, GeekWire

provided by Google News

Optimize storage costs in Amazon OpenSearch Service using Zstandard compression | Amazon Web Services
11 June 2024, AWS Blog

Behind the Scenes: Upgrading OpenSearch efficiency with OCI flexible vertical scaling
13 February 2024, blogs.oracle.com

Modernize your data observability with Amazon OpenSearch Service zero-ETL integration with Amazon S3 | Amazon ...
5 June 2024, AWS Blog

OCI Search with OpenSearch 2.11 delivers easy access to latest AI innovations
13 March 2024, blogs.oracle.com

Simplify your query management with search templates in Amazon OpenSearch Service | Amazon Web Services
3 April 2024, AWS Blog

provided by Google News

Record quasar is most luminous object in the universe
20 February 2024, EarthSky

Quasar Partners with PTC to Empower IoT Customers with High-Performance Data Solutions
11 September 2023, Datanami

QUASAR yacht (Bilgin, 46.8m, 2016)
3 July 2023, Boat International

Hubble Unexpectedly Finds Double Quasar in Distant Universe
5 April 2023, Science@NASA

Quasar Selected by National Renewable Energy Laboratory to Help with Energy System De-risking and Optimization
6 June 2023, PR Newswire

provided by Google News

The Snowflake Attack May Be Turning Into One of the Largest Data Breaches Ever
6 June 2024, WIRED

Hackers steal “significant volume” of data from hundreds of Snowflake customers
10 June 2024, Ars Technica

Mandiant says hackers stole a 'significant volume of data' from Snowflake customers
10 June 2024, TechCrunch

Pure Storage confirms data breach after Snowflake account hack
11 June 2024, BleepingComputer

Ticketmaster's Snowflake data breach was just one of 165
11 June 2024, The Verge

provided by Google News

I SQream, you SQream, we all SQream for … data analytics?
5 October 2023, Fierce Network

SQream Announces Strategic Integration for Powerful Big Data Analytics with Dataiku
9 February 2024, insideBIGDATA

SQream Joins Samsung Cloud Platform Ecosystem
26 July 2023, Datanami

GPU data warehouse startup SQream lands $39.4M funding round
24 June 2020, SiliconANGLE News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

provided by Google News



Share this page

Featured Products

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

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