DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Google BigQuery vs. IBM Db2 Event Store

System Properties Comparison Adabas vs. Google BigQuery vs. IBM Db2 Event Store

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonGoogle BigQuery  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformLarge scale data warehouse service with append-only tablesDistributed Event Store optimized for Internet of Things use cases
Primary database modelMultivalue DBMSRelational DBMSEvent Store
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.77
Rank#79  Overall
#1  Multivalue DBMS
Score48.89
Rank#24  Overall
#16  Relational DBMS
Score0.43
Rank#251  Overall
#2  Event Stores
#20  Time Series DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlcloud.google.com/­bigquerywww.ibm.com/­products/­db2-event-store
Technical documentationcloud.google.com/­bigquery/­docswww.ibm.com/­support/­knowledgecenter/­en/­SSGNPV_2.0.0/­welcome.html
DeveloperSoftware AGGoogleIBM
Initial release197120102017
Current release2.0
License infoCommercial or Open Sourcecommercialcommercialcommercial infofree developer edition available
Cloud-based only infoOnly available as a cloud servicenoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinux infoLinux, macOS, Windows for the developer addition
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.nonono
Secondary indexesyesnono
SQL infoSupport of SQLyes infowith add-on product Adabas SQL Gatewayyesyes infothrough the embedded Spark runtime
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
RESTful HTTP/JSON APIADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
Supported programming languagesNatural.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
Server-side scripts infoStored proceduresin Naturaluser defined functions infoin JavaScriptyes
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistanoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorActive-active shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoSince BigQuery is designed for querying datano
Concurrency infoSupport for concurrent manipulation of datayesyesNo - written data is immutable
Durability infoSupport for making data persistentyesyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storage
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)fine 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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Adabas infodenotes "adaptable data base"Google BigQueryIBM Db2 Event Store
DB-Engines blog posts