DBMS > Manticore Search vs. SAP Advantage Database Server vs. Sequoiadb vs. YTsaurus

System Properties Comparison Manticore Search vs. SAP Advantage Database Server vs. Sequoiadb vs. YTsaurus

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Manticore Search  Xexclude from comparison	SAP Advantage Database Server former name: Sybase ADS  Xexclude from comparison	Sequoiadb  Xexclude from comparison	YTsaurus  Xexclude from comparison
		SAP Advantage Database Server seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
Description	Multi-storage database for search, including full-text search.	Low-cost RDBMS with access to ISAM and FoxPro data structures	NewSQL database with distributed OLTP and SQL	YTsaurus is an open source platform for distributed storage and processing.
Primary database model	Search engine	Relational DBMS	Document store Relational DBMS	Document store Key-value store
Secondary database models	Time Series DBMS using the Manticore Columnar Library
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.29 Rank #302   Overall #21   Search engines		Score 0.50 Rank #258   Overall #41   Document stores #120   Relational DBMS	Score 0.21 Rank #324   Overall #45   Document stores #48   Key-value stores
Website	manticoresearch.com	www.sap.com/products/advantage-database-server.html	www.sequoiadb.com	ytsaurus.tech
Technical documentation	manual.manticoresearch.com		www.sequoiadb.com/­en/­index.php?m=Files&a=index	ytsaurus.tech/­docs/­en
Developer	Manticore Software	Sybase, SAP	Sequoiadb Ltd.	Yandex
Initial release	2017	1993	2013	2023
Current release	6.0, February 2023
License Commercial or Open Source	Open Source GPL version 2	commercial	Open Source Server: AGPL; Client: Apache V2	Open Source Apache License, Version 2.0
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	C++		C++	C++
Server operating systems	FreeBSD Linux macOS Windows	Linux Windows	Linux	Ubuntu
Data scheme	Fixed schema	yes	schema-free
Typing predefined data types such as float or date	Int, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Boolean	yes	yes oid, date, timestamp, binary, regex	yes
XML support Some 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 XML	no	no	no
Secondary indexes	yes full-text index on all search fields	yes	yes
SQL Support of SQL	SQL-like query language	yes	SQL-like query language	YQL, an SQL-based language, is supported
APIs and other access methods	Binary API RESTful HTTP/JSON API RESTful HTTP/SQL API SQL over MySQL	.NET Client API ADO.NET JDBC ODBC OLE DB	proprietary protocol using JSON
Supported programming languages	Elixir Go Java JavaScript (Node.js) Perl PHP Python	Delphi Perl PHP	.Net C++ Java PHP Python	C++ Go Java JavaScript Python
Server-side scripts Stored procedures	user defined functions	yes	JavaScript
Triggers	no	yes	no
Partitioning methods Methods for storing different data on different nodes	Sharding Partitioning is done manually, search queries against distributed index is supported	none	Sharding	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	Synchronous replication based on Galera library	Multi-source replication CONFLICT Trigger to resolve replication conflicts Source-replica replication	Source-replica replication	yes
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	no	yes
Consistency concepts Methods to ensure consistency in a distributed system		Immediate Consistency	Eventual Consistency
Foreign keys Referential integrity	no	yes	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	yes isolated transactions for atomic changes and binary logging for safe writes	ACID	Document is locked during a transaction	ACID
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes
Durability Support for making data persistent	yes The original contents of fields are not stored in the Manticore index.	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.		no caching of (temporary) tables can be configured	no
User concepts Access control	no	fine grained access rights according to SQL-standard	simple password-based access control	Access Control Lists
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 Search	SAP Advantage Database Server former name: Sybase ADS	Sequoiadb	YTsaurus
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 Announces Q3 2023 Results: Asia Pacific and Japan View 19 October 2023, SAP News provided by Google News

Share this page