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

DBMS > DuckDB vs. NuoDB vs. SQL.JS vs. Teradata Aster vs. Yaacomo

System Properties Comparison DuckDB vs. NuoDB vs. SQL.JS vs. Teradata Aster vs. Yaacomo

Editorial information provided by DB-Engines
NameDuckDB  Xexclude from comparisonNuoDB  Xexclude from comparisonSQL.JS  Xexclude from comparisonTeradata Aster  Xexclude from comparisonYaacomo  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.Yaacomo seems to be discontinued and is removed from the DB-Engines ranking
DescriptionAn embeddable, in-process, column-oriented SQL OLAP RDBMSNuoDB is a webscale distributed database that supports SQL and ACID transactionsPort of SQLite to JavaScriptPlatform for big data analytics on multistructured data sources and typesOpenCL based in-memory RDBMS, designed for efficiently utilizing the hardware via parallel computing
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.63
Rank#69  Overall
#37  Relational DBMS
Score0.94
Rank#197  Overall
#92  Relational DBMS
Score0.63
Rank#241  Overall
#112  Relational DBMS
Websiteduckdb.orgwww.3ds.com/­nuodb-distributed-sql-databasesql.js.orgyaacomo.com
Technical documentationduckdb.org/­docsdoc.nuodb.comsql.js.org/­documentation/­index.html
DeveloperDassault Systèmes infooriginally NuoDB, Inc.Alon Zakai infoenhancements implemented by othersTeradataQ2WEB GmbH
Initial release20182013201220052009
Current release1.0.0, June 2024
License infoCommercial or Open SourceOpen Source infoMIT Licensecommercial infolimited edition freeOpen Sourcecommercialcommercial
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.
Implementation languageC++C++JavaScript
Server operating systemsserver-lesshosted infoAmazon EC2, Windows Azure, SoftLayer
Linux
OS X
Windows
server-less, requires a JavaScript environment (browser, Node.js)LinuxAndroid
Linux
Windows
Data schemeyesyesyesFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Storeyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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 infoin Aster File Storeno
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyesyesyes infoSQL-92 is not fully supportedyesyes
APIs and other access methodsArrow Database Connectivity (ADBC)
CLI Client
JDBC
ODBC
ADO.NET
JDBC
ODBC
JavaScript APIADO.NET
JDBC
ODBC
OLE DB
JDBC
ODBC
Supported programming languagesC
C# info3rd party driver
C++
Crystal info3rd party driver
Go info3rd party driver
Java
Lisp info3rd party driver
Python
R
Ruby info3rd party driver
Rust
Swift
Zig info3rd party driver
.Net
C
C++
Go
Java
JavaScript
JavaScript (Node.js)
PHP
Python
Ruby
JavaScriptC
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresnoJava, SQLnoR packages
Triggersnoyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesnonedata is dynamically stored/cached on the nodes where it is read/writtennoneShardinghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes infoManaged transparently by NuoDBnoneyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infoSQL Map-Reduce Frameworkno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencynoneImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynoyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infotunable commit protocolACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesno infoexcept by serializing a db to a fileyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoTemporary tableyesnoyes
User concepts infoAccess controlnoStandard SQL roles/ privileges, Administrative Usersnofine grained access rights according to SQL-standardfine 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
DuckDBNuoDBSQL.JSTeradata AsterYaacomo
DB-Engines blog posts

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

MotherDuck Announces General Availability; Brings Simplicity and Power of DuckDB in a Serverless Data Warehouse
11 June 2024, PR Newswire

DuckDB: The tiny but powerful analytics database
15 May 2024, InfoWorld

DuckDB promises greater stability with 1.0 release
5 June 2024, The Register

DuckDB: In-Process Python Analytics for Not-Quite-Big Data
31 May 2024, The New Stack

My First Billion (of Rows) in DuckDB | by João Pedro | May, 2024
1 May 2024, Towards Data Science

provided by Google News

Dassault Systèmes Announces the Acquisition of NuoDB, a Cloud-Native Distributed SQL Database Leader
25 November 2020, Dassault Systèmes

Deploy the NuoDB Database in Docker Containers
16 October 2017, The New Stack

Big Data Product Watch 1/31/17: No-Cost NuoDB, GPU Analytics, Cloud Object Storage, More -- ADTmag
31 January 2017, ADT Magazine

NuoDB Raises $14.2M Round Led By Dassault Systèmes For Its Distributed Database Management System
26 February 2014, TechCrunch

NuoDB empowers distributed database users to optimize cloud and container resources with new graphical dashboard
10 April 2018, Daily Host News

provided by Google News

9 Best JavaScript and TypeScript ORMs for 2024 — SitePoint
22 March 2023, SitePoint

Execute millions of SQL statements in milliseconds in the browser with WebAssembly and Web Workers.
14 January 2017, hackernoon.com

SQLite On The Web: Absurd-sql
24 August 2021, Hackaday

In Praise Of SQLite
28 July 2022, iProgrammer

10 Low-Code Rules for Serious Coders
21 November 2022, Embedded Computing Design

provided by Google News

Teradata Enhances Big Data Analytics Platform
31 May 2024, Data Center Knowledge

Northwestern Analytics Partners with Teradata Aster to Host Hackathon
23 May 2014, Northwestern Engineering

Teradata Provides the Simplest Way to Bring the Science of Data to the Art of Business
22 September 2011, PR Newswire

Teradata's Aster shows how the flowers of fraud bloom
23 April 2015, The Register

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

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.

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

Present your product here