DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Manticore Search vs. Microsoft SQL Server vs. RocksDB

System Properties Comparison Manticore Search vs. Microsoft SQL Server vs. RocksDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameManticore Search  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonRocksDB  Xexclude from comparison
DescriptionMulti-storage database for search, including full-text search.Microsofts flagship relational DBMSEmbeddable persistent key-value store optimized for fast storage (flash and RAM)
Primary database modelSearch engineRelational DBMSKey-value store
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.29
Rank#344  Overall
#21  Search engines
Score930.06
Rank#3  Overall
#3  Relational DBMS
Score4.27
Rank#92  Overall
#15  Key-value stores
Websitemanticoresearch.comwww.microsoft.com/­en-us/­sql-serverrocksdb.org
Technical documentationmanual.manticoresearch.comdocs.microsoft.com/­en-US/­sql/­sql-servergithub.com/­facebook/­rocksdb/­wiki
DeveloperManticore SoftwareMicrosoftFacebook, Inc.
Initial release201719892013
Current release6.0, February 2023SQL Server 2022, November 20227.10.2, March 2023
License infoCommercial or Open SourceOpen Source infoGPL version 2commercial inforestricted free version is availableOpen Source infoBSD
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++C++
Server operating systemsFreeBSD
Linux
macOS
Windows
Linux
Windows
Linux
Data schemeFixed schemayesschema-free
Typing infopredefined data types such as float or dateInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyesno
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 XMLyesno
Secondary indexesyes infofull-text index on all search fieldsyesno
SQL infoSupport of SQLSQL-like query languageyesno
APIs and other access methodsBinary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
C++ API
Java API
Supported programming languagesElixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C
C++
Go
Java
Perl
Python
Ruby
Server-side scripts infoStored proceduresuser defined functionsTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javano
Triggersnoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoPartitioning is done manually, search queries against distributed index is supportedtables can be distributed across several files (horizontal partitioning); sharding through federationhorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSynchronous replication based on Galera libraryyes, but depending on the SQL-Server Editionyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integritynoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoisolated transactions for atomic changes and binary logging for safe writesACIDyes
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoThe original contents of fields are not stored in the Manticore index.yesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlnofine grained access rights according to SQL-standardno

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
3rd partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more
Speedb: A high performance RocksDB-compliant key-value store optimized for write-intensive workloads.
» more

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

More resources
Manticore SearchMicrosoft SQL ServerRocksDB
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

How To Develop Your Custom Autocorrect Implementation with Manticore [A Step by Step Guide]
20 February 2020, hackernoon.com

Highlighting in Search Results
24 May 2020, hackernoon.com

Build A Web Crawler with Search bar Using Wget and Manticore [A Step By Step Guide]
18 April 2020, hackernoon.com

Manticore Search Reviews and Pricing 2023
26 May 2023, sourceforge.net

Manticore Search 6
7 February 2023, manticoresearch.com

provided by Google News

MOVEit Transfer Under Attack: Zero-Day Vulnerability Actively Being Exploited
2 June 2023, The Hacker News

How to Import Data From SQL Server to Excel Using Power Query Easily - MUO
26 May 2023, MakeUseOf

Severe Flaw in Google Cloud's Cloud SQL Service Exposed Confidential Data
26 May 2023, The Hacker News

How to Install SQL Server Management Studio on a Mac
28 October 2022, Built In

What you need to know about SQL Server 2022
29 July 2022, TechRepublic

provided by Google News

CockroachDB Launches Advanced Key-Value Store Pebble
23 December 2022, Analytics India Magazine

Blog
9 November 2022, rocksdb.org

RocksDB ERROR when BPF is on · Issue #7884 · osquery/osquery
14 December 2022, GitHub

zenoh-backend-rocksdb — db interface for Rust
23 December 2022, lib.rs

Background Compactions in YugabyteDB for File-Level Optimization
1 February 2023, The Distributed SQL Blog

provided by Google News

Job opportunities

Senior Data Engineer
dMetrics, Brooklyn, NY

SQL Server Database Admin
Mindcracker, Remote

Sybase/SQL Server Admin
Okaya Corp, Newark, NJ

SSIS/SQL Server Developer (Health Care) full time
PSRTEK, Remote

Sybase/SQL Server Administrator
Okaya Corp, Newark, NJ

SQL Server DBA
Radiant.digital, Remote

AWS Data Engineer
Anblicks, Dallas, TX

Search Engineer - Back End
Brave, San Francisco, CA

Software Engineer, Database - Distributed Storage & Transactions
YugabyteDB, Remote

Staff Software Engineer, Distributed Systems
Zilliz, San Francisco, CA

Engineering Manager - Big Peer
Ditto, Remote

jobs by Indeed



Share this page

Featured Products

Cassandra Forward online event

Want to level up your Cassandra game?
If you missed the event or would like to re-watch a session, replays are available now. Watch now!

AllegroGraph logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here