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: Each data point is time-versioned – Tables segmented into tablets
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
RocksDB: Fork of Google’s LevelDB – Developed at Facebook – Embedded DB – Optimized for Flash and RAM storage

New SQL (Distributed ACID/SQL Databases)
Cockroach DB: Has distributed transactions – Can be used with Postgres DB drivers – Post On CockroachDB
Planet Scale: MySQL compatible – Uses Vitess (Horizontal MySQL scaling)
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
Couchbase: Company from Membase/CouchOne merger.
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
SQLite: Embedded relational database – Post On SQLite
TileDB: Universal Database – Stores data in Multi-dimensional arrays
Timescale: Time-Series on Postgres

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 )

Facebook photo

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

Connecting to %s