DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache IoTDB vs. EsgynDB vs. Spark SQL

System Properties Comparison Apache IoTDB vs. EsgynDB vs. Spark SQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache IoTDB  Xexclude from comparisonEsgynDB  Xexclude from comparisonSpark SQL  Xexclude from comparison
DescriptionA lightweight IoT native database management system deployable on the device and syncing the collected data with the cloud and integrated with Hadoop and SparkEnterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionSpark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelTime Series DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.16
Rank#298  Overall
#24  Time Series DBMS
Score0.26
Rank#274  Overall
#127  Relational DBMS
Score20.84
Rank#34  Overall
#20  Relational DBMS
Websiteiotdb.apache.orgwww.esgyn.cnspark.apache.org/­sql
Technical documentationspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperApache Software FoundationEsgynApache Software Foundation
Initial release201820152014
Current release3.1.1, March 2021
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++, JavaScala
Server operating systemsAll OS with a Java VM (>= 1.8)LinuxLinux
OS X
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.nonono
Secondary indexesyesyesno
SQL infoSupport of SQLSQL-like query languageyesSQL-like DML and DDL statements
APIs and other access methodsJDBCADO.NET
JDBC
ODBC
JDBC
ODBC
Supported programming languagesAll languages supporting JDBC/ODBC/ADO.NetJava
Python
R
Scala
Server-side scripts infoStored proceduresnoJava Stored Proceduresno
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication between multi datacentersnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsIntegration with Hadoop and Sparkyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency with synchronizing with the cloudImmediate Consistency
Foreign keys infoReferential integritynoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlnofine grained access rights according to SQL-standardno

More information provided by the system vendor

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
Apache IoTDBEsgynDBSpark SQL
Recent citations in the news

The Apache® Software Foundation Welcomes its Global Community Online at ApacheCon(TM) Asia 2021
9 June 2021, StreetInsider.com

The Apache Software Foundation Announces Apache® IoTDB™ as
23 September 2020, GlobeNewswire

Apache IoTDB now a Top-Level Project at ASF
23 September 2020, SDTimes.com

Apache Promotes IoT Database Project
25 September 2020, Datanami

SD Times news digest: OpenSSF lays out new technical vision, Anchore and GitLab on DevSecOps, and ActiveState's new funding for security-first development
1 February 2021, SDTimes.com

provided by Google News

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

provided by Google News

Evolution of Azure Synapse: Apache Spark 3.0, GPU Acceleration, Delta Lake, Dataverse Support
29 May 2021, InfoQ.com

Accelerating Deep Learning on the JVM with Apache Spark and NVIDIA GPUs
16 June 2021, Illinoisnewstoday.com

Open Data Hub: A Meta Project for AI/ML Work
14 June 2021, Datanami

Spark 3.0 Brings Big SQL Speed-Up, Better Python Hooks
25 June 2020, Datanami

The CIO's Guide to Building a Rockstar Data Science and AI Team | eWEEK
15 June 2021, eWeek

provided by Google News

Job opportunities

Manager, Solution Architecture - Project Omnia
Deloitte, Phoenix, AZ

Data Science
Nauto, Palo Alto, CA

Data Engineer (AWS, Spark, SQL) (W2 only)
Syrinx, Remote

Hadoop Admin / Production support
Pernix, Plano, TX

Python Developer
Stefanini, Inc, Dearborn, MI

Talend Data Catalogue Developer:
iconvergence, Remote

jobs by Indeed




Share this page

Featured Products

AllegroGraph logo

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

Neo4j logo

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

Datastax Astra logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

Present your product here