SQL Server and other database technologies

Database Systems

DB-Engines Rankings. A list ranking the popularity of database systems.

Data Science Laboratory System A page I put up that runs through some of these database systems.

Relational DBs:
Amazon Aurora: Cloud based relational store – Compatible with MySQL and PostGres – 1 node but data storage is scaled and automatically replicated
Citus: PostGres as a distributed service
HyperSQL: 100% Java
MariaDB: “Drop-in” replacement for MySQL – Led by original MySQL developers after MySQL was acquired by Oracle.
Percona Server: MySQL replacement

Column Family DBs
Cassandra: Apache – Developed at Facebook
HBase: Apache Hadoop

Document DBs:
CouchDB:Apache – Stores documents as JSON – Uses HTTP for API
MongoDB: Stores documents as binary JSON
RavenDB: Document DB for .Net
RethinkDB: Open source – Distributed JSON document DB – Supports joins – Can push query results out to application – Part of the Linux Foundation as of 2/2017

Graph DBs

Key/Value Stores
Redis: Open source
Riak: Open source – No Windows support

New SQL (Distributed ACID/SQL Databases)
Cockroach DB: Has distributed transactions
MemSQL: Distributed in-memory database on Linux
Spanner: Google – Uses TrueTime system (globally synchronized clock) – Doesn’t support DML statements

Cosmos DB: Microsoft Azure multi-model database system
Eloquera: .Net Object DB – Store C# objects
Marmotta: Apache – Platform for Linked Data (Semantic Web – Linked documents – URIs for object names)
OrientDB: Hybrid Document-Graph DB – ACID and SQL
ArrangoDB: Hybrid Key/Value, Document and Graph DB
TempoIQ (formally TempoDB): Time series DB (timestamp/value pairs – Collect values over a period of time)
Snowflake: Cloud data warehouse
Amazon QLDB: Quantum Ledger Database
SQream: GPU Data Warehouse

One thought on “Database Systems

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s