Which Database?
Database Benchmarks
What NOT to Store in a Relational Database
Files
https://yourlabs.org/posts/2019-04-19-storing-hd-photos-in-a-relational-database-recipe-for-an-epic-fail/https://softwareengineering.stackexchange.com/questions/150669/is-it-a-bad-practice-to-store-large-files-10-mb-in-a-databasehttps://www.brentozar.com/archive/2021/07/store-files-in-a-file-system-not-a-relational-database/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
MySQL vs Percona
https://www.percona.com/doc/percona-server/LATEST/feature_comparison.html https://pandorafms.com/blog/percona/https://en.wikipedia.org/wiki/PerconaMySQL vs MariaDB
https://kinsta.com/blog/mariadb-vs-mysql/MySQL vs PostgreSQL
https://towardsdatascience.com/mysql-vs-postgresql-3d48891452aMySQL vs Oracle
https://docs.oracle.com/cd/E10405_01/appdev.120/e10380/oracle_mysql_compared.htm#CHDIIBJHhttps://hevodata.com/learn/mysql-vs-oracle/
MSSQL
MSSQL Editions
Enterprise Edition
Standard Edition
Developer Edition
Express Edition
Compact Edition - this is the Microsoft equivalent of SQLite - it is free to distribute and use.
https://en.wikipedia.org/wiki/SQL_Server_Compact
MSSQL Compact Edition vs SQLite
https://stackoverflow.com/questions/6744470/choosing-between-sql-server-express-and-sql-lite
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
Database / Data Warehouse / Data Lake
https://venturebeat.com/2021/04/28/understanding-when-to-use-a-database-data-lake-or-data-warehouse/
A Data Warehouse tends to be a large database designed to hold a collection of data sourced from multiple source databases.
A Data Lake is similar but tends to hold the data in a less structured format (e.g. flat files instead of relational tables).
Oracle Autonomous Data Warehouse
https://www.oracle.com/news/connect/oracle-autonomous-data-warehouse-and-snowflake.html
Snowflake
An elastic near-zero maintenance data warehouse platform across any cloud.
The company was set up by ex Oracle employees and is currently generating a lot of buzz.
https://en.wikipedia.org/wiki/Snowflake_Inc.https://www.snowflake.com/ https://docs.snowflake.net/manuals/user-guide/intro-key-concepts.html#snowflake-architecturehttps://quickstarts.snowflake.com/guide/getting_started_with_snowflake/index.htmlhttps://medium.com/hashmapinc/snowflakes-cloud-data-warehouse-what-i-learned-and-why-i-m-rethinking-the-data-warehouse
Oracle Autonomous Data Warehouse vs Snowflakehttps://www.oracle.com/news/connect/oracle-autonomous-data-warehouse-and-snowflake.html
SQL vs NoSQL
https://blog.dbi-services.com/the-myth-of-nosql-vs-rdbms-joins-dont-scale/https://www.zdnet.com/article/sql-nosql-whats-the-difference-these-days/ (2014)https://www.kdnuggets.com/2021/05/nosql-know-it-all-compendium.htmlhttps://hostingdata.co.uk/nosql-database/https://blog.nelhage.com/post/some-opinionated-sql-takes/https://www.datanami.com/anniversary_channel/2014-nosql-has-its-day/https://www.reddit.com/r/Database/comments/129uo2k/there_seems_to_be_an_antirdbms_cult_out_there/https://www.ml4devs.com/articles/datastore-choices-sql-vs-nosql-database/
Column-Oriented Databases
https://www.kdnuggets.com/2021/02/understanding-nosql-database-types-column-oriented-databases.htmlProducts
Cassandra
CosmosDB (via Cassandra API)
Graph Databases
https://www.kdnuggets.com/2021/02/understanding-nosql-database-types-graph.htmlProducts
FlockDB
Neo4j
RedisGraph
OrientDB
CosmosDB (via Gremlin API)
SQLite vs MSSQL Compact Edition
https://stackoverflow.com/questions/6744470/choosing-between-sql-server-express-and-sql-lite
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
Related Concepts
JSON
Use Cases
Large eCommerce platforms (Like Amazon)
Blogging sites (such as Twitter)
Content management systems (WordPress, windows registry)
Analytical platforms
Products
MongoDB
Elasticsearch
CouchDB
BaseX
MySQL Enterprise Edition
Oracle
Key-Value Databases
https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.htmlUse Cases
User preferences and profile stores
Large scale session management for users
Product recommendations (such as in eCommerce platforms)
Customized ad delivery to users based on their data profile
Data cache for rarely updated data
Products
Amazon DynamoDB
Aerospike
Berkeley DB
Couchbase
Memcached
Riak
Redis
DynamoDB
Aerospike
Redis
DuckDB
Bibliography
https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htmhttps://docs.oracle.com/cd/E10405_01/appdev.120/e10380/oracle_mysql_compared.htm#CHDIIBJHhttps://blogs.oracle.com/database/oracle-databases-top-db-engines-rankinghttps://db-engines.com/en/ranking_trendhttps://www.percona.com/open-source-data-management-software-surveyhttps://pingcap.com/blog/how-to-efficiently-choose-the-right-database-for-your-applications
2020https://a16z.com/2020/10/15/the-emerging-architectures-for-modern-data-infrastructure/https://insights.stackoverflow.com/survey/2020#technology-databaseshttps://insights.stackoverflow.com/survey/2020#technology-most-loved-dreaded-and-wanted-databases
oracle vs mssqlhttps://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htmhttps://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 vs mariadb vs postgreSQLhttps://www.theregister.com/2021/12/06/mysql_a_pretty_poor_database/
mssql vs postgreSQLhttps://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences
database / data warehouse / data lakehttps://venturebeat.com/business/understanding-when-to-use-a-database-data-lake-or-data-warehouse/