DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > EDB Postgres vs. InfluxDB vs. Trafodion

System Properties Comparison EDB Postgres vs. InfluxDB vs. Trafodion

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEDB Postgres  Xexclude from comparisonInfluxDB  Xexclude from comparisonTrafodion  Xexclude from comparison
Apache Trafodion has been retired in 2021. Therefore it is excluded from the DB-Engines Ranking.
DescriptionThe EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL with flexible deployment options and Oracle compatibility features, complemented by tool kits for management, integration, and migration.DBMS for storing time series, events and metricsTransactional SQL-on-Hadoop DBMS
Primary database modelRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Spatial DBMS infowith GEO package
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.71
Rank#135  Overall
#61  Relational DBMS
Score21.47
Rank#28  Overall
#1  Time Series DBMS
Websitewww.enterprisedb.comwww.influxdata.com/­products/­influxdb-overviewtrafodion.apache.org
Technical documentationwww.enterprisedb.com/­docsdocs.influxdata.com/­influxdbtrafodion.apache.org/­documentation.html
DeveloperEnterpriseDBApache Software Foundation, originally developed by HP
Initial release200520132014
Current release14, December 20212.7.6, April 20242.3.0, February 2019
License infoCommercial or Open Sourcecommercial infoBSD for PostgreSQL-componentsOpen Source infoMIT-License; commercial enterprise version availableOpen 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 languageCGoC++, Java
Server operating systemsLinux
Windows
Linux
OS X infothrough Homebrew
Linux
Data schemeyesschema-freeyes
Typing infopredefined data types such as float or dateyesNumeric data and Stringsyes
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.yes infospecific XML-type available, but no XML query functionality.nono
Secondary indexesyesnoyes
SQL infoSupport of SQLyes infostandard with numerous extensionsSQL-like query languageyes
APIs and other access methodsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
HTTP API
JSON over UDP
ADO.NET
JDBC
ODBC
Supported programming languages.Net
C
C++
Delphi
Java
Perl
PHP
Python
Tcl
.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
All languages supporting JDBC/ODBC/ADO.Net
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.noJava Stored Procedures
Triggersyesnono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoby hash, list or rangeSharding infoin enterprise version onlySharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationselectable replication factor infoin enterprise version onlyyes, via HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infovia user defined functions and HBase
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyes
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.noyes infoDepending on used storage engineno
User concepts infoAccess controlfine grained access rights according to SQL-standardsimple rights management via user accountsfine grained access rights according to SQL-standard
More information provided by the system vendor
EDB PostgresInfluxDBTrafodion
Specific characteristicsInfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantagesTime to Value InfluxDB is available in all the popular languages and frameworks,...
» more
Typical application scenariosIoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...
» more
Key customersInfluxData has more than 1,900 paying customers, including customers include MuleSoft,...
» more
Market metricsFastest-growing database to drive 27,500 GitHub stars Over 750,000 daily active instances
» more
Licensing and pricing modelsOpen source core with closed source clustering available either on-premise or on...
» more
News

LLM Monitoring and Observability
4 November 2024

System Tables Part 2: How We Made It Faster
31 October 2024

System Tables Part 1: Introduction and Best Practices
29 October 2024

MaaS: How to Store and Analyze Real-Time Stock Trading Data Using Next.js and InfluxDB
25 October 2024

MaaS: How to Monitor Node.js App Performance with PM2 & InfluxDB
23 October 2024

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
EDB PostgresInfluxDBTrafodion
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

Recent citations in the news

EDB unveils EDB Postgres AI
23 May 2024, InfoWorld

EDB Announces Commitment to Achieving FedRAMP Authorization
31 October 2024, GlobeNewswire

EDB’s Next Move: From a Postgres Database Company to a Postgres Data & AI Platform Company
20 June 2024, TechCrunch

Enterprise DB begins rolling AI features into PostgreSQL
23 May 2024, SiliconANGLE News

Nutanix partners with EDB to fit database service for AI
21 May 2024, Blocks & Files

provided by Google News

Simplify Industrial IoT: Use InfluxDB edge replication for centralized time series analytics with Amazon Timestream
3 September 2024, AWS Blog

InfluxData avoids ’AI magic beans’ in InfluxDB time series database update for enterprises
4 September 2024, VentureBeat

InfluxData makes performance, storage improvements to InfluxDB 3.0
4 September 2024, InfoWorld

InfluxData Enhances InfluxDB 3.0 with Performance Upgrades and Self-Managed Option
5 September 2024, Datanami

InfluxData's Latest Updates Optimize Time Series Data for Better Performance, Scale and Management
19 September 2024, Integration Developers

provided by Google News

Apache Software Foundation Releases its 2019 Fiscal Year Report
17 August 2019, Open Source For You

Low-latency, distributed database architectures are critical for emerging fog applications
7 April 2022, Embedded Computing Design

provided by Google News



Share this page

Featured Products

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

SingleStore logo

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

Present your product here