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

DBMS > Derby vs. jBASE vs. Oracle vs. SingleStore vs. TDengine

System Properties Comparison Derby vs. jBASE vs. Oracle vs. SingleStore vs. TDengine

Editorial information provided by DB-Engines
NameDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonjBASE  Xexclude from comparisonOracle  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparisonTDengine  Xexclude from comparison
DescriptionFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.A robust multi-value DBMS comprising development tools and middlewareWidely used RDBMSMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table typeTime Series DBMS and big data platform
Primary database modelRelational DBMSMultivalue DBMSRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vector DBMS infosince Oracle 23
Document store
Spatial DBMS
Time Series DBMS
Vector DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.71
Rank#69  Overall
#37  Relational DBMS
Score1.41
Rank#159  Overall
#3  Multivalue DBMS
Score1236.29
Rank#1  Overall
#1  Relational DBMS
Score5.60
Rank#62  Overall
#35  Relational DBMS
Score2.60
Rank#107  Overall
#8  Time Series DBMS
Websitedb.apache.org/­derbywww.rocketsoftware.com/­products/­rocket-multivalue-application-development-platform/­rocket-jbasewww.oracle.com/­databasewww.singlestore.comgithub.com/­taosdata/­TDengine
tdengine.com
Technical documentationdb.apache.org/­derby/­manuals/­index.htmldocs.rocketsoftware.com/­bundle?labelkey=jbase_5.9docs.oracle.com/­en/­databasedocs.singlestore.comdocs.tdengine.com
DeveloperApache Software FoundationRocket Software (formerly Zumasys)OracleSingleStore Inc.TDEngine, previously Taos Data
Initial release19971991198020132019
Current release10.17.1.0, November 20235.723c, September 20238.5, January 20243.0, August 2022
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercial inforestricted free version is availablecommercial infofree developer edition availableOpen Source infoAGPL V3, also commercial editions available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SingleStoreDB Cloud: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation languageJavaC and C++C++, GoC
Server operating systemsAll OS with a Java VMAIX
Linux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Linux info64 bit version requiredLinux
Windows
Data schemeyesschema-freeyes infoSchemaless in JSON and XML columnsyesyes
Typing infopredefined data types such as float or dateyesoptionalyesyesyes
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.yesyesyesnono
Secondary indexesyesyesyesno
SQL infoSupport of SQLyesEmbedded SQL for jBASE in BASICyes infowith proprietary extensionsyes infobut no triggers and foreign keysStandard SQL with extensions for time-series applications
APIs and other access methodsJDBCJDBC
ODBC
Proprietary protocol
RESTful HTTP API
SOAP-based API
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC
JDBC
RESTful HTTP API
Supported programming languagesJava.Net
Basic
Jabbascript
Java
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Bash
C
C#
Java
JavaScript (Node.js)
Python
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Rust
Server-side scripts infoStored proceduresJava Stored ProceduresyesPL/SQL infoalso stored procedures in Java possibleyesno
Triggersyesyesyesnoyes, via alarm monitoring
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding, horizontal partitioningSharding infohash partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesMulti-source replication
Source-replica replication
Source-replica replication infostores two copies of each physical data partition on two separate nodesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono infocan be realized in PL/SQLno infocan define user-defined aggregate functions for map-reduce-style calculations
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infoisolation level can be parameterizedACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyes infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'yes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights can be defined down to the item levelfine grained access rights according to SQL-standardFine grained access control via users, groups and rolesyes
More information provided by the system vendor
Derby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBjBASEOracleSingleStore infoformer name was MemSQLTDengine
Specific characteristicsSingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
TDengine™ is a next generation data historian purpose-built for Industry 4.0 and...
» more
Competitive advantagesSingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
High Performance at any Scale: TDengine is purpose-built for handling massive industrial...
» more
Typical application scenariosDriving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
TDengine is designed for Industrial IoT scenarios, including: Manufacturing Connected...
» more
Key customersIEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsCustomers in various industries worldwide including US and International Industry...
» more
TDengine has garnered over 22,500 stars on GitHub and is used in over 50 countries...
» more
Licensing and pricing modelsF ree Tier and Enterprise Edition
» more
TDengine OSS is an open source, cloud native time series database. It includes built-in...
» more
News

Seamless Data Integration from MQTT and InfluxDB to TDengine: Logstash-like Functionality
22 May 2024

Solving Long Query Performance Bottlenecks
22 May 2024

What Is Predictive Maintenance?
17 May 2024

Can Typical Time-Series Databases Replace Data Historians?
8 May 2024

TDengine 3.3.0.0 Release Notes
7 May 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
3rd partiesNavicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

Devart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» more

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 JavaDBjBASEOracleSingleStore infoformer name was MemSQLTDengine
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Turbocharge Your Application Development Using WebAssembly With SingleStoreDB
17 October 2022,  Akmal Chaudhri, SingleStore (sponsor) 

Cloud-Based Analytics With SingleStoreDB
9 June 2022,  Akmal Chaudhri, SingleStore (sponsor) 

SingleStore: The Increasing Momentum of Multi-Model Database Systems
14 February 2022,  Akmal Chaudhri, SingleStore (sponsor) 

show all

Conferences, events and webinars

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

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

The Arrival of Java 20
21 March 2023, Oracle

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

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

Payara Foundation Releases Payara Server 5 and Payara Micro 5
30 March 2018, InfoQ.com

provided by Google News

Temenos signs first customer in India
24 August 2009, Finextra

provided by Google News

Understanding the different Oracle Database options under the OCI-Microsoft Azure partnership
21 May 2024, Oracle

Blog Theme - Details
22 May 2024, Oracle

AI-Fueled Enterprise Data Management: The Rise Of Oracle Database 23ai
7 May 2024, Forbes

Oracle Database 23ai Brings the Power of AI to Enterprise Data and Applications
2 May 2024, PR Newswire

Oracle Database 23ai - all of your data should be in one place, argues CTO Larry Ellison
3 May 2024, diginomica

provided by Google News

SingleStore CEO sees little future for purpose-built vector databases
24 January 2024, VentureBeat

SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development
24 January 2024, Business Wire

Building a Modern Database: Nikita Shamgunov on Postgres and Beyond
18 April 2024, Madrona Venture Group

SingleStore adds indexed vector search to Pro Max release for faster AI work – Blocks and Files
29 January 2024, Blocks & Files

Announcing watsonx.ai and SingleStore for generative AI applications
15 November 2023, ibm.com

provided by Google News

TDengine named Top Global Industrial Data Management Solution
4 January 2024, IT Brief Australia

New TDengine Benchmark Results Show Up to 37.0x Higher Query Performance Than InfluxDB and TimescaleDB
28 February 2023, Yahoo Finance

Comparing Different Time-Series Databases
10 February 2022, hackernoon.com

MindsDB is now the leading and fastest growing applied ML platform in the world India - English
3 November 2022, PR Newswire

provided by Google News



Share this page

Featured Products

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.

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

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