DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EXASOL vs. Manticore Search vs. OpenSearch vs. Postgres-XL vs. Virtuoso

System Properties Comparison EXASOL vs. Manticore Search vs. OpenSearch vs. Postgres-XL vs. Virtuoso

Editorial information provided by DB-Engines
NameEXASOL  Xexclude from comparisonManticore Search  Xexclude from comparisonOpenSearch  Xexclude from comparisonPostgres-XL  Xexclude from comparisonVirtuoso  Xexclude from comparison
DescriptionHigh-performance, in-memory, MPP database specifically designed for in-memory analytics.Multi-storage database for search, including full-text search.A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneBased on PostgreSQL enhanced with MPP and write-scale-out cluster featuresVirtuoso is a multi-model hybrid-RDBMS that supports management of data represented as relational tables and/or property graphs
Primary database modelRelational DBMSSearch engineSearch engineRelational DBMSDocument store
Graph DBMS
Native XML DBMS
Relational DBMS
RDF store
Search engine
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryVector DBMSDocument store
Spatial DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.99
Rank#124  Overall
#58  Relational DBMS
Score0.22
Rank#312  Overall
#21  Search engines
Score16.36
Rank#37  Overall
#4  Search engines
Score0.49
Rank#256  Overall
#117  Relational DBMS
Score4.26
Rank#78  Overall
#13  Document stores
#4  Graph DBMS
#2  Native XML DBMS
#42  Relational DBMS
#2  RDF stores
#9  Search engines
Websitewww.exasol.commanticoresearch.comgithub.com/­opensearch-project
opensearch.org
www.postgres-xl.orgvirtuoso.openlinksw.com
Technical documentationwww.exasol.com/­resourcesmanual.manticoresearch.comopensearch.org/­docs/­latestwww.postgres-xl.org/­documentationdocs.openlinksw.com/­virtuoso
DeveloperExasolManticore SoftwareAmazon Web ServicesOpenLink Software
Initial release2000201720212014 infosince 2012, originally named StormDB1998
Current release6.0, February 20232.5.0, January 202310 R1, October 20187.2.11, September 2023
License infoCommercial or Open SourcecommercialOpen Source infoGPL version 2Open Source infoApache Version 2.0Open Source infoMozilla public licenseOpen Source infoGPLv2, extended commercial license available
Cloud-based only infoOnly available as a cloud servicenonononono
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++JavaCC
Server operating systemsFreeBSD
Linux
macOS
Windows
All OS with a Java VMLinux
macOS
AIX
FreeBSD
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesFixed schemaschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesyes infoSQL - Standard relational schema
RDF - Quad (S, P, O, G) or Triple (S, P, O)
XML - DTD, XML Schema
DAV - freeform filesystem objects, plus User Defined Types a/k/a Dynamic Extension Type
Typing infopredefined data types such as float or dateyesInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyesyesyes
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.noCan index from XMLyes infoXML type, but no XML query functionalityyes
Secondary indexesyesyes infofull-text index on all search fieldsyes infoAll search fields are automatically indexedyesyes
SQL infoSupport of SQLyesSQL-like query languageSQL-like query languageyes infodistributed, parallel query executionyes infoSQL-92, SQL-200x, SQL-3, SQLX
APIs and other access methods.Net
JDBC
ODBC
WebSocket
Binary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
Java API
RESTful HTTP/JSON API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
GeoSPARQL
HTTP API
JDBC
Jena RDF API
ODBC
OLE DB
RDF4J API
RESTful HTTP API
Sesame REST HTTP Protocol
SOAP webservices
SPARQL 1.1
WebDAV
XPath
XQuery
XSLT
Supported programming languagesJava
Lua
Python
R
Elixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
.Net
C
C++
Delphi
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
.Net
C
C#
C++
Java
JavaScript
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresuser defined functionsuser defined functionsyesuser defined functionsyes infoVirtuoso PL
Triggersyesnoyes infoby using the 'percolation' featureyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoPartitioning is done manually, search queries against distributed index is supportedShardinghorizontal partitioningyes
Replication methods infoMethods for redundantly storing data on multiple nodesSynchronous replication based on Galera libraryyesChain, star, and bi-directional replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoHadoop integrationnonoyes
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 integrityyesnonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyes infoisolated transactions for atomic changes and binary logging for safe writesnoACID infoMVCCACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyes infoThe original contents of fields are not stored in the Manticore index.yesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlAccess rights for users, groups and roles according to SQL-standardnofine grained access rights according to SQL-standardFine-grained Attribute-Based Access Control (ABAC) in addition to typical coarse-grained Role-Based Access Control (RBAC) according to SQL-standard. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos)
More information provided by the system vendor
EXASOLManticore SearchOpenSearchPostgres-XLVirtuoso
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Virtuoso is a modern multi-model RDBMS for managing data represented as tabular relations...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Performance & Scale — as exemplified by DBpedia and the LOD Cloud it spawned, i.e.,...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Used for — Analytics/BI Conceptual Data Virtualization Enterprise Knowledge Graphs...
» more
Key customersBroad use across enterprises and governments including — European Union (EU) US Government...
» more
Market metricsLargest installed-base ​of Multi-Model RDBMS for AI-friendly Knowledge Graphs Platform...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» more
Available in both Commercial Enterprise and Open Source (GPL v2) Editions Feature...
» 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

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

More resources
EXASOLManticore SearchOpenSearchPostgres-XLVirtuoso
Recent citations in the news

Mathias Golombek, Chief Technology Officer of Exasol – Interview Series
21 May 2024, Unite.AI

Exasol Finds AI Underinvestment Leads to Business Failure, But Data Challenges Stall Rapid Adoption
14 May 2024, insideBIGDATA

It's Back to the Database Future for Exasol CEO Tewes
26 October 2023, Datanami

Exasol gets jolt of AI with Espresso suite of capabilities
26 February 2024, TechTarget

Exasol Unveils New Suite of AI Tools to Turbocharge Enterprise Data Analytics
21 February 2024, Business Wire

provided by Google 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

8 Powerful Alternatives to Elasticsearch
25 April 2024, Insider Monkey

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

provided by Google News

Amazon OpenSearch Service now supports OpenSearch version 2.13
21 May 2024, AWS Blog

Amazon OpenSearch Service zero-ETL integration with Amazon S3 now available
22 May 2024, AWS Blog

Amazon OpenSearch Service releases cross cluster alerting monitors
21 May 2024, AWS Blog

Introducing blueprint discovery and other UI enhancements for Amazon OpenSearch Ingestion | Amazon Web Services
22 May 2024, AWS Blog

AWS announces Amazon DocumentDB zero-ETL integration with Amazon OpenSearch Service
16 May 2024, AWS Blog

provided by Google News



Share this page

Featured Products

Neo4j logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

AllegroGraph logo

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

Present your product here