DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hive vs. Milvus vs. PouchDB vs. Teradata Aster vs. Virtuoso

System Properties Comparison Hive vs. Milvus vs. PouchDB vs. Teradata Aster vs. Virtuoso

Editorial information provided by DB-Engines
NameHive  Xexclude from comparisonMilvus  Xexclude from comparisonPouchDB  Xexclude from comparisonTeradata Aster  Xexclude from comparisonVirtuoso  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
Descriptiondata warehouse software for querying and managing large distributed datasets, built on HadoopA DBMS designed for efficient storage of vector data and vector similarity searchesJavaScript DBMS with an API inspired by CouchDBPlatform for big data analytics on multistructured data sources and typesVirtuoso is a multi-model hybrid-RDBMS that supports management of data represented as relational tables and/or property graphs
Primary database modelRelational DBMSVector DBMSDocument storeRelational DBMSDocument store
Graph DBMS
Native XML DBMS
Relational DBMS
RDF store
Search engine
Secondary database modelsSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score59.76
Rank#18  Overall
#12  Relational DBMS
Score2.78
Rank#103  Overall
#4  Vector DBMS
Score2.34
Rank#112  Overall
#21  Document stores
Score4.27
Rank#73  Overall
#13  Document stores
#4  Graph DBMS
#2  Native XML DBMS
#39  Relational DBMS
#2  RDF stores
#9  Search engines
Websitehive.apache.orgmilvus.iopouchdb.comvirtuoso.openlinksw.com
Technical documentationcwiki.apache.org/­confluence/­display/­Hive/­Homemilvus.io/­docs/­overview.mdpouchdb.com/­guidesdocs.openlinksw.com/­virtuoso
DeveloperApache Software Foundation infoinitially developed by FacebookApache Software FoundationTeradataOpenLink Software
Initial release20122019201220051998
Current release3.1.3, April 20222.4.4, May 20247.1.1, June 20197.2.11, September 2023
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoApache Version 2.0Open SourcecommercialOpen Source infoGPLv2, extended commercial license available
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.
Zilliz Cloud – Cloud-native service for Milvus
Implementation languageJavaC++, GoJavaScriptC
Server operating systemsAll OS with a Java VMLinux
macOS info10.14 or later
Windows infowith WSL 2 enabled
server-less, requires a JavaScript environment (browser, Node.js)LinuxAIX
FreeBSD
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesschema-freeFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Storeyes infoSQL - Standard relational schema
RDF - Quad (S, P, O, G) or Triple (S, P, O)
XML - DTD, XML Schema
DAV - freeform filesystem objects, plus User Defined Types a/k/a Dynamic Extension Type
Typing infopredefined data types such as float or dateyesVector, Numeric and Stringnoyesyes
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.nonoyes infoin Aster File Storeyes
Secondary indexesyesnoyes infovia viewsyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsnonoyesyes infoSQL-92, SQL-200x, SQL-3, SQLX
APIs and other access methodsJDBC
ODBC
Thrift
RESTful HTTP APIHTTP REST infoonly for PouchDB Server
JavaScript API
ADO.NET
JDBC
ODBC
OLE DB
ADO.NET
GeoSPARQL
HTTP API
JDBC
Jena RDF API
ODBC
OLE DB
RDF4J API
RESTful HTTP API
Sesame REST HTTP Protocol
SOAP webservices
SPARQL 1.1
WebDAV
XPath
XQuery
XSLT
Supported programming languagesC++
Java
PHP
Python
C++
Go
Java
JavaScript (Node.js)
Python
JavaScriptC
C#
C++
Java
Python
R
.Net
C
C#
C++
Java
JavaScript
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reducenoView functions in JavaScriptR packagesyes infoVirtuoso PL
Triggersnonoyesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infowith a proxy-based framework, named couchdb-loungeShardingyes
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replication infoalso with CouchDB databases
Source-replica replication infoalso with CouchDB databases
yes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.Chain, star, and bi-directional replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenoyesyes infoSQL Map-Reduce Frameworkyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyBounded Staleness
Eventual Consistency
Immediate Consistency
Session Consistency
Tunable Consistency
Eventual ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanononoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infoby using IndexedDB, WebSQL or LevelDB as backendyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnoyes
User concepts infoAccess controlAccess rights for users, groups and rolesRole based access control and fine grained access rightsnofine grained access rights according to SQL-standardFine-grained Attribute-Based Access Control (ABAC) in addition to typical coarse-grained Role-Based Access Control (RBAC) according to SQL-standard. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos)
More information provided by the system vendor
HiveMilvusPouchDBTeradata AsterVirtuoso
Specific characteristicsMilvus is an open-source and cloud-native vector database built for production-ready...
» more
Virtuoso is a modern multi-model RDBMS for managing data represented as tabular relations...
» more
Competitive advantagesHighly available, versatile, and robust with millisecond latency. Supports batch...
» more
Performance & Scale — as exemplified by DBpedia and the LOD Cloud it spawned, i.e.,...
» more
Typical application scenariosRAG: retrieval augmented generation Video media : video understanding, video deduplication....
» more
Used for — Analytics/BI Conceptual Data Virtualization Enterprise Knowledge Graphs...
» more
Key customersMilvus is trusted by thousands of enterprises, including PayPal, eBay, IKEA, LINE,...
» more
Broad use across enterprises and governments including — European Union (EU) US Government...
» more
Market metricsAs of January 2024, 25k+ GitHub stars 10M+ downloads and installations​ ​ 3k+ enterprise...
» more
Largest installed-base ​of Multi-Model RDBMS for AI-friendly Knowledge Graphs Platform...
» more
Licensing and pricing modelsMilvus was released under the open-source Apache License 2.0 in October 2019. Fully-managed...
» more
Available in both Commercial Enterprise and Open Source (GPL v2) Editions Feature...
» 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
HiveMilvusPouchDBTeradata AsterVirtuoso
DB-Engines blog posts

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

show all

Vector databases
2 June 2023, Matthias Gelbmann

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

Design a data mesh pattern for Amazon EMR-based data lakes using AWS Lake Formation with Hive metastore ...
10 June 2024, AWS Blog

Apache Software Foundation Announces Apache Hive 4.0
30 April 2024, Datanami

18 Top Big Data Tools and Technologies to Know About in 2024
24 January 2024, TechTarget

ASF Unveils the Next Evolution of Big Data Processing With the Launch of Hive 4.0
2 May 2024, Datanami

Run Apache Hive workloads using Spark SQL with Amazon EMR on EKS | Amazon Web Services
18 October 2023, AWS Blog

provided by Google News

How NVIDIA GPU Acceleration Supercharged Milvus Vector Database
26 March 2024, The New Stack

AI-Powered Search Engine With Milvus Vector Database on Vultr
31 January 2024, SitePoint

Milvus 2.4 Unveils Game-Changing Features for Enhanced Vector Search
20 March 2024, GlobeNewswire

Zilliz Unveils Game-Changing Features for Vector Search
22 March 2024, Datanami

IBM watsonx.data’s integrated vector database: unify, prepare, and deliver your data for AI
9 April 2024, IBM

provided by Google News

Building an Offline First App with PouchDB — SitePoint
10 March 2014, SitePoint

Getting Started with PouchDB Client-Side JavaScript Database — SitePoint
7 September 2016, SitePoint

3 Reasons To Think Offline First
22 March 2017, IBM

Create Offline Web Apps Using Service Workers & PouchDB — SitePoint
7 March 2017, SitePoint

Offline-first web and mobile apps: Top frameworks and components
22 January 2019, TechBeacon

provided by Google News

Teradata Enhances Big Data Analytics Platform
31 May 2024, Data Center Knowledge

Northwestern Analytics Partners with Teradata Aster to Host Hackathon
23 May 2014, Northwestern Engineering

Teradata Provides the Simplest Way to Bring the Science of Data to the Art of Business
22 September 2011, PR Newswire

Teradata's Aster shows how the flowers of fraud bloom
23 April 2015, The Register

Case study: Siemens reduces train failures with Teradata Aster
12 September 2016, RCR Wireless News

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.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

Present your product here