DBMS > Adabas vs. Snowflake vs. STSdb
System Properties Comparison Adabas vs. Snowflake vs. STSdb
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||Snowflake Xexclude from comparison||STSdb Xexclude from comparison|
|Description||OLTP - DBMS for mainframes and Linux/Unix/Windows environments used typically together with the Natural programming platform||Cloud-based data warehousing service for structured and semi-structured data||Key-Value Store with special method for indexing optimized for high performance using a special indexing method|
|Primary database model||Multivalue DBMS||Relational DBMS||Key-value store|
|Developer||Software AG||Snowflake Computing Inc.||STS Soft SC|
|Current release||4.0.8, September 2015|
|License Commercial or Open Source||commercial||commercial||Open Source GPLv2, commercial license available|
|Cloud-based only Only available as a cloud service||no||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||BS2000|
|Data scheme||yes||yes support of semi-structured data formats (JSON, XML, Avro)||yes|
|Typing predefined data types such as float or date||yes||yes||yes primitive types and user defined types (classes)|
|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||yes|
|SQL Support of SQL||yes with add-on product Adabas SQL Gateway||yes||no|
|APIs and other access methods||HTTP API with add-on software Adabas SOA Gateway|
SOAP-based API with add-on software Adabas SOA Gateway
|.NET Client API|
|Server-side scripts Stored procedures||in Natural||user defined functions||no|
|Triggers||no||no similar concept for controling cloud resources||no|
|Partitioning methods Methods for storing different data on different nodes||yes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vista||yes||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, with add-on product Event Replicator||yes||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||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||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no|
|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||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|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Adabas denotes "adaptable data base"||Snowflake||STSdb|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year Snowflake is the DBMS of the Year 2021
Snowflake is the DBMS of the Year 2021
|Recent citations in the news|
Why cloud isn't always the answer
Software AG Delivers Fourth Consecutive Quarter of Digital ...
Software AG grows strongly - cost-cutting program due to weak margin
Software AG Q3 keeps growth on track amidst management changes
Zulu Software Announces the Successful Completion of a Natural ...
provided by Google News
Outreach Introduces Outreach Data Sharing on the Snowflake Data ...
StarCompliance Builds Secure Data Access Solution on Snowflake ...
RepRisk Launches ESG Risk Data on Snowflake Marketplace
Scientific Financial Systems, Inc. (SFS) launches Quotient™ on the ...
kipi.bi Announces Launch of WatchKeeper™ Monitoring Accelerator for Snowflake
provided by Google News
Database Developers I, II, or III
Mainframe Adabas Database Administrator Level 4
MIS Application Support Developer
Tableau Developer with Snowflake
Share this page