DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Oracle NoSQL vs. SQL.JS vs. Teradata Aster

System Properties Comparison AlaSQL vs. Oracle NoSQL vs. SQL.JS vs. Teradata Aster

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonSQL.JS  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.
DescriptionJavaScript DBMS libraryA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesPort of SQLite to JavaScriptPlatform for big data analytics on multistructured data sources and types
Primary database modelDocument store
Relational DBMS
Document store
Key-value store
Relational DBMS
Relational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.55
Rank#235  Overall
#37  Document stores
#112  Relational DBMS
Score4.41
Rank#81  Overall
#14  Document stores
#13  Key-value stores
#44  Relational DBMS
Score1.16
Rank#162  Overall
#79  Relational DBMS
Websitealasql.orgwww.oracle.com/­database/­technologies/­related/­nosql.htmlsql.js.org
Technical documentationgithub.com/­agershun/­alasqldocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlsql.js.org/­documentation/­index.html
DeveloperAndrey Gershun & Mathias R. WulffOracleAlon Zakai infoenhancements implemented by othersTeradata
Initial release2014201120122005
Current release21.2, September 2021
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)Open Sourcecommercial
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 languageJavaScriptJavaJavaScript
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Linux
Solaris SPARC/x86
server-less, requires a JavaScript environment (browser, Node.js)Linux
Data schemeschema-freeSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.yesFlexible 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 datenooptionalyesyes
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 Store
Secondary indexesnoyesyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.SQL-like DML and DDL statementsyes infoSQL-92 is not fully supportedyes
APIs and other access methodsJavaScript APIRESTful HTTP APIJavaScript APIADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesJavaScriptC
C#
Go
Java
JavaScript (Node.js)
Python
JavaScriptC
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresnononoR packages
Triggersyesnonono
Partitioning methods infoMethods for storing different data on different nodesnoneShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featurenoneyes 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 methodsnowith Hadoop integrationnoyes infoSQL Map-Reduce Framework
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency
Immediate Consistency infodepending on configuration
noneImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageconfigurable infoACID within a storage node (=shard)ACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesno infoexcept by serializing a db to a fileyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infooff heap cacheyesno
User concepts infoAccess controlnoAccess rights for users and rolesnofine 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
AlaSQLOracle NoSQLSQL.JSTeradata Aster
DB-Engines blog posts

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

show all

Recent citations in the news

Meet AlaSQL, a speedy SQL database for JavaScript
15 January 2019, JAXenter

provided by Google News

The 10 Major Players in Cloud Database Management Systems, 2021
10 January 2022, Solutions Review

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

First look: Oracle NoSQL Database
16 November 2011, InfoWorld

Oracle Announces 5 Key Enhancements to NoSQL Database
25 May 2016, Database Trends and Applications

Oracle Announces NoSQL Database Cloud Service
1 April 2020, Database Trends and Applications

provided by Google News

An overview of the Teradata Aster Analytics platform
31 May 2017, TechTarget

Big Data Analytics: Teradata Launches Aster Discovery Platform
9 October 2013, Data Center Knowledge

Teradata puts Aster on Hadoop, adds 'Listener' For IoT
21 October 2015, ZDNet

Teradata Aster gets graph database, HDFS-compatible file store
8 October 2013, ZDNet

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

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

Data Engineer - Customer Packaging Experience
Amazon.com Services LLC, Seattle, WA

Cyber Security Engineer – I , II, and III
Melkotech, Dahlgren, VA

Software Engineer - Database and Systems Technologies
Oracle, United States

Business Intelligence Engineer, Business Engagement and Strategy Employee Experience
Amazon.com Services LLC, Seattle, WA

Senior Application Developer
AT&T, Dallas, TX

Full-Stack Developer, .NET/SQL/JS (Bentonville)
Perks, Bentonville, AR

Operations Specialist (Data Production and Delivery)
Fraym, Arlington, VA

Web Developer
Fungi Perfecti, Olympia, WA

Analyst (Data Production and Delivery)
Fraym, Arlington, VA

Integrations Specialist
Stylitics, New York, NY

Analyst, Navigation & Digital Taxonomy - Remote
Lowe's, Mooresville, NC

Lead Risk Analyst, Operations
Podium Infotech, Lehi, UT

Data Analyst - Risk Management
Podium, Lehi, UT

Data Analyst - Risk Management
Podium Infotech, Lehi, UT

Lead-Risk Management
Verizon, Alpharetta, GA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Present your product here