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 > Cassandra vs. Datastax Enterprise vs. Microsoft Access vs. Riak KV

System Properties Comparison Cassandra vs. Datastax Enterprise vs. Microsoft Access vs. Riak KV

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCassandra  Xexclude from comparisonDatastax Enterprise  Xexclude from comparisonMicrosoft Access  Xexclude from comparisonRiak KV  Xexclude from comparison
DescriptionWide-column store based on ideas of BigTable and DynamoDB infoOptimized for write accessDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.Microsoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)Distributed, fault tolerant key-value store
Primary database modelWide column storeWide column storeRelational DBMSKey-value store infowith links between data sets and object tags for the creation of secondary indexes
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Search engine
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score123.55
Rank#11  Overall
#1  Wide column stores
Score9.89
Rank#48  Overall
#4  Wide column stores
Score128.95
Rank#9  Overall
#6  Relational DBMS
Score6.09
Rank#64  Overall
#7  Key-value stores
Websitecassandra.apache.orgwww.datastax.com/­products/­datastax-enterprisewww.microsoft.com/­en-us/­microsoft-365/­accessriak.com/­products/­riak-kv
Technical documentationcassandra.apache.org/­doc/­latestdocs.datastax.comdeveloper.microsoft.com/­en-us/­access
DeveloperApache Software Foundation infoApache top level project, originally developped by FacebookDataStaxMicrosoftBasho Technologies
Initial release2008201119922009
Current release4.0.1, September 20216.8, April 20201902 (16.0.11328.20222), March 20192.1.0, April 2015
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercial infoBundled with Microsoft OfficeOpen Source infoApache version 2, commercial enterprise edition
Cloud-based only infoOnly available as a cloud servicenononono
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 languageJavaJavaC++Erlang
Server operating systemsBSD
Linux
OS X
Windows
Linux
OS X
Windows infoNot a real database server, but making use of DLLsLinux
OS X
Data schemeschema-freeschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesyesno
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 indexesrestricted infoonly equality queries, not always the best performing solutionyesyesrestricted
SQL infoSupport of SQLSQL-like SELECT, DML and DDL statements (CQL)SQL-like DML and DDL statements (CQL); Spark SQLyes infobut not compliant to any SQL standardno
APIs and other access methodsProprietary protocol infoCQL (Cassandra Query Language, an SQL-like language)
Thrift
Proprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
ADO.NET
DAO
ODBC
OLE DB
HTTP API
Native Erlang Interface
Supported programming languagesC#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
C
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
C infounofficial client library
C#
C++ infounofficial client library
Clojure infounofficial client library
Dart infounofficial client library
Erlang
Go infounofficial client library
Groovy infounofficial client library
Haskell infounofficial client library
Java
JavaScript infounofficial client library
Lisp infounofficial client library
Perl infounofficial client library
PHP
Python
Ruby
Scala infounofficial client library
Smalltalk infounofficial client library
Server-side scripts infoStored proceduresnonoyes infosince Access 2010 using the ACE-engineJavaScript and Erlang
Triggersyesyesyes infosince Access 2010 using the ACE-engineyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesSharding infono "single point of failure"Sharding infono "single point of failure"noneSharding infono "single point of failure"
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infoRepresentation of geographical distribution of servers is possibleconfigurable replication factor, datacenter aware, advanced replication for edge computingnoneselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesyesnoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Immediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Eventual Consistency
Foreign keys infoReferential integritynonoyesno infolinks between data sets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoAtomicity and isolation are supported for single operationsno infoAtomicity and isolation are supported for single operationsACID infobut no files for transaction loggingno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infobut no files for transaction loggingyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlAccess rights for users can be defined per objectAccess rights for users can be defined per objectno infoa simple user-level security was built in till version Access 2003no
More information provided by the system vendor
CassandraDatastax EnterpriseMicrosoft AccessRiak KV
Specific characteristicsApache Cassandra is the leading NoSQL, distributed database management system, well...
» more
DataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Competitive advantagesNo single point of failure ensures 100% availability . Operational simplicity for...
» more
Supporting the following application requirements: Zero downtime - Built on Apache...
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
Applications that must be massively and linearly scalable with 100% uptime and able...
» more
Key customersApple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...
» more
Capital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Market metricsCassandra is used by 40% of the Fortune 100.
» more
Among the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
Licensing and pricing modelsApache license  Pricing for commercial distributions provided by DataStax and available...
» more
Annual subscription
» 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 partiesDataStax Enterprise: Apache Cassandra for enterprises.
» more

Instaclustr: Hosted & Managed Apache Cassandra as a Service
» 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
CassandraDatastax EnterpriseMicrosoft AccessRiak KV
DB-Engines blog posts

Cassandra keeps climbing the ranks of the DB-Engines Ranking
3 May 2016, Matthias Gelbmann

Oracle is the DBMS of the Year
5 January 2016, Paul Andlinger, Matthias Gelbmann

Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
2 November 2015, Paul Andlinger

show all

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Google scales up Cloud Bigtable NoSQL database
27 January 2022, TechTarget

DataStax gRPC API for Cassandra Boosts Multi-Cloud, Microservices App Performance
14 January 2022, Integration Developers

NoSQL Databases are the Problem, Not the Solution
3 January 2022, Walter Bradley Center for Natural and Artificial Intelligence

NoSQL database types explained: Graph
30 December 2021, TechTarget

“We are the CIO’s secret weapon”
13 January 2022, The Stack

provided by Google News

“We are the CIO’s secret weapon”
13 January 2022, The Stack

DataStax Shows Strong Momentum with New Customers, Partners and Products
26 May 2021, Business Wire

DataStax Further Expands in Asia-Pacific with New Office and General Manager in China
3 November 2021, Business Wire

DataStax Q2 Marked by Strong Growth with Leading Enterprises Including Barracuda Networks and Priceline
31 August 2021, Business Wire

DataStax Accelerates Global Growth in Q3 with New Customers Including GrubHub, M&T Bank and Axway and Strong Demand for its Serverless Cloud Database, Astra DB
29 November 2021, Business Wire

provided by Google News

Uses for Cartesian Products in MS Access
18 September 2009, Database Journal

Top 10 Productivity Tips for Microsoft Access 2010
26 August 2010, Database Journal

The 12 Best Features of Microsoft Access for Database Management - MUO
9 December 2021, MakeUseOf

Needle in the Haystack: New Exomoon Candidate Found
14 January 2022, SkyandTelescope.com

MS Access and MySQL
15 September 2008, Database Journal

provided by Google News

Is Riak A Good NoSQL Database Option?
1 July 2019, Analytics India Magazine

Riak NoSQL Database: Use Cases and Best Practices
23 December 2011, InfoQ.com

​Basho's Riak 2.1 database zooms in on better write speeds
8 April 2015, ZDNet

Basho rolls out open source version of its Riak TS database
5 May 2016, ZDNet

Basho Revamps Riak Open-Source Database
17 September 2014, InformationWeek

provided by Google News

Job opportunities

Cassandra Database Administrator
Ping Identity, Austin, TX

Database Administrator - DBA
iSpeech, Newark, NJ

Junior API Developer
Synchrony Financial, Stamford, CT

Principal Database Administrator - Cassandra/MongoDB
OnSolve, LLC, Alpharetta, GA

Database Administrator
PMG Global, Herndon, VA

Marketing Operations (Remote US)
DataStax, San Francisco Bay Area, CA

Datastax Engineer
M&T Bank, Buffalo, NY

DataStax Architect (Cassandra) | REMOTE JOB
iknowvate technologies, Collierville, TN

Digital Marketing Leader (Remote US)
DataStax, San Francisco Bay Area, CA

Enterprise Customer Success Manager (Remote US)
DataStax, San Francisco Bay Area, CA

Data Entry Operator - AEP
HealthAxis Group, United States

Compilation Associate, POI
Data Axle, Dallas, TX

MS Access Developer
American Tradeshow Services, Mandeville, LA

RAPID APPLICATION DEVELOPER (MS ACCESS/EXCEL VBA )
Talan, New York, NY

MS Access/VBA Developer
Tetra Tech, Pittsburgh, PA

Software Developer
Soothsayer Analytics, Lansing, MI

Cloud Support Engineer I - Databases
Amazon Web Services, Inc., Remote

Cybersecurity Analyst
Visa, Austin, TX

Senior MySQL Database Administrator
Scientific Games, Georgia

JPC - 434 - Backend Engineer
Promantis Inc, New York, NY

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

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.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here