DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Drill vs. RDF4J vs. Snowflake vs. SwayDB vs. Virtuoso

System Properties Comparison Apache Drill vs. RDF4J vs. Snowflake vs. SwayDB vs. Virtuoso

Editorial information provided by DB-Engines
NameApache Drill  Xexclude from comparisonRDF4J infoformerly known as Sesame  Xexclude from comparisonSnowflake  Xexclude from comparisonSwayDB  Xexclude from comparisonVirtuoso  Xexclude from comparison
DescriptionSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageRDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.Cloud-based data warehousing service for structured and semi-structured dataAn embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storageVirtuoso is a multi-model hybrid-RDBMS that supports management of data represented as relational tables and/or property graphs
Primary database modelDocument store
Relational DBMS
RDF storeRelational DBMSKey-value storeDocument 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
Score2.89
Rank#106  Overall
#20  Document stores
#55  Relational DBMS
Score0.73
Rank#204  Overall
#9  RDF stores
Score93.51
Rank#14  Overall
#9  Relational DBMS
Score0.02
Rank#341  Overall
#52  Key-value stores
Score6.01
Rank#71  Overall
#11  Document stores
#3  Graph DBMS
#2  Native XML DBMS
#39  Relational DBMS
#2  RDF stores
#9  Search engines
Websitedrill.apache.orgrdf4j.orgwww.snowflake.comswaydb.iovirtuoso.openlinksw.com
Technical documentationdrill.apache.org/­docsrdf4j.org/­documentationdocs.snowflake.net/­manuals/­index.htmldocs.openlinksw.com/­virtuoso
DeveloperApache Software FoundationSince 2016 officially forked into an Eclipse project, former developer was Aduna Software.Snowflake Computing Inc.Simer PlahaOpenLink Software
Initial release20122004201420181998
Current release1.19.0, June 202108.03.3316, March 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoEclipse Distribution License (EDL), v1.0.commercialOpen Source infoGNU Affero GPL V3.0Open Source infoGPLv2, extended commercial license available
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScalaC
Server operating systemsLinux
OS X
Windows
Linux
OS X
Unix
Windows
hostedAIX
FreeBSD
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyes infoRDF Schemasyes infosupport of semi-structured data formats (JSON, XML, Avro)schema-freeyes 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 dateyesyesyesnoyes
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.noyesnoyes
Secondary indexesnoyesnoyes
SQL infoSupport of SQLSQL SELECT statement is SQL:2003 compliantnoyesnoyes infoSQL-92, SQL-200x, SQL-3, SQLX
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
Java API
RIO infoRDF Input/Output
Sail API
SeRQL infoSesame RDF Query Language
Sesame REST HTTP Protocol
SPARQL
CLI Client
JDBC
ODBC
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
JavaScript (Node.js)
Python
Java
Kotlin
Scala
.Net
C
C#
C++
Java
JavaScript
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresuser defined functionsyesuser defined functionsnoyes infoVirtuoso PL
Triggersnoyesno infosimilar concept for controling cloud resourcesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneyesnoneyes
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyesnoneChain, star, and bi-directional replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infoIsolation support depends on the API usedACIDAtomic execution of operationsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentDepending on the underlying data sourceyes infoin-memory storage is supported as wellyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Depending on the underlying data sourcenoyesyes
User concepts infoAccess controlDepending on the underlying data sourcenoUsers with fine-grained authorization concept, user roles and pluggable authenticationnoFine-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
Apache DrillRDF4J infoformerly known as SesameSnowflakeSwayDBVirtuoso
Specific characteristicsVirtuoso is a modern multi-model RDBMS for managing data represented as tabular relations...
» more
Competitive advantagesPerformance & Scale — as exemplified by DBpedia and the LOD Cloud it spawned, i.e.,...
» more
Typical application scenariosUsed for — Analytics/BI Conceptual Data Virtualization Enterprise Knowledge Graphs...
» more
Key customersBroad use across enterprises and governments including — European Union (EU) US Government...
» more
Market metricsLargest installed-base ​of Multi-Model RDBMS for AI-friendly Knowledge Graphs Platform...
» more
Licensing and pricing modelsAvailable 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
3rd partiesDBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» 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

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

More resources
Apache DrillRDF4J infoformerly known as SesameSnowflakeSwayDBVirtuoso
DB-Engines blog posts

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Apache Drill Adds New Data Formats
28 March 2022, iProgrammer

Apache Drill improves big data SQL query engine
31 August 2021, TechTarget

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

Amazon's PartiQL query language eyes all data sources
6 August 2019, TechTarget

What is Apache Hadoop? Understanding Hadoop Ecosystem & Architecture | ITBE
9 September 2021, IT Business Edge

provided by Google News

GraphDB 9.5 Offers Data Virtualization From Tables to Graphs and Back
9 December 2020, PR Newswire

provided by Google News

Stripe Joins the Snowflake Retail Data Cloud to Unlock the Value of Payment Data
18 May 2022, Business Wire

Should You Buy, Sell Or Hold Snowflake Stock At $140
24 May 2022, Forbes

Pure Storage, Snowflake partner for on-premises data warehousing
18 May 2022, Network World

Novartis and Snowflake: Driving healthcare data innovation
25 April 2022, VentureBeat

Dell partners with Snowflake to ease access to on-premises data
2 May 2022, SiliconANGLE News

provided by Google News

Job opportunities

Senior Software Engineer- Query Engines
Workday, Pleasanton, CA

Software Engineer (Back-end Development)
Concourse Labs, Austin, TX

Principal Software Engineer - Query Engines
Workday, United States

Sr Data Engineer – Marketing Data Analytics
Lowe's, Charlotte, NC

Sr Data Engineer – Pro Data Analytics
Lowe's, Charlotte, NC

Data Discovery Developer - Scientific Computing & Data
Mount Sinai, New York, NY

Database Administrator
C2S Techs, Bellevue, WA

Senior Oracle/SQL Server Database Administrator - REMOTE OPPORTUNITY
Superior Court of Orange County, Orange County, CA

Snowflake Developer
Xtivia Inc, Remote

SQL Data Analyst I
Windstream Communications, Remote

Snowflake DBA
Delta Dental Ins., Remote

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

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

AllegroGraph logo

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

Present your product here