DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache IoTDB vs. Heroic vs. Microsoft Azure Table Storage vs. OpenEdge

System Properties Comparison Apache IoTDB vs. Heroic vs. Microsoft Azure Table Storage vs. OpenEdge

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache IoTDB  Xexclude from comparisonHeroic  Xexclude from comparisonMicrosoft Azure Table Storage  Xexclude from comparisonOpenEdge  Xexclude from comparison
DescriptionAn IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and FlinkTime Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchA Wide Column Store for rapid development using massive semi-structured datasetsApplication development environment with integrated database management system
Primary database modelTime Series DBMSTime Series DBMSWide column storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.39
Rank#155  Overall
#14  Time Series DBMS
Score0.02
Rank#365  Overall
#37  Time Series DBMS
Score3.25
Rank#84  Overall
#7  Wide column stores
Score3.64
Rank#78  Overall
#42  Relational DBMS
Websiteiotdb.apache.orggithub.com/­spotify/­heroicazure.microsoft.com/­en-us/­services/­storage/­tableswww.progress.com/­openedge
Technical documentationiotdb.apache.org/­UserGuide/­Master/­QuickStart/­QuickStart.htmlspotify.github.io/­heroicdocumentation.progress.com/­output/­ua/­OpenEdge_latest
DeveloperApache Software FoundationSpotifyMicrosoftProgress Software Corporation
Initial release2018201420121984
Current release1.1.0, April 2023OpenEdge 12.2, March 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infoApache 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJava
Server operating systemsAll OS with a Java VM (>= 1.8)hostedAIX
HP-UX
Linux
Solaris
Windows
Data schemeyesschema-freeschema-freeyes
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.nononoyes
Secondary indexesyesyes infovia Elasticsearchnoyes
SQL infoSupport of SQLSQL-like query languagenonoyes infoclose to SQL 92
APIs and other access methodsJDBC
Native API
HQL (Heroic Query Language, a JSON-based language)
HTTP API
RESTful HTTP APIJDBC
ODBC
Supported programming languagesC
C#
C++
Go
Java
Python
Scala
.Net
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Progress proprietary ABL (Advanced Business Language)
Server-side scripts infoStored proceduresyesnonoyes
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by time range) + vertical partitioning (by deviceId)ShardingSharding infoImplicit feature of the cloud servicehorizontal partitioning infosince Version 11.4
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication methods; using Raft/IoTConsensus algorithm to ensure strong/eventual data consistency among multiple replicasyesyes infoimplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsIntegration with Hadoop and Sparknonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Strong Consistency with Raft
Eventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonooptimistic lockingACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnonono
User concepts infoAccess controlyesAccess rights based on private key authentication or shared access signaturesUsers and groups

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 IoTDBHeroicMicrosoft Azure Table StorageOpenEdge
Recent citations in the news

AMD Zen 5 Not Affected By Inception/SRSO, mitigations=off Yields No Benefit On Ryzen 9000 Series
6 September 2024, Phoronix

TsFile: A Standard Format for IoT Time Series Data
27 February 2024, The New Stack

Apache Software Foundation Initiatives to Fuel the Next 25 Years of Open Source Innovation
18 September 2024, GlobeNewswire

Intel Core Ultra 9 285K "Arrow Lake" Delivers Strong Linux Performance Review
24 October 2024, Phoronix

AMD Debuts EPYC 8004 Series CPUs For Power-Efficient Intelligent Edge Solutions
18 September 2023, Hot Hardware

provided by Google News

How Code Wizards load tested Heroic Labs’ Nakama to two million concurrent players with AWS
1 October 2024, AWS Blog

provided by Google News

How to use Azure Table storage in .Net
10 July 2024, InfoWorld

Working with Azure to Use and Manage Data Lakes
23 July 2024, Simplilearn

Azure Cosmos DB Data Migration tool imports from Azure Table storage
5 May 2015, azure.microsoft.com

How to write data to Azure Table Store with an Azure Function
14 April 2017, Experts Exchange

One way to migrate data from Azure Blob Storage to Amazon S3
16 July 2020, AWS Blog

provided by Google News

What's New in OpenEdge 12.8
15 April 2024, release.nl

4 sources of latency and how to avoid them
1 November 2017, InfoWorld

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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