EsgynDB

EsgynDB provides operational ease of running OLTP, ODS, BI and Analytical workloads on a single Big Data platform. EsgynDB is the only Big Data SQL solution that provides a pluggable data management framework, for disparate data sources, to handle mixed workloads (read while writing in real-time) minimizing data movement and duplication. EsgynDB reduces ETL costs by transforming data (ELT) within the database. It’s Massively Parallel Processing (MPP) architecture ensures that the strictest SLAs can be accomplished by executing queries in parallel. A mature ANSI SQL engine enables application portability over HDFS-based Data Lakes; proven to handle petabytes of data at high concurrency, and a shared nothing architecture allowing for transparent scalability with increasing cluster or data size.

History

EsgynDB has 20+ years of innovation and patented technology. HP invested more than $300 million into this technology just since 2006. The result is a database that has extensive capabilities and has been hardened across a wide variety of workloads, from OLTP, with its Tandem NonStop heritage.

Joins

Hash Join

Data Model

Object-Relational

EsgynDB is relational, supports ANSI SQL and ACID transactions. EsgynDB can query HBase structured tables and native HBase tables in the same query, but can also update them in the same ACID transaction. HBase tables can be defined as EsgynDB external tables. EsgynDB can access in the same query structured, semi-structured and unstructured data.

Foreign Keys

Supported

Isolation Levels

Read Committed

System Architecture

Shared-Nothing

Elastic scalability: nodes and storage across the cluster can be dynamically increased or decreased with no downtime, while transactions and queries are being processed. The very next transaction or query will leverage the reconfigured compute or storage resources.

Query Compilation

Code Generation

EsgynDB Logo
Website

https://esgyn.com/

Country of Origin

US

Start Year

2015

Project Type

Commercial

Derived From

Trafodion