DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > MemSQL vs. Vertica vs. VoltDB

System Properties Comparison MemSQL vs. Vertica vs. VoltDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMemSQL  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparisonVoltDB  Xexclude from comparison
DescriptionMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storageColumnar relational DBMS designed to handle modern analytic workloads, enabling fast query performanceDistributed In-Memory NewSQL RDBMS infoUsed for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory
Primary database modelRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.01
Rank#62  Overall
#35  Relational DBMS
Score21.77
Rank#31  Overall
#18  Relational DBMS
Score1.83
Rank#130  Overall
#64  Relational DBMS
Websitewww.memsql.comwww.vertica.comwww.voltdb.com
Technical documentationdocs.memsql.comwww.vertica.com/­docs/­10.0.x/­HTML/­Content/­Home.htmdocs.voltdb.com
DeveloperMemSQL Inc.Vertica / Micro Focus infoprior to that Hewlett PackardVoltDB Inc.
Initial release201320052010
Current release7.1.7, August 2020Vertica 10.0 Software, May 2020
Vertica for SQL on Hadoop 10.0 Software, May 2020
9.0, April 2019
License infoCommercial or Open Sourcecommercial infofree developer edition availablecommercial infoLimited community edition freeOpen Source infoAGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions
Cloud-based only infoOnly available as a cloud servicenono infoAvailable on all major clouds - Amazon AWS, Microsoft Azure and Google Cloud Platformno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
MemSQL Helios: The world's fastest, most capable cloud database for operational analytics, machine learning, & AI. Available instantly with multi-cloud and hybrid-cloud capabilities.
Implementation languageC++Java, C++
Server operating systemsLinux info64 bit version requiredLinuxLinux
OS X infofor development
Data schemeyesyes infoUnstructured data can be stored in specific Flex-Tablesyes
Typing infopredefined data types such as float or dateyesyesyes
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.noyes
Secondary indexesyesno infoThe concept of 'projections' can be used instead of indexes.yes
SQL infoSupport of SQLyes, but no triggers and foreign keysyes infonearly full SQL99 without support for indexes and triggersyes infoonly a subset of SQL 99
APIs and other access methodsJDBC
ODBC
ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP API
Java API
JDBC
RESTful HTTP/JSON API
Supported programming languagesBash
C
C#
Java
JavaScript (Node.js)
Python
C++
Java
Perl
Python
R
C#
C++
Erlang infonot officially supported
Go
Java
JavaScript infoNode.js
PHP
Python
Server-side scripts infoStored proceduresyesyesJava
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoSegmentation, Projection Segmentation, Hash SegmentationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replication infoCluster level and Object level replicationMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infowith Vertica Connector for Hadoopno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency only within each nodeImmediate Consistency
Foreign keys infoReferential integritynoyesno infoFOREIGN KEY constraints are not supported
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoOnly isolation level: READ COMMITEDACIDACID infoTransactions are executed single-threaded within stored procedures
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyesyes infoSnapshots and command logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hashUsers and roles with access to stored procedures
More information provided by the system vendor
MemSQLVertica infoVertica Analytics PlatformVoltDB
Specific characteristicsColumnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,...
» more
Competitive advantagesPerformance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in...
» more
Typical application scenariosCommunication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsCost-based models and subscription-based models are available
» 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

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

More resources
MemSQLVertica infoVertica Analytics PlatformVoltDB
DB-Engines blog posts

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

Recent citations in the news

MemSQL scalable SQL database now available on Red Hat Marketplace
10 September 2020, Help Net Security

Progress of MemSQL and Snowflake signals changing of the guard in database market
25 August 2020, SiliconANGLE

MemSQL Named 2020 SaaS Awards Winner
25 August 2020, Business Wire

Thentia launches MemSQL as the core operational database for its regulatory compliance process
27 August 2020, Help Net Security

MemSQL Continues International Momentum with Key Executive Hires
17 September 2020, AiThority

provided by Google News

Ahana Expands Seed Funding to $4.8 Million with Additional Funding Led by Lux Capital
21 September 2020, GlobeNewswire

Database Management Software: Market 2020 | Coronavirus Impact | Industry Business Outlook, Revenue, Trends and Forecasts 2026 | Actian Corporation, iWay Software, Embarcadero Technologies, MetaMatrix, HP (Vertica System), CA Technologies
21 September 2020, The Daily Chronicle

Alibaba adds leading analytics and banking software to its public cloud
17 September 2020, Which-50

Snowflake to Make it SNOW on NYSE
25 August 2020, Datanami

Complicated and competitive: How Vertica navigates today's intricate world of database management
21 April 2020, SiliconANGLE

provided by Google News

Impact Of Covid-19 On In-Memory Database Market 2020: Remarking Enormous Growth With Recent Trends | Microsoft, IBM, Oracle, SAP, Teradata, Amazon Web Services, Tableau Software, Kognitio, VoltDB, Datastax, Enea Ab, Mcobject, Altibase, Starcounter
21 September 2020, The Daily Chronicle

Global NEWSQL Database Market Expeted To Reach xx.xx mn USD With growth Rate of xx by 2025| Pandamic Impact Analysis: Microsoft Corporation, IBM, Oracle, SAP, Amazon, Pivotal, Altibase, MemSQL, TIBCO, VoltDB, Google, Cockroach Labs, MariaDB, ScaleArc (Ignite Technologies)
21 September 2020, Verdant News

Leveraging 5G latency reduction requires decentralized compute
4 September 2020, RCR Wireless News

VoltDB Secures $10 Million in Series C Funding to Meet Demand for 5G Data Requirements
23 October 2019, PRNewswire

RDBMS Software Market to Witness Huge Growth By 2025 | FrontBase, MonetDB, Microsoft
17 September 2020, The Daily Chronicle

provided by Google News

Job opportunities

Software Engineer, University Graduate
MemSQL, San Francisco, CA

8845-Eng 2, Software Dev & Engineering
Comcast, Mount Laurel, NJ

Programmer Analyst
Keyseries, North Haven, CT

Software Engineer, Intern (Summer 2021)
MemSQL, San Francisco, CA

Data Engineer - GSAM Data Distribution Group
Goldman Sachs, Salt Lake City, UT

Vertica Database Administrator
MassMutual, Boston, MA

Vertica Customer Solutions Manager
Micro Focus, Georgia

Data Analyst
Omni Federal, Fairfax, VA

DevOps Intern Summer 2021 - Vertica
Micro Focus, Cambridge, MA

Client Success Manager at Vertica
Micro Focus, Cambridge, MA

Software Engineer
Moebius Solutions, San Diego, CA

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here