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 > Manticore Search vs. SAP SQL Anywhere vs. TerminusDB vs. Transwarp KunDB vs. XTDB

System Properties Comparison Manticore Search vs. SAP SQL Anywhere vs. TerminusDB vs. Transwarp KunDB vs. XTDB

Editorial information provided by DB-Engines
NameManticore Search  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonTerminusDB infoformer name was DataChemist  Xexclude from comparisonTranswarp KunDB  Xexclude from comparisonXTDB infoformerly named Crux  Xexclude from comparison
DescriptionMulti-storage database for search, including full-text search.RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationshipsOLTP DBMS based on a distributed architecture and highly compatible with MySQL and OracleA general purpose database with bitemporal SQL and Datalog and graph queries
Primary database modelSearch engineRelational DBMSGraph DBMSRelational DBMSDocument store
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryDocument store
RDF store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.29
Rank#302  Overall
#21  Search engines
Score3.95
Rank#80  Overall
#42  Relational DBMS
Score0.23
Rank#316  Overall
#27  Graph DBMS
Score0.14
Rank#341  Overall
#149  Relational DBMS
Score0.18
Rank#332  Overall
#46  Document stores
Websitemanticoresearch.comwww.sap.com/­products/­technology-platform/­sql-anywhere.htmlterminusdb.comwww.transwarp.cn/­en/­product/­kundbgithub.com/­xtdb/­xtdb
www.xtdb.com
Technical documentationmanual.manticoresearch.comhelp.sap.com/­docs/­SAP_SQL_Anywhereterminusdb.github.io/­terminusdb/­#www.xtdb.com/­docs
DeveloperManticore SoftwareSAP infoformerly SybaseDataChemist Ltd.TranswarpJuxt Ltd.
Initial release2017199220182019
Current release6.0, February 202317, July 201511.0.0, January 20231.19, September 2021
License infoCommercial or Open SourceOpen Source infoGPL version 2commercialOpen Source infoGPL V3commercialOpen Source infoMIT License
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.
Implementation languageC++Prolog, RustClojure
Server operating systemsFreeBSD
Linux
macOS
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
LinuxAll OS with a Java 8 (and higher) VM
Linux
Data schemeFixed schemayesyesyesschema-free
Typing infopredefined data types such as float or dateInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyesyesyesyes, extensible-data-notation format
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 XMLyesnono
Secondary indexesyes infofull-text index on all search fieldsyesyesyes
SQL infoSupport of SQLSQL-like query languageyesSQL-like query language (WOQL)yeslimited SQL, making use of Apache Calcite
APIs and other access methodsBinary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
ADO.NET
HTTP API
JDBC
ODBC
OWL
RESTful HTTP API
WOQL (Web Object Query Language)
HTTP REST
JDBC
Supported programming languagesElixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
JavaScript
Python
Clojure
Java
Server-side scripts infoStored proceduresuser defined functionsyes, in C/C++, Java, .Net or Perlyesyesno
Triggersnoyesyesyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoPartitioning is done manually, search queries against distributed index is supportednoneGraph Partitioninghorizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesSynchronous replication based on Galera librarySource-replica replication infoDatabase mirroringJournaling Streamsyes, each node contains all data
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoisolated transactions for atomic changes and binary logging for safe writesACIDACIDACIDACID
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.yesyes infoin-memory journalingyesyes, flexibel persistency by using storage technologies like Apache Kafka, RocksDB or LMDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlnofine grained access rights according to SQL-standardRole-based access controlyes

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

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

More resources
Manticore SearchSAP SQL Anywhere infoformerly called Adaptive Server AnywhereTerminusDB infoformer name was DataChemistTranswarp KunDBXTDB infoformerly named Crux
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

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules | Amazon Web Services
17 July 2023, AWS Blog

Rimini Street expands support beyond SAP and Oracle
21 May 2016, InsideSAP

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

provided by Google News

How TerminusDB is commercializing its open source graph database
16 March 2021, VentureBeat

TerminusDB Takes on Data Collaboration with a git-Like Approach
1 December 2020, The New Stack

Trinity College spinout TerminusDB secures €3.6m in investment
15 March 2021, The Irish Times

[MCR2030-CAMS-ARISE-UNDRR Webinar] Preventing cascading failures of critical assets: Using the Open-Source ...
12 April 2022, United Nations Office for Disaster Risk Reduction

Irish start-ups received €28m from Enterprise Ireland in 2021
7 April 2022, SiliconRepublic.com

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.

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

Present your product here