Which Database?

Database Benchmarks

Oracle

Oracle vs MSSQL 

See https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm for a good description of some of the key differences between Oracle and MS-SQL when considering porting an application from one to the other. Pay particular attention to the differences in Locking and Transaction Handling.


https://www.oracle.com/technetwork/database/availability/ha-oracle12c-sqlserver2012-2049933.pdf https://joeydantoni.com/2012/03/29/alwayson-versus-active-data-guard-a-value-proposition/ 

MySQL

MSSQL

 MSSQL Editions

In February 2013, Microsoft announced that SQL Server Compact Edition had been deprecated.Although no new versions or updates are planned, Microsoft will continue to support SQL Compact through their standard lifecycle support policy. This support will end in July 2021.
https://en.wikipedia.org/wiki/SQL_Server_Compact

MSSQL on Cloud Platforms

MSSQL vs Oracle

See https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm for a good description of some of the key differences between Oracle and MS-SQL when considering porting an application from one to the other. Pay particular attention to the differences in Locking and Transaction Handling.


https://www.oracle.com/technetwork/database/availability/ha-oracle12c-sqlserver2012-2049933.pdf https://joeydantoni.com/2012/03/29/alwayson-versus-active-data-guard-a-value-proposition/ 

PostgreSQL

Progress

Multi-Mode Databases

Databases that can be more than one of Column-Oriented, Graph, Key Value Store, Document or Relational.

Products

Graph Databases

https://www.kdnuggets.com/2021/02/understanding-nosql-database-types-graph.html

Products

Apache Derby


Apache Derby (formerly IBM Cloudscape) is a small footprint RDBMS that can be embedded in Java programs and used for online transaction processing. It supports JDBC and IBM DB2 SQL syntax. 


https://en.wikipedia.org/wiki/Apache_Derbyhttps://db.apache.org/derby/

Berkeley DB

Oracle Berkeley DB is a family of embedded key-value database libraries.


https://www.oracle.com/database/technologies/related/berkeleydb.html

Immutable Databases/Blockchain

Distributed Databases

Document Databases

https://www.kdnuggets.com/2021/03/understanding-nosql-database-types-document.html

Related Concepts

Use Cases

Products

Key-Value Databases

https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.html

Use Cases

Products

DynamoDB

Aerospike

Redis

Valkey

Forked from Redis

DuckDB

DuckDB is an in-process SQL OLAP database management system


https://duckdb.org/

Bibliography