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 > Alibaba Cloud AnalyticDB for MySQL vs. Brytlyt vs. Google BigQuery vs. InterSystems IRIS vs. Newts

System Properties Comparison Alibaba Cloud AnalyticDB for MySQL vs. Brytlyt vs. Google BigQuery vs. InterSystems IRIS vs. Newts

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for MySQL  Xexclude from comparisonBrytlyt  Xexclude from comparisonGoogle BigQuery  Xexclude from comparisonInterSystems IRIS  Xexclude from comparisonNewts  Xexclude from comparison
DescriptionA real-time data warehousing service that can process petabytes of data with high concurrency and low latency. It is fully compatible with the MySQL protocol.Scalable GPU-accelerated RDBMS for very fast analytic and streaming workloads, leveraging PostgreSQLLarge scale data warehouse service with append-only tablesA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalabilityTime Series DBMS based on Cassandra
Primary database modelRelational DBMSRelational DBMSRelational DBMSDocument store
Key-value store
Object oriented DBMS
Relational DBMS
Time Series DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.74
Rank#201  Overall
#98  Relational DBMS
Score0.36
Rank#260  Overall
#121  Relational DBMS
Score45.81
Rank#24  Overall
#16  Relational DBMS
Score1.84
Rank#127  Overall
#21  Document stores
#23  Key-value stores
#2  Object oriented DBMS
#62  Relational DBMS
Score0.00
Rank#358  Overall
#36  Time Series DBMS
Websitewww.alibabacloud.com/­product/­analyticdb-for-mysqlwww.brytlyt.comcloud.google.com/­bigquerywww.intersystems.com/­products/­intersystems-irisopennms.github.io/­newts
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­93776.htmcloud.google.com/­bigquery/­docsdocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.clsgithub.com/­OpenNMS/­newts/­wiki
DeveloperAlibabaBrytlytGoogleInterSystemsOpenNMS Group
Initial release2016201020182014
Current release0.9, October 20162021.1, June 2021
License infoCommercial or Open SourcecommercialcommercialcommercialcommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, C++ and CUDAJava
Server operating systemshostedLinux
OS X
Windows
hostedAIX
Linux
macOS
Windows
Linux
OS X
Windows
Data schemeyesyesyesdepending on used data modelschema-free
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.yesyes infospecific XML-type available, but no XML query functionality.noyesno
Secondary indexesyesyesnoyesno
SQL infoSupport of SQLyesyesyesyesno
APIs and other access methodsJDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
RESTful HTTP/JSON APIJDBC
ODBC
RESTful HTTP API
HTTP REST
Java API
Supported programming languagesC#
Java
PHP
Python
.Net
C
C++
Delphi
Java
Perl
Python
Tcl
.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
.Net
C++
Java
JavaScript (Node.js)
Python
Java
Server-side scripts infoStored proceduresyesuser defined functions infoin PL/pgSQLuser defined functions infoin JavaScriptyesno
Triggersyesyesnoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud servicenoneShardingSharding infobased on Cassandra
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceSource-replica replicationSource-replica replicationselectable replication factor infobased on Cassandra
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Foreign keys infoReferential integrityyesyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDno infoSince BigQuery is designed for querying dataACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)yesno
More information provided by the system vendor
Alibaba Cloud AnalyticDB for MySQLBrytlytGoogle BigQueryInterSystems IRISNewts
Specific characteristicsA real-time data warehousing service that can process PB data with high concurrency...
» more
Competitive advantagesTPC Benchmark: The world leading result in TPC-DS benchmark . TPC-H benchmark for...
» more
Licensing and pricing modelsAvailable regions: America US Virginia US Silicon Valley Asia China Hong Kong India...
» more

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
Alibaba Cloud AnalyticDB for MySQLBrytlytGoogle BigQueryInterSystems IRISNewts
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Alibaba Cloud Launches New Livestreaming E-commerce Solution at Its Cloud Summit
9 June 2021, Al-Bawaba

provided by Google News

USD 361.56 million growth for GPU Database Market from 2020 to 2025 |Evolving Opportunities with BlazingSQL Inc., Brytlyt Ltd. & Hetero DB Co. Ltd.|17000+ Technavio Reports
26 November 2021, PRNewswire

Brytlyt Unleashes Serverless GPU-Acceleration for Analytics
15 September 2021, PR Newswire UK

Brytlyt Awarded US Patent for Relational JOINs Algorithm
27 August 2021, PRNewswire

Brytlyt Lauded by Frost & Sullivan for Building BrytlytDB, a GPU-powered Analytics Platform that Is Transforming the Way Companies Leverage Data
21 June 2021, MarTech Series

Brytlyt Secures Series A to Turbocharge Real-Time Data Analytics
20 May 2020, PRNewswire

provided by Google News

Google’s Logica language addresses SQL’s flaws
15 April 2021, InfoWorld

Acquisitions to Fuel Programmable Analytics
11 June 2019, DevOps.com

provided by Google News

InterSystems IRIS Achieves AWS Graviton Ready Designation
1 December 2021, Business Wire

eConsult partners with InterSystems to help expand solution deployment
1 December 2021, Digital Health

Latest Release of InterSystems IRIS Data Platform Provides Next Step in Data Fabric Adoption
17 June 2021, Business Wire

InterSystems IRIS for Health™ and First Line Software to Streamline Clinical Research Workflows on i2b2
29 October 2021, Business Wire

InterSystems IRIS® FHIR® Accelerator Service Enables Easy Retrieval and Storage of Healthcare Data
20 September 2021, Business Wire

provided by Google News

Rapid phenotypic change in a polymorphic salamander over 43 years | Scientific Reports
22 November 2021, Nature.com

provided by Google News

Job opportunities

Presales Engineer - Voltage Data Privacy & Protection
Micro Focus, Sunnyvale, CA

Financial Services Sales Manager
InterSystems, Cambridge, MA

Healthcare Software Engineer
Ready Computing Resources LLC, New York, NY

Solutions Development Program
InterSystems, Cambridge, MA

Professional Services Consultant
InterSystems, New York, NY

IT Database Administrator - UC Health Business Center - IS&T
UC Health, Cincinnati, OH

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Neo4j logo

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

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.

Present your product here