Embedded Files
Database Benchmarks
Database Benchmarks
What NOT to Store in a Relational Database
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
Oracle vs MSSQL
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
https://www.mysql.com/why-mysql/white-papers
https://www.percona.com/doc/percona-server/LATEST/feature_comparison.html https://pandorafms.com/blog/percona/https://en.wikipedia.org/wiki/Percona
https://kinsta.com/blog/mariadb-vs-mysql/
https://towardsdatascience.com/mysql-vs-postgresql-3d48891452ahttps://medium.com/@hnasr/postgres-vs-mysql-5fa3c588a94e
https://docs.oracle.com/cd/E10405_01/appdev.120/e10380/oracle_mysql_compared.htm#CHDIIBJHhttps://hevodata.com/learn/mysql-vs-oracle/
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 Percona
MySQL vs MariaDB
https://kinsta.com/blog/mariadb-vs-mysql/MySQL vs MariaDB
MySQL vs PostgreSQL
https://towardsdatascience.com/mysql-vs-postgresql-3d48891452ahttps://medium.com/@hnasr/postgres-vs-mysql-5fa3c588a94eMySQL vs PostgreSQL
MySQL vs Oracle
MySQL 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
MSSQL Editions
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
MSSQL Compact Edition vs SQLite
https://stackoverflow.com/questions/6744470/choosing-between-sql-server-express-and-sql-lite
MSSQL on Cloud Platforms
MSSQL on Cloud Platforms
MSSQL vs Oracle
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
PostgreSQL
Progress
Progress
https://en.wikipedia.org/wiki/Progress_Softwarehttps://www.complexsql.com/progress-database/https://www.complexsql.com/progress-database-sql__trashed/https://www.progress.com/videohttps://www.progress.com/openedgehttps://docs.progress.com/bundle/openedge-database-introduction/page/Database-administrator-role.html
Database / Data Warehouse / Data Lake
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
Oracle Autonomous Data Warehouse
https://www.oracle.com/news/connect/oracle-autonomous-data-warehouse-and-snowflake.html
Snowflake
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
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/https://medium.com/@martin.hodges/how-i-choose-between-sql-and-no-sql-solutions-63463b6e65b9
Column-Oriented Databases
https://www.kdnuggets.com/2021/02/understanding-nosql-database-types-column-oriented-databases.htmlColumn-Oriented Databases
Products
Products
Cassandra
CosmosDB (via Cassandra API)
Graph Databases
https://www.kdnuggets.com/2021/02/understanding-nosql-database-types-graph.htmlGraph Databases
Products
Products
FlockDB
Neo4j
RedisGraph
OrientDB
CosmosDB (via Gremlin API)
SQLite vs MSSQL Compact Edition
SQLite vs MSSQL Compact Edition
https://stackoverflow.com/questions/6744470/choosing-between-sql-server-express-and-sql-lite
Apache Derby
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
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
Immutable Databases/Blockchain
Distributed Databases
Distributed Databases
Document Databases
Document Databases
https://www.kdnuggets.com/2021/03/understanding-nosql-database-types-document.html
Related Concepts
Related Concepts
JSON
Use Cases
Use Cases
Large eCommerce platforms (Like Amazon)
Blogging sites (such as Twitter)
Content management systems (WordPress, windows registry)
Analytical platforms
Products
Products
MongoDB
Elasticsearch
CouchDB
BaseX
MySQL Enterprise Edition
Oracle
Key-Value Databases
https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.htmlKey-Value Databases
Use Cases
Use 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
Products
Amazon DynamoDB
Aerospike
Berkeley DB
Couchbase
Memcached
Riak
Redis
Valkey
DynamoDB
DynamoDB
Aerospike
Aerospike
Redis
Redis
Valkey
Forked from RedisValkey
DuckDB
DuckDB
Bibliography
Bibliography
https://db-engines.com/en/ranking_trendhttps://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
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/
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/
Page updated
Google Sites
Report abuse