DBMS > Adabas vs. AllegroGraph vs. DuckDB vs. Lovefield vs. Rockset

System Properties Comparison Adabas vs. AllegroGraph vs. DuckDB vs. Lovefield vs. Rockset

Editorial information provided by DB-Engines

Name

Description

OLTP - DBMS for mainframes and Linux/Unix/Windows environments

used typically together with the Natural programming platform

High performance, persistent RDF store with additional support for Graph DBMS

An embeddable, in-process, column-oriented SQL OLAP RDBMS

Embeddable relational database for web apps written in pure JavaScript

A scalable, reliable search and analytics service in the cloud, built on RocksDB

Primary database model

Multivalue DBMS

Document store

with version 6.5
Graph DBMS
RDF store

Relational DBMS

Document store

Secondary database models

Spatial DBMS

Relational DBMS
Search engine

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	4.78
Rank	#81	Overall
	#1	Multivalue DBMS

Score	1.15
Rank	#166	Overall
	#29	Document stores
	#14	Graph DBMS
	#7	RDF stores

Score	0.34
Rank	#267	Overall
	#123	Relational DBMS

Score	0.23
Rank	#283	Overall
	#133	Relational DBMS

Score	0.54
Rank	#233	Overall
	#36	Document stores

Website

www.softwareag.com/en_corporate/platform/adabas-natural.html

allegrograph.com

duckdb.org

google.github.io/lovefield

rockset.com

Technical documentation

franz.com/agraph/support/documentation/current/agraph-introduction.html

duckdb.org/docs

github.com/google/lovefield/blob/master/docs/spec_index.md

docs.rockset.com

Developer

Software AG

Franz Inc.

Google

Rockset

Initial release

1971

2004

2018

2014

2019

Current release

7.2, October 2021

0.2, August 2020

2.1.12, February 2017

License

Commercial or Open Source

commercial

Limited community edition free

Open Source

MIT License

Open Source

Apache 2.0

commercial

Cloud-based only

Only available as a cloud service

yes

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation language

C++

JavaScript

C++

Server operating systems

BS2000
Linux
Unix
Windows
z/OS
z/VSE

Linux
OS X
Windows

server-less

server-less, requires a JavaScript environment (browser, Node.js)

tested with Chrome, Firefox, IE, Safari

hosted

Data scheme

yes

RDF schemas

yes

schema-free

Typing

predefined data types such as float or date

yes

dynamic typing

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

bulk load of XML files possible

ingestion from XML files supported

Secondary indexes

yes

all fields are automatically indexed

SQL

Support of SQL

yes

with add-on product Adabas SQL Gateway

SPARQL is used as query language

yes

SQL-like query language

via JavaScript builder pattern

Read-only SQL queries, including JOINs

APIs and other access methods

HTTP API

with add-on software Adabas SOA Gateway
SOAP-based API

with add-on software Adabas SOA Gateway

RESTful HTTP API
SPARQL

CLI Client
JDBC

HTTP REST

Supported programming languages

Natural

C#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala

C
C++
Go

3rd party driver
Java
Python
R
Ruby

3rd party driver

JavaScript

Go
Java
JavaScript (Node.js)
Python

Server-side scripts

Stored procedures

in Natural

yes

JavaScript or Common Lisp

Triggers

yes

Using read-only observers

Partitioning methods

Methods for storing different data on different nodes

yes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vista

with Federation

none

Automatic sharding

Replication methods

Methods for redundantly storing data on multiple nodes

yes, with add-on product Event Replicator

Multi-source replication
Source-replica replication

none

yes

MapReduce

Offers an API for user-defined Map/Reduce methods

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Immediate Consistency or Eventual Consistency depending on configuration

Immediate Consistency

Eventual Consistency

Foreign keys

Referential integrity

yes

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Concurrency

Support for concurrent manipulation of data

yes

yes, multi-version concurrency control (MVCC)

yes

Durability

Support for making data persistent

yes

yes, by using IndexedDB or the cloud service Firebase Realtime Database

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

using MemoryDB

User concepts

Access control

only with OS-specific tools (e.g. IBM RACF, CA Top Secret)

Users with fine-grained authorization concept, user roles and pluggable authentication

Access rights for users and organizations can be defined via Rockset console

More information provided by the system vendor

Specific characteristics

Knowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more

Competitive advantages

AllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» more

News

100 Companies That Matter – Franz Inc.
10 March 2022

Knowledge Graph Standards in Ambient Computing
15 February 2022

Linguistic Reduction and Knowledge Graphs for Next-Gen Chatbots
31 January 2022

Authentic Meets Artificial – The New Intelligence – DM Radio Broadcast
13 January 2022

Embedding Gruff In a Web Page
10 January 2022

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

Recent citations in the news

Software AG Delivers Fourth Consecutive Quarter of Digital Business Product Revenue Growth; Accelerates Profit in First Quarter
27 April 2022, Yahoo Finance

Software Aktiengesellschaft (OTCMKTS:SWDAF) Short Interest Update
18 April 2022, Defense World

Software Aktiengesellschaft (OTCMKTS:STWRY) to Issue Dividend of $0.13
14 May 2022, Defense World

Short Interest in Software Aktiengesellschaft (OTCMKTS:SWDAF) Grows By 35.7%
2 May 2022, Defense World

Accelerate business performance, digitisation with integration leader mWtech
25 April 2022, ITWeb

provided by Google News

Neuro-Symbolic AI: The Peak of Artificial Intelligence
16 November 2021, AiThority

Why Young Developers Don't Get Knowledge Graphs
30 July 2021, Datanami

4 Benefits of Integrating a Language With a Database
13 September 2021, DevOps.com

Franz's Allegro CL® Used for Scheduling the Hubble Space Telescope Discovery of Earendel
2 April 2022, insideBIGDATA

Franz's AllegroGraph 7.2 Powers Enterprise Data Fabrics With Graph Neural Networks, Virtual Graphs and Streaming Graph Pipelines
25 October 2021, Business Wire

provided by Google News

New CWI spin-off company DuckDB Labs: Solutions for fast database analytics
14 July 2021, Centrum Wiskunde & Informatica (CWI)

Apache Arrow 6 Improves Support For R and Rust
22 November 2021, iProgrammer

Meet TQP: The First Query Processor to Run On Tensor Computation Runtimes Delivers up to 20x Speedups Over CPU-Only Systems
4 March 2022, Synced

Apache Arrow 5 Improves Asynchronous Scanner
16 August 2021, iProgrammer

4 predictions for open source in 2021
29 December 2020, IDG Connect

provided by Google News

Google Lovefield Relational Query Engine
21 November 2014, iProgrammer

provided by Google News

Rockset Enables Real-Time Analytics for Microsoft SQL Server
29 April 2022, GlobeNewswire

Analytics and Data Science News for the Week of April 29; Updates from Dresner, Pyramid Analytics, Rockset, and More
28 April 2022, Solutions Review

SQL and Complex Queries Are Needed for Real-Time Analytics
18 April 2022, thenewstack.io

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

Tecton Hosts Second Annual apply(conf), a Machine Learning Data Engineering Event, May 18-19
16 May 2022, GlobeNewswire

provided by Google News

Job opportunities

Adabas Database Specialist
DMI, Remote

Mainframe Developer - Natural / ADABAS
Apexon, Richmond, VA

REMOTE WORK: Natural ADABAS Developer
Spruce Technology, Remote

Mainframe Programmer
NuAxis Innovations, Denver, CO

Mainframes - Natural 4 / ADABAS Developer with 10+yrs exp preferred local NYC, NY - immediate interview
Spruce Technology, New York, NY

Modeling and Simulation Tools Data Scientist
The GBS Group, Philadelphia, PA

Software Developer
The GBS Group, Philadelphia, PA

Modeling and Simulation Tools Data Scientist
General Dynamics Information Technology, Philadelphia, PA

Head and VP of Data Architecture and Engineering
Totus Medicines, Emeryville, CA

Data Architect (Data Engineer), Senior
TRIAEM, LLC, Springfield, VA

Software Engineer - Compute Kernel (Rust)
Singularity Data, Remote

Senior Software Engineer (Hybrid Mobile and Web Apps)
Universal Avionics Systems Corporation, Duluth, GA

Pre-K Teacher (Montessori)
Willow Montessori Academy, Dallas, TX

Account Executive
rockset, Remote

Product Manager
rockset, Remote

Sales Development Representative
rockset, Dallas, TX

Product Marketing Manager - New MBA Grad
rockset, Remote

Risk Analyst
Fast AF, Remote

jobs by

Share this page