DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Cassandra vs. Databricks vs. Google BigQuery vs. MarkLogic vs. Sadas Engine

System Properties Comparison Apache Cassandra vs. Databricks vs. Google BigQuery vs. MarkLogic vs. Sadas Engine

Editorial information provided by DB-Engines
NameApache Cassandra  Xexclude from comparisonDatabricks  Xexclude from comparisonGoogle BigQuery  Xexclude from comparisonMarkLogic  Xexclude from comparisonSadas Engine  Xexclude from comparison
DescriptionWide-column store based on ideas of BigTable and DynamoDB infoOptimized for write accessThe Databricks Lakehouse Platform combines elements of data lakes and data warehouses to provide a unified view onto structured and unstructured data. It is based on Apache Spark.Large scale data warehouse service with append-only tablesOperational and transactional Enterprise NoSQL databaseSADAS Engine is a columnar DBMS specifically designed for high performance in data warehouse environments
Primary database modelWide column storeDocument store
Relational DBMS
Relational DBMSDocument store
Native XML DBMS
RDF store infoas of version 7
Search engine
Relational DBMS
Secondary database modelsVector DBMS infostarting with release V5
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score97.71
Rank#11  Overall
#1  Wide column stores
Score86.46
Rank#14  Overall
#2  Document stores
#9  Relational DBMS
Score50.58
Rank#19  Overall
#13  Relational DBMS
Score4.28
Rank#67  Overall
#11  Document stores
#1  Native XML DBMS
#1  RDF stores
#8  Search engines
Score0.00
Rank#383  Overall
#158  Relational DBMS
Websitecassandra.apache.orgwww.databricks.comcloud.google.com/­bigquerywww.progress.com/­marklogicwww.sadasengine.com
Technical documentationcassandra.apache.org/­doc/­latestdocs.databricks.comcloud.google.com/­bigquery/­docswww.progress.com/­marklogic/­documentationwww.sadasengine.com/­en/­sadas-engine-download-free-trial-and-documentation/­#documentation
DeveloperApache Software Foundation infoApache top level project, originally developped by FacebookDatabricksGoogleMarkLogic Corp.SADAS s.r.l.
Initial release20082013201020012006
Current release5.0-rc1, July 202411.0, December 20228.0
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercialcommercial inforestricted free version is availablecommercial infofree trial version available
Cloud-based only infoOnly available as a cloud servicenoyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Astra DB: Multi-cloud DBaaS built on Apache Cassandra.
Implementation languageJavaC++C++
Server operating systemsBSD
Linux
OS X
Windows
hostedhostedLinux
OS X
Windows
AIX
Linux
Windows
Data schemeschema-freeFlexible Schema (defined schema, partial schema, schema free)yesschema-free infoSchema can be enforcedyes
Typing infopredefined data types such as float or dateyesyesyesyes
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.noyesnoyesno
Secondary indexesrestricted infoonly equality queries, not always the best performing solutionyesnoyesyes
SQL infoSupport of SQLSQL-like SELECT, DML and DDL statements (CQL)with Databricks SQLyesyes infoSQL92yes
APIs and other access methodsProprietary protocol infoCQL (Cassandra Query Language, an SQL-like language)
Thrift
JDBC
ODBC
RESTful HTTP API
RESTful HTTP/JSON APIJava API
Node.js Client API
ODBC
proprietary Optic API infoProprietary Query API, introduced with version 9
RESTful HTTP API
SPARQL
WebDAV
XDBC
XQuery
XSLT
JDBC
ODBC
Proprietary protocol
Supported programming languagesC#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
Python
R
Scala
.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
C
C#
C++
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
C
C#
C++
Groovy
Java
PHP
Python
Server-side scripts infoStored proceduresnouser defined functions and aggregatesuser defined functions infoin JavaScriptyes infovia XQuery or JavaScriptno
Triggersyesnoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infono "single point of failure"noneShardinghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infoRepresentation of geographical distribution of servers is possibleyesyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnoyes infovia Hadoop Connector, HDFS Direct Access and in-database MapReduce jobsno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Immediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoAtomicity and isolation are supported for single operationsACIDno infoSince BigQuery is designed for querying dataACID infocan act as a resource manager in an XA/JTA transaction
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.nononoyes, with Range Indexesyes infomanaged by 'Learn by Usage'
User concepts infoAccess controlAccess rights for users can be defined per objectAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)Role-based access control at the document and subdocument levelsAccess rights for users, groups and roles according to SQL-standard
More information provided by the system vendor
Apache CassandraDatabricksGoogle BigQueryMarkLogicSadas Engine
Specific characteristicsApache Cassandra is the leading NoSQL, distributed database management system, well...
» more
Supported database models : In addition to the Document store and Relational DBMS...
» more
Competitive advantagesNo single point of failure ensures 100% availability . Operational simplicity for...
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
Key customersApple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...
» more
Market metricsApache Cassandra is used by 40% of the Fortune 100.
» more
Licensing and pricing modelsApache license  Pricing for commercial distributions provided by DataStax and available...
» more
News

The Reality of AI and Cloud Adoption
6 November 2024

Maximizing Self-Managed Apache Cassandra with Kubernetes
5 November 2024

Unify Internal and External Data for AI Workflows with Glean, Astra DB, and Langflow
30 October 2024

Let Copilot Initiate Your Database with the Latest DataStax Astra DB GitHub Copilot Extension
29 October 2024

How AI Agents and Humans Collaborate to Turn Unstructured Data into Action
24 October 2024

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 partiesCassandra Forward event: Want to level up your Cassandra game? Watch now replays of the March 2023 sessions.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Apache CassandraDatabricksGoogle BigQueryMarkLogicSadas Engine
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

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

show all

Recent citations in the news

Apache Cassandra Poll: AI Use Cases Are Set to Triple
8 November 2024, The New Stack

New Apache Cassandra 5.0 gives open source NoSQL database a scalability and performance boost
6 September 2024, VentureBeat

Apache Cassandra introduces version 5.0 of open-source NoSQL database
9 September 2024, Techzine Europe

Migrate Cassandra workloads to Amazon Keyspaces using CQLReplicator
4 September 2024, AWS Blog

Apache Software Foundation Announces Apache Cassandra® 5.0,
7 October 2024, GlobeNewswire

provided by Google News

Databricks could launch IPO in two months but biding time despite investor pressure, CEO says
13 September 2024, ION Analytics

Exclusive | Amazon, Databricks Strike Five-Year Deal Around AI Chips
15 October 2024, The Wall Street Journal

Databricks Mosaic Research Examines Long-Context Retrieval-Augmented Generation: How Leading AI Models Handle Expansive Information for Improved Response Accuracy
9 November 2024, MarkTechPost

Databricks partners with AWS to accelerate GenAI development
16 October 2024, Blocks & Files

Databricks & AWS Join in Push to Enhance Gen AI Capabilities
17 October 2024, Technology Magazine

provided by Google News

Winning the 2020 Google Cloud Technology Partner of the Year – Infrastructure Modernization Award
22 December 2021, CIO

Google Cloud partners Coinbase to accept crypto payments
11 October 2022, Ledger Insights

Hightouch Raises $38M in Funding
19 July 2023, FinSMEs

provided by Google News

Progress Introduces MarkLogic FastTrack, Helping Organizations Harness the Power of Connected Data
23 July 2024, GlobeNewswire

Database Platform to Simplify Complex Data | Progress Marklogic
7 February 2023, Progress Software

Progress Brings Industry Leaders Together to Share Insights on AI and Data at MarkLogic World Tour US 2024
18 September 2024, StockTitan

Progress Announces Powerful New Generative AI Capabilities in Latest Release of MarkLogic Server
5 September 2024, GlobeNewswire

Progress launches MarkLogic Server 12 with new AI capabilities
9 September 2024, IT Brief Australia

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

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

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here