DBMS > Adabas vs. Quasardb vs. Spark SQL
System Properties Comparison Adabas vs. Quasardb vs. Spark SQL
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Adabas denotes "adaptable data base" Xexclude from comparison||Quasardb Xexclude from comparison||Spark SQL Xexclude from comparison|
|Description||OLTP - DBMS for mainframes and Linux/Unix/Windows environments used typically together with the Natural programming platform||Distributed, high-performance timeseries database||Spark SQL is a component on top of 'Spark Core' for structured data processing|
|Primary database model||Multivalue DBMS||Time Series DBMS||Relational DBMS|
|Developer||Software AG||quasardb||Apache Software Foundation|
|Current release||3.13.3, April 2022||3.5.0 ( 2.13), September 2023|
|License Commercial or Open Source||commercial||commercial Free community edition, Non-profit organizations and non-commercial usage are eligible for free licenses||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||BS2000|
|Typing predefined data types such as float or date||yes||yes integer and binary||yes|
|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.||no||no||no|
|Secondary indexes||yes||yes with tags||no|
|SQL Support of SQL||yes with add-on product Adabas SQL Gateway||SQL-like query language||SQL-like DML and DDL statements|
|APIs and other access methods||HTTP API with add-on software Adabas SOA Gateway|
SOAP-based API with add-on software Adabas SOA Gateway
|Supported programming languages||Natural||.Net|
|Server-side scripts Stored procedures||in Natural||no||no|
|Partitioning methods Methods for storing different data on different nodes||yes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vista||Sharding consistent hashing||yes, utilizing Spark Core|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, with add-on product Event Replicator||Source-replica replication with selectable replication factor||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||with Hadoop integration|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes by using LevelDB||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes Transient mode||no|
|User concepts Access control||only with OS-specific tools (e.g. IBM RACF, CA Top Secret)||Cryptographically strong user authentication and audit trail||no|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Adabas denotes "adaptable data base"||Quasardb||Spark SQL|
|Recent citations in the news|
Fitch Assigns Software AG First-Time 'B+ (EXP)' IDR; Outlook Stable
Michael E. Jakes Obituary (1941 - 2023)
Rocket Buys Data Integration Provider B.O.S.
Software AG increases revenue and operating profit -July 24, 2023 ...
Rocket Software gives up in takeover tug-of-war over Software AG
provided by Google News
I create machine learning. It's revolutionising data analysis
What Is The Hottest Place In The Universe?
Quasar Partners with PTC to Empower IoT Customers with High ...
Estimating functions for visual field progression in newly diagnosed ...
The Well, The One, and Pinnacle One Yonge Vie for Top Honours in ...
provided by Google News
Boost Your Data Science Skills: Exciting Projects to Elevate Your ...
Intel Granulate Optimizes Databricks' Data Management Operations
Analysts Utilize the S&P Global Marketplace Workbench to Explore ...
Data Management and Consolidation in the Integration of Corporate ...
How Big Data Is Saving Lives in Real Time: IoV Data Analytics ...
provided by Google News
Sr. ADABAS DBA and Systems Programmer
Sr Data Migration Specialist
Programmer Analyst - Position No. 03489
Systems Administration support for UNIX Server systems
Senior Software Developer- Mainframe/Assembler/Network
Tech Lead, Data Engine
Data Scientist (L5) - Infrastructure Experimentation
Machine Learning Associate, 2024 Graduate U.S.
Senior Backline Engineer - Spark
Python/Spark/SQL Data Egnineer
Share this page