DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Manticore Search vs. Microsoft Azure Table Storage vs. OpenSearch vs. Oracle Rdb vs. Snowflake

System Properties Comparison Manticore Search vs. Microsoft Azure Table Storage vs. OpenSearch vs. Oracle Rdb vs. Snowflake

Editorial information provided by DB-Engines
NameManticore Search  Xexclude from comparisonMicrosoft Azure Table Storage  Xexclude from comparisonOpenSearch  Xexclude from comparisonOracle Rdb  Xexclude from comparisonSnowflake  Xexclude from comparison
DescriptionMulti-storage database for search, including full-text search.A Wide Column Store for rapid development using massive semi-structured datasetsA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneCloud-based data warehousing service for structured and semi-structured data
Primary database modelSearch engineWide column storeSearch engineRelational DBMSRelational DBMS
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.29
Rank#302  Overall
#21  Search engines
Score4.04
Rank#77  Overall
#6  Wide column stores
Score16.03
Rank#37  Overall
#4  Search engines
Score1.14
Rank#178  Overall
#80  Relational DBMS
Score130.36
Rank#8  Overall
#5  Relational DBMS
Websitemanticoresearch.comazure.microsoft.com/­en-us/­services/­storage/­tablesgithub.com/­opensearch-project
opensearch.org
www.oracle.com/­database/­technologies/­related/­rdb.htmlwww.snowflake.com
Technical documentationmanual.manticoresearch.comopensearch.org/­docs/­latestwww.oracle.com/­database/­technologies/­related/­rdb-doc.htmldocs.snowflake.net/­manuals/­index.html
DeveloperManticore SoftwareMicrosoftAmazon Web ServicesOracle, originally developed by Digital Equipment Corporation (DEC)Snowflake Computing Inc.
Initial release20172012202119842014
Current release6.0, February 20232.5.0, January 20237.4.1.1, 2021
License infoCommercial or Open SourceOpen Source infoGPL version 2commercialOpen Source infoApache Version 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesnonoyes
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 languageC++Java
Server operating systemsFreeBSD
Linux
macOS
Windows
hostedAll OS with a Java VMHP Open VMShosted
Data schemeFixed schemaschema-freeschema-free infoFlexible type definitions. Once a type is defined, it is persistentFlexible Schema (defined schema, partial schema, schema free)yes infosupport of semi-structured data formats (JSON, XML, Avro)
Typing infopredefined data types such as float or dateInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyesyesyesyes
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.Can index from XMLnonoyes
Secondary indexesyes infofull-text index on all search fieldsnoyes infoAll search fields are automatically indexedyes
SQL infoSupport of SQLSQL-like query languagenoSQL-like query languageyesyes
APIs and other access methodsBinary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
RESTful HTTP APIJava API
RESTful HTTP/JSON API
CLI Client
JDBC
ODBC
Supported programming languagesElixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
.Net
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functionsnoyesuser defined functions
Triggersnonoyes infoby using the 'percolation' featureno infosimilar concept for controling cloud resources
Partitioning methods infoMethods for storing different data on different nodesSharding infoPartitioning is done manually, search queries against distributed index is supportedSharding infoImplicit feature of the cloud serviceShardingyes
Replication methods infoMethods for redundantly storing data on multiple nodesSynchronous replication based on Galera libraryyes infoimplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual 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 integritynononoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoisolated transactions for atomic changes and binary logging for safe writesoptimistic lockingnoyes, on a single nodeACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyes infoThe original contents of fields are not stored in the Manticore index.yesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonono
User concepts infoAccess controlnoAccess rights based on private key authentication or shared access signaturesUsers with fine-grained authorization concept, user roles and pluggable authentication
More information provided by the system vendor
Manticore SearchMicrosoft Azure Table StorageOpenSearchOracle RdbSnowflake
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
Manticore SearchMicrosoft Azure Table StorageOpenSearchOracle RdbSnowflake
DB-Engines blog posts

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

Integrating Manticore Search with Apache Superset
8 August 2023, hackernoon.com

Clickhouse vs Elasticsearch vs Manticore Search Query Times With a 1.7B NYC Taxi Rides Benchmark
1 June 2022, hackernoon.com

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

8 Google Alternatives: How to Search Crypto, the Dark Web, More
1 February 2023, Gizmodo

Highlighting in Search Results
24 May 2020, hackernoon.com

provided by Google News

Working with Azure to Use and Manage Data Lakes
7 March 2024, Simplilearn

How to use Azure Table storage in .Net
14 January 2019, InfoWorld

How to Use C# Azure.Data.Tables SDK with Azure Cosmos DB
9 July 2021, hackernoon.com

Quick Guide to Azure Storage Pricing
16 May 2023, DevOps.com

How to write data to Azure Table Store with an Azure Function
14 April 2017, Experts Exchange

provided by Google News

Amazon OpenSearch Serverless now supports Internet Protocol Version 6 (IPv6) - AWS
12 June 2024, AWS Blog

Behind the Scenes: Upgrading OpenSearch efficiency with OCI flexible vertical scaling
13 February 2024, Oracle

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

OCI Search with OpenSearch 2.11 delivers easy access to latest AI innovations
13 March 2024, Oracle

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

provided by Google News

Oracle Adds New AI-Enabling Features To MySQL HeatWave
23 March 2023, Forbes

Should we all consolidate databases for the storage benefits? Reg vultures deploy DevOps, zoos, haircuts
18 September 2020, The Register

2013 Data Science Salary Survey – O'Reilly
4 May 2013, O'Reilly Media

provided by Google News

Lessons from the Snowflake Breaches
12 June 2024, The Hacker News

Truist Bank says breach of customer data is unrelated to Snowflake
14 June 2024, SC Media

Mandiant Report: Snowflake Users Targeted for Data Theft and Extortion
12 June 2024, TechRepublic

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

provided by Google News



Share this page

Featured Products

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.

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

Present your product here