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

DBMS > EsgynDB vs. IBM Db2 vs. RDF4J vs. Vertica

System Properties Comparison EsgynDB vs. IBM Db2 vs. RDF4J vs. Vertica

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEsgynDB  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonRDF4J infoformerly known as Sesame  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparison
DescriptionEnterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionCommon in IBM host environments, 2 different versions for host and Windows/LinuxRDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.Columnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance
Primary database modelRelational DBMSRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBRDF storeRelational DBMS
Secondary database modelsDocument store
RDF store infoin DB2 LUW (Linux, Unix, Windows)
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.16
Rank#265  Overall
#125  Relational DBMS
Score168.70
Rank#6  Overall
#5  Relational DBMS
Score0.39
Rank#220  Overall
#10  RDF stores
Score22.65
Rank#29  Overall
#17  Relational DBMS
Websiteesgyn.comwww.ibm.com/­analytics/­db2rdf4j.orgwww.vertica.com
Technical documentationesgyn.com/­developerswww.ibm.com/­support/­knowledgecenter/­SSEPGGdocs.rdf4j.orgwww.vertica.com/­documentation/­vertica
DeveloperEsgynIBMSince 2016 officially forked into an Eclipse project, former developer was Aduna Software.Vertica / Micro Focus infoprior to that Hewlett Packard
Initial release20151983 infohost version20042005
Current release12.1, October 2016Vertica Analytics Platform 9.2.x, March 2019
License infoCommercial or Open Sourcecommercialcommercial infofree version is availableOpen Source infoEclipse Distribution License (EDL), v1.0.commercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenononono infoavailable on Amazon AWS and Microsoft Azure
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++, JavaC and C++Java
Server operating systemsLinuxAIX
HP-UX
Linux
Solaris
Windows
z/OS
Linux
OS X
Unix
Windows
Linux
Data schemeyesyesyes infoRDF Schemasyes infoUnstructured data can be stored in specific Flex-Tables
Typing infopredefined data types such as float or dateyesyesyesyes
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 indexesyesyesyesno infoThe concept of 'projections' can be used instead of indexes.
SQL infoSupport of SQLyesyesnoyes infonearly full SQL99 without support for indexes and triggers
APIs and other access methodsADO.NET
JDBC
ODBC
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
Java API
RIO infoRDF Input/Output
Sail API
SeRQL infoSesame RDF Query Language
Sesame REST HTTP Protocol
SPARQL
ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP API
Supported programming languagesAll languages supporting JDBC/ODBC/ADO.NetC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Java
PHP
Python
C++
Java
Perl
Python
R
Server-side scripts infoStored proceduresJava Stored Proceduresyesyesyes
Triggersnoyesyesno
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoonly with Windows/Unix/Linux VersionnoneSharding infoSegmentation, Projection Segmentation, Hash Segmentation
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-master replication between multi datacentersyes infowith separate tools (MQ, InfoSphere)noneMaster-master replication infoCluster level and Object level replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonoyes infowith Vertica Connector for Hadoop
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infoIsolation support depends on the API usedACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infoin-memory storage is supported as wellyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardnofine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
EsgynDBIBM Db2 infoformerly named DB2 or IBM Database 2RDF4J infoformerly known as SesameVertica infoVertica Analytics Platform
Specific characteristicsCapabilities for Operational/Transactional Workloads Deep Integration with HBase...
» more
Columnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,...
» more
Competitive advantagesEsgynDB is ideally suited to supporting Hybrid Transactional and Analytical Processing...
» more
Performance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in...
» more
Typical application scenariosIdeally suited to scenarios where high speed continuous data ingestion is required...
» more
Communication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersEsgynDB's customers are worldwide, with several in the Global Fortune 500, including...
» more
Abiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsEsgynDB Enterprise Edition is the commercially supported version of Apache Trafodion...
» more
Cost-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
3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
EsgynDBIBM Db2 infoformerly named DB2 or IBM Database 2RDF4J infoformerly known as SesameVertica infoVertica Analytics Platform
Recent citations in the news

Mphasis partners with Esgyn Corporation to provide specialized solutions to clients looking to harness big data
28 May 2019, Moneycontrol

Esgyn Strato: Esgyn announces a Hybrid / Multi Cloud Big Data Platform Service to run and optimize your b..
30 November 2018, Markets Insider

Mphasis partners with Esgyn Corporation to optimize Open-Source frameworks and expand industry footprint
24 May 2019, PRNewswire

The Apache Software Foundation Announces Apache® Trafodion™ as a Top-Level Project
10 January 2018, GlobeNewswire

provided by Google News

Where Does SAP On IBM i Go From Here?
15 January 2020, IT Jungle

Splice Machine Readies New Edition Of Its Distributed SQL Data Platform
28 January 2020, CRN: Technology news for channel partners and solution providers

Google offers IBM AS/400 apps new home in its cloud
20 January 2020, CIO

IBM Injects 'Data Science' AI Into Its Db2 Database
4 June 2019, Forbes

Infotel Corp. Announces Partner Agreement with Eccox, a Leading Software Vendor Focusing on Mainframe Cost Optimization for Fortune 500 and Government Entities
27 January 2020, PR Web

provided by Google News

GraphDB Goes Open Source
27 January 2020, iProgrammer

Big data database Apache Rya becomes a Top Level Project
10 October 2019, JAXenter

Amazon Neptune review: A scalable graph database for OLTP
13 May 2019, InfoWorld

Ontotext's GraphDB 8.10 Makes Knowledge Graph Experience Faster and Richer
13 June 2019, Yahoo Finance

Trend-Setting Product of 2019: Ontotext: Ontotext GraphDB
8 July 2019, KMWorld Magazine

provided by Google News

Best Practices for Data Management with DataOps
24 January 2020, TDWI

You Can't Do Machine Learning Inside a Database. Can You?
1 April 2019, Datanami

Micro Focus Announces Vertica in Eon Mode for Pure Storage
18 September 2019, DevOps.com

How ML Helps Solve the Big Data Transform/Mastering Problem
10 October 2019, Datanami

TablePlus prepares to launch database management app for Linux
26 November 2019, IT Brief Australia

provided by Google News

Job opportunities

Application Architect - Audit
Deloitte, Hermitage, TN

Application Architect - Audit
Deloitte, Nashville, TN

Solution Architect - Audit
Deloitte, Hermitage, TN

Solution Architect - Audit
Deloitte, Nashville, TN

DPS - IT - Database Administrator, DB2
TEXAS DEPARTMENT OF PUBLIC SAFETY, Austin, TX

DB2 LUW Database Administrator
Bank of America, Charlotte, NC

Database Administrator_Remote
Sawdey Solution Services, Inc., Remote

IMS Sr. Database Administrator Remote/Virtual
Unum, Remote

DATABASE ADMINISTRATOR III
TEXAS DEPARTMENT OF MOTOR VEHICLES, Austin, TX

Database Administrator
Domo, Inc., American Fork, UT

Database Administrator
MX, Lehi, UT

Database Administrator
Maxpro, Albany, NY

Database Developer
WebMD, New York, NY

Database Migration Consultant
Amazon Web Services, Inc., Denver, CO

jobs by Indeed




Share this page

Featured Products

Neo4j logo

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

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

AllegroGraph logo

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

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

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

Present your product here