DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > 4D vs. Firebird vs. QuestDB vs. Teradata Aster

System Properties Comparison 4D vs. Firebird vs. QuestDB vs. Teradata Aster

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name4D infoformer name: 4th Dimension  Xexclude from comparisonFirebird  Xexclude from comparisonQuestDB  Xexclude from comparisonTeradata Aster  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionApplication development environment with integrated database management systemFirebird is an open source RDBMS forked from Borland's InterBaseA high performance open source SQL database for time series dataPlatform for big data analytics on multistructured data sources and types
Primary database modelRelational DBMSRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.89
Rank#107  Overall
#56  Relational DBMS
Score25.72
Rank#32  Overall
#19  Relational DBMS
Score1.19
Rank#161  Overall
#12  Time Series DBMS
Websitewww.4d.comwww.firebirdsql.orgquestdb.io
Technical documentationlivedoc.4d.comwww.firebirdsql.org/­en/­reference-manualsquestdb.io/­docs/­introduction
Developer4D, IncFirebird FoundationQuestDB LimitedTeradata
Initial release19842000 infoAs fork of Borland's InterBase20142005
Current releasev18 R5, January 20214.0.1, December 2021
License infoCommercial or Open SourcecommercialOpen Source infoInitial Developer's Public LicenseOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++Java
Server operating systemsOS X
Windows
AIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
Linux
macOS
Windows
Linux
Data schemeyesyesyes infoschema-free via InfluxDB Line ProtocolFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Store
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.yesnoyes infoin Aster File Store
Secondary indexesyesyesnoyes
SQL infoSupport of SQLyes infoclose to SQL 92yesSQL-like query languageyes
APIs and other access methodsODBC
RESTful HTTP API infoby using 4D Mobile
SOAP webservices
ADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languages4D proprietary IDE
PHP
C
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
C infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
C
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresyesPSQLnoR packages
Triggersyesyesnono
Partitioning methods infoMethods for storing different data on different nodesnonenonehorizontal partitioning (by timestamps)Sharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationnone infoavailable via 3rd party productsConfigurable consistency for N replicasyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infoSQL Map-Reduce Framework
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID for single-table writesACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoFeatures a multi-generational MVCC architecture, readers do not block writersyesyes
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.noyes infothrough memory mapped filesno
User concepts infoAccess controlUsers and groupsUsers with fine-grained authorization conceptfine grained access rights according to SQL-standard
More information provided by the system vendor
4D infoformer name: 4th DimensionFirebirdQuestDBTeradata Aster
Specific characteristicsRelational model with native time series support Column based storage and time partitioned...
» more
Competitive advantagesReal-time data ingestion and istant SQL queries for time series High performance...
» more
Typical application scenariosApplication metrics Financial market data and algo trading DevOps monitoring Real-time...
» more
Licensing and pricing modelsApache 2.0.
» 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

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

More resources
4D infoformer name: 4th DimensionFirebirdQuestDBTeradata Aster
DB-Engines blog posts

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Embedded Database System Market including top key players Actian, IBM, Empress Software, Apache, H2 Database – ManufactureLink
26 May 2022, ManufactureLink

2023 CFB recruiting class: DB Joshua Fussell commits to Northwestern
20 May 2022, The Cincinnati Enquirer

Free Flight Bag Market Future Scope – Carbon Valley Farmer and Miner
26 May 2022, Carbon Valley Farmer and Miner

Condensing Oil Boiler Market Overview 2022-2029| Key Players – Viessmann Group, Vaillant, De Dietrich, Grant Engineering, ROTEX – Carbon Valley Farmer and Miner
25 May 2022, Carbon Valley Farmer and Miner

Opening Day Survey 2022: What People Are Riding at the Whistler Bike Park
25 May 2022, Pinkbike.com

provided by Google News

QuestDB snares $12M Series A with hosted version coming soon
3 November 2021, TechCrunch

Read the Pitch Deck Database Startup QuestDB Used to Raise $12 Million
11 November 2021, Business Insider

QuestDB nabs $2.3M seed to build open source time series database
2 July 2020, TechCrunch

Build a Real-time Stock Price Dashboard With Python, QuestDB and Plotly
6 November 2021, hackernoon.com

Q&A: Nicolas Hourcard, QuestDB: The advantages of a time-series database
3 December 2020, Developer News

provided by Google News

Teradata Scales Up R Analytics On Aster
3 July 2014, InformationWeek

How to Select the Right Database for Time-Series Data
2 December 2021, thenewstack.io

What Is a Data Lakehouse?
5 March 2022, Coinspeaker

Teradata, Lunexa Partnership Introduces Digital Marketing Attribution Solution for Teradata Aster Analytics Platforms
5 June 2012, PR Newswire

Case study: Siemens reduces train failures with Teradata Aster
12 September 2016, RCR Wireless News

provided by Google News

Job opportunities

Operations Manager
Barrett Plastic Surgery, Beverly Hills, CA

Director of Business Strategy and Development
Barrett Plastic Surgery, Beverly Hills, CA

Software Engineer Associate-Entry Level
LOCKHEED MARTIN CORPORATION, Mount Laurel, NJ

Data Mining II
Factory Motor Parts Company, Eagan, MN

Data Mining I
Factory Motor Parts, Eagan, MN

Counter-Proliferation Analyst (Missile and Delivery System SME)
Firebird AST, Reston, VA

Junior Data Integration Specialist
Paradyme Management, Clarksburg, WV

Product Manager
NXLog, Remote

Cloud Engineer
QuestDB, United States

Developer Relations Engineer
QuestDB, United States

Senior Backend Engineer (Python)
QuestDB, United States

Core Database Engineer
QuestDB, United States

Sr Analyst, DACI Analytics - Loyalty Analytics
Lowe's, Mooresville, NC

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Analyst, Support Analytics
Inspire Brands, Atlanta, GA

Sr Analyst, DACI Analytics
Lowe's, Mooresville, NC

Sr Analyst, Digital Analytics
Lowe's, Charlotte, NC

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Neo4j logo

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

Present your product here