DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Derby vs. Ingres vs. Machbase Neo vs. Teradata

System Properties Comparison Derby vs. Ingres vs. Machbase Neo vs. Teradata

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonIngres  Xexclude from comparisonMachbase Neo infoFormer name was Infiniflux  Xexclude from comparisonTeradata  Xexclude from comparison
DescriptionFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Well established RDBMSTimeSeries DBMS for AIoT and BigDataA hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelRelational DBMSRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.60
Rank#70  Overall
#38  Relational DBMS
Score3.80
Rank#82  Overall
#44  Relational DBMS
Score0.17
Rank#337  Overall
#30  Time Series DBMS
Score44.87
Rank#22  Overall
#15  Relational DBMS
Websitedb.apache.org/­derbywww.actian.com/­databases/­ingresmachbase.comwww.teradata.com
Technical documentationdb.apache.org/­derby/­manuals/­index.htmldocs.actian.com/­ingresmachbase.com/­dbmsdocs.teradata.com
DeveloperApache Software FoundationActian CorporationMachbaseTeradata
Initial release19971974 infooriginally developed at University Berkely in early 1970s20131984
Current release10.17.1.0, November 202311.2, May 2022V8.0, August 2023Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercial infofree test version availablecommercial
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 languageJavaCC
Server operating systemsAll OS with a Java VMAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
Linux
macOS
Windows
hosted
Linux
Data schemeyesyesyesyes
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.yesno infobut tools for importing/exporting data from/to XML-files availablenoyes
Secondary indexesyesyesyesyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyesyesSQL-like query languageyes infoSQL 2016 + extensions
APIs and other access methodsJDBC.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
gRPC
HTTP REST
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languagesJavaC
C#
C++
Go
Java
JavaScript
PHP infovia ODBC
Python
R infovia ODBC
Scala
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresJava Stored Proceduresyesnoyes infoUDFs, stored procedures, table functions in parallel
Triggersyesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal partitioning infoIngres Star to access multiple databases simultaneouslyShardingSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationIngres Replicatorselectable replication factorMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesnoyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes infovolatile and lookup tableyes
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardsimple password-based access controlfine grained access rights according to SQL-standard

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
Derby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBIngresMachbase Neo infoFormer name was InfinifluxTeradata
DB-Engines blog posts

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

JDBC tutorial: Easy installation and setup with Apache Derby
20 December 2019, TheServerSide.com

Installing Apache Hive 3.1.2 on Windows 10 | by Hadi Fadlallah
3 May 2020, Towards Data Science

The Arrival of Java 20
21 March 2023, Oracle

The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

The ApacheĀ® Software Foundation Announces 18 Years of Open Source Leadership
28 March 2017, GlobeNewswire

provided by Google News

Actian Launches Ingres 12.0 Database
4 June 2024, PR Newswire

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

New startup from Postgres creator puts the database at heart of software stack
12 March 2024, TechCrunch

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

Dr. Michael Stonebraker: A Short History of Database Systems
1 February 2019, The New Stack

provided by Google News

SHAREHOLDER ALERT: Pomerantz Law Firm Reminds Shareholders with Losses on their Investment in Teradata ...
15 June 2024, PR Newswire

TERADATA ALERT: Bragar Eagel & Squire, P.C. Announces that a Class Action Lawsuit Has Been Filed Against ...
15 June 2024, GlobeNewswire

Teradata Stock: Much More Enticing Now Than Last Year, But Uncertainty Lingers (NYSE:TDC)
14 June 2024, Seeking Alpha

Is There Now An Opportunity In Teradata Corporation (NYSE:TDC)?
11 June 2024, Simply Wall St

Teradata Stock Analysis: Don't Let the Amazon News Fool You Into Buying Now
10 June 2024, InvestorPlace

provided by Google News



Share this page

Featured Products

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.

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