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:
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

Relational DB Variants:
AlloyDB: Google – Postgres compatible
Amazon Aurora: Cloud based relational store – Compatible with MySQL and PostGres – 1 node but data storage is scaled and automatically replicated

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

Document DBs:
CouchDB:Apache – Stores documents as JSON – Uses HTTP for API
Firestore: Google document DB
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
Memcached: In-memory – Open Source
Redis: Open source
Riak: Open source – No Windows support

New SQL (Distributed ACID/SQL Databases)
Cockroach DB: Has distributed transactions
Spanner: Google – Uses TrueTime system (globally synchronized clock) – Doesn’t support DML statements
YugabyteDB: Forked from Postgres query layer

ArrangoDB: Hybrid Key/Value, Document and Graph DB
Cosmos DB: Microsoft Azure multi-model database system
Dynamo DB: Amazon – Document and Key/Value
FoundationDB: Open source, developed by Apple.
OrientDB: Hybrid Document-Graph DB – ACID and SQL
SingleStore: Distributed relational DB – Linux or Cloud – Hybrid transactional and analytical

Aerospike: In-memory NOSQL DB
Amazon QLDB: Quantum Ledger Database
Eloquera: .Net Object DB – Store C# objects
Influx DB: Time-series DB
ksqlDB: Event streaming DB
Marmotta: Apache – Platform for Linked Data (Semantic Web – Linked documents – URIs for object names)
Pinecone: Vector database
Snowflake: Cloud data warehouse
SQream: GPU Data Warehouse
TiDB: HTAP – Hybrid Transactional/Analytical Processing – Open Source – MySQL compatible

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 )

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