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 > ArangoDB vs. Hive vs. OpenQM vs. Vertica

System Properties Comparison ArangoDB vs. Hive vs. OpenQM vs. Vertica

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameArangoDB  Xexclude from comparisonHive  Xexclude from comparisonOpenQM infoalso called QM  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparison
DescriptionNative multi-model DBMS for graph, document, key/value and search. All in one engine and accessible with one query language.data warehouse software for querying and managing large distributed datasets, built on HadoopQpenQM is a high-performance, self-tuning, multi-value DBMSCloud or on-premises analytical database and query engine for structured and semi-structured streaming and batch data. Machine learning platform with built-in algorithms, data preparation capabilities, and model evaluation and management via SQL or Python.
Primary database modelDocument store
Graph DBMS
Key-value store
Search engine
Relational DBMSMultivalue DBMSRelational DBMS infoColumn oriented
Secondary database modelsSpatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.92
Rank#73  Overall
#14  Document stores
#4  Graph DBMS
#11  Key-value stores
#10  Search engines
Score78.66
Rank#17  Overall
#11  Relational DBMS
Score0.19
Rank#290  Overall
#10  Multivalue DBMS
Score20.13
Rank#37  Overall
#23  Relational DBMS
Websitewww.arangodb.comhive.apache.orgwww.openqm.comwww.vertica.com
Technical documentationwww.arangodb.com/­docs/­stablecwiki.apache.org/­confluence/­display/­Hive/­Homewww.openqm.com/­support/­documentationvertica.com/­documentation
Social network pagesTwitterLinkedInFacebookYouTubeInstagram
DeveloperArangoDB Inc.Apache Software Foundation infoinitially developed by FacebookMartin PhillipsMicro Focus infoprior to that Hewlett Packard
Initial release2012201219932005
Current release3.9.2, June 20223.1.2, August 20193.4-1211.1, February 2022
License infoCommercial or Open SourceOpen Source infoApache Version 2; Commercial license (Enterprise) availableOpen Source infoApache Version 2Open Source infoGPLv2, extended commercial license availablecommercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenononono infoon-premises, all major clouds - Amazon AWS, Microsoft Azure, Google Cloud Platform and containers
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ArangoDB Oasis –The Managed Cloud Service of ArangoDB. Oasis provides fully managed, and monitored cluster deployments of any size, with enterprise-grade security. Get started for free and continue for as little as $0,21/hour.Vertica Accelerator’s high-performance analytics and machine learning with SQL or Python is available as a managed service.
Implementation languageC++JavaC++
Server operating systemsLinux
OS X
Windows
All OS with a Java VMAIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows
Linux
Data schemeschema-free infoautomatically recognizes schema within a collectionyesyes infowith some exceptionsyes, but unstructured data can be stored in specific Flex-Tables
Typing infopredefined data types such as float or dateyes infostring, double, boolean, list, hashyesyes: BINARY, BOOLEAN, CHAR, VARCHAR, LONG VARCHAR, DATE, TIME, TIMESTAMP, INTERVAL, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, DOUBLE PRECISION, FLOAT, INTEGER, BIGINT, SMALLINT,NUMERIC, DECIMAL, NUMBER, MONEY,GEOMETRY
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.yesno
Secondary indexesyesyesyesNo Indexes Required
SQL infoSupport of SQLnoSQL-like DML and DDL statementsnoFull 1999 standard plus machine learning, time series and geospatial. Over 650 functions.
APIs and other access methodsAQL
Foxx Framework
Graph API (Gremlin)
GraphQL query language
HTTP API
Java & SpringData
JSON style queries
VelocyPack/VelocyStream
JDBC
ODBC
Thrift
ADO.NET
JDBC
Kafka Connector
ODBC
RESTful HTTP API
Spark Connector
vSQL infocharacter-based, interactive, front-end utility
Supported programming languagesC#
C++
Clojure
Elixir
Go
Java
JavaScript (Node.js)
PHP
Python
R
Rust
C++
Java
PHP
Python
.Net
Basic
C
Java
Objective C
PHP
Python
C#
C++
Java
Perl
PHP
Python
R
Server-side scripts infoStored proceduresJavaScriptyes infouser defined functions and integration of map-reduceyesyes, PostgreSQL PL/pgSQL, with minor differences
Triggersnonoyesyes, called Custom Alerts
Partitioning methods infoMethods for storing different data on different nodesSharding infosince version 2.0Shardingyeshorizontal partitioning, hierarchical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication with configurable replication factorselectable replication factoryesMulti-source replication infoOne, or more copies of data replicated across nodes, or object-store used for repository.
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infocan be done with stored procedures in JavaScriptyes infoquery execution via MapReducenono infoBi-directional Spark integration
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infoconfigurable per collection or per write
Immediate Consistency
OneShard (highly available, fault-tolerant deployment mode with ACID semantics)
Eventual ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes inforelationships in graphsnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlyesAccess rights for users, groups and rolesAccess rights can be defined down to the item levelfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
ArangoDBHiveOpenQM infoalso called QMVertica infoVertica Analytics Platform
Specific characteristicsGraph and Beyond. With more than 11,000 stargazers on GitHub, ArangoDB is the leading...
» more
Deploy-anywhere database for large-scale analytical deployments. Deploy on-premises,...
» more
Competitive advantagesConsolidation: As a native multi-model database, can be used as a full blown document...
» more
Fast, scalable and capable of high concurrency. Separation of compute/storage leverages...
» more
Typical application scenariosNative multi-model in ArangoDB is being used for a broad range of projects across...
» more
Communication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersCisco, Barclays, Refinitive, Siemens Mentor, Kabbage, Liaison, Douglas, MakeMyTrip,...
» more
Abiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Market metricsArangoDB is the leading native multi-model database with over 11,000 stargazers on...
» more
Licensing and pricing modelsVery permissive Apache 2 License for Community Edition & commercial licenses are...
» more
Cost-based models and subscription-based models are both available. One license is...
» more
News

Introducing the ArangoDB-PyG Adapter
4 August 2022

July 2022: What’s the Latest with ArangoDB?
21 July 2022

What is a Graph Database?
7 July 2022

May 2022: What’s the Latest with ArangoDB?
27 May 2022

April 2022: What’s the Latest with ArangoDB?
29 April 2022

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 partiesSQLFlow: 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

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

More resources
ArangoDBHiveOpenQM infoalso called QMVertica infoVertica Analytics Platform
DB-Engines blog posts

The Weight of Relational Databases: Time for Multi-Model?
29 August 2017, Luca Olivari (guest author)

show all

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Open source graph database company ArangoDB raises $27.8M
6 October 2021, VentureBeat

ArangoDB 3.9 scales graph database operations
16 February 2022, TechTarget

ArangoDB brings yet more money into graph database market with $27.8M round
6 October 2021, SiliconANGLE News

ArangoDB Further Powers Graph at Scale with Release of ArangoDB 3.9
15 February 2022, PR Web

Graph, machine learning, hype, and beyond: ArangoDB open source multi-model database releases version 3.7
27 August 2020, ZDNet

provided by Google News

Top 10 Hadoop Analytics Tools Used in Big Data Projects in 2022
31 July 2022, Analytics Insight

Top 10 Big Data Architect Jobs to Apply for in August 2022
2 August 2022, Analytics Insight

How companies can support employees amidst political unrest
8 August 2022, Open Access Government

Compare Hadoop vs. Spark vs. Kafka for your big data strategy
15 November 2021, TechTarget

WANdisco introduces Hive metadata migration to Databricks
24 May 2021, TechTarget

provided by Google News

OpenQM
22 December 2019, International Spectrum Magazine

provided by Google News

Vertica Announces Vertica 12 for Future-Proof Analytics
7 June 2022, PR Newswire

Cloudian Partners with Vertica to Deliver On-Premises Data Warehouse Platform on S3 Data Lake
28 June 2022, GlobeNewswire

Cloudian Partners with Vertica to Deliver On-prem Data Warehouse Platform on S3 Data Lake
28 June 2022, Datanami

Data Analytics Firm Zetaris Turns to Channel to Drive U.S. Expansion
29 July 2022, Channel Futures

VAST Data teams up with Vertica to enable real-time queries at scale
19 April 2022, VentureBeat

provided by Google News

Job opportunities

Scalable Data Engineer -Mid Level
Oak Ridge National Laboratory, Oak Ridge, TN

Senior Scalable Data Engineer
Oak Ridge National Laboratory, Oak Ridge, TN

Scalable Data Engineer - Associate Level
Oak Ridge National Laboratory, Oak Ridge, TN

Data Architect
Thomson Reuters, Carrollton, TX

Sr. Java Developer
Mastech InfoTrellis, United States

Sr. Data Engineers
GSPANN Technologie, Portland, OR

Software Engineer Specialist - Modernization
Global Payments, Alpharetta, GA

Bigdata with Pyspark
Virtusa, Irving, TX

Data Engineer
Amazon.com Services LLC, Remote

BI Data Engineer-Work from home-eviCore
Cigna, Hartford, CT

Technical Support Engineer
Rocket Software, United States

ETL Developer (Healthcare) - 100% Remote
Piper Companies, Remote

Database Administrator
Maxpro, Albany, NY

Systems Software Engineer at Vertica (REMOTE / WORK FROM HOME)
Micro Focus, Cambridge, MA

Database Engineer
Millennium Management LLC, Miami, FL

Database Administrator
Castalia Systems, LLC, Oakton, VA

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

The right graph database.
Not a graph add-on.
Free forever.
Start solving today

Present your product here