Relational Databases

In contrast to the Relational Model, a relational database is a practical implementation of the relational model. Also called RDBMS - Relational Database Management System.

It’s an actual database management system that uses the principles of the relational model to store and manage data. Examples include MySQL, PostgreSQL, and Oracle.

These databases use SQL for accessing and managing the data. They are built upon the theoretical framework of the relational model but include additional features like transaction management, concurrency control, and various optimizations for efficiency.

More Distributed Relational Databases.

• ACID Transactions: Atomicity, Consistency, Isolation, Durability
• Schema Enforcement: Structured data with defined relationships
• Referential Integrity: Foreign key constraints maintain data consistency
• Indexing: B-tree, hash, and other index types for query optimization
• Transaction Management: Support for concurrent operations
• Query Optimization: Cost-based and rule-based optimizers

Here a none-exhaustive list.

• Postgres: Advanced features, extensibility, strong standards compliance
• MySQL: Wide adoption before Postgres, good performance, MySQL/MariaDB ecosystem
• MariaDB: MySQL fork of MySQL a free, open-source version of the MySQL
• SQLite / libSQL: Single file database. Serverless, zero-configuration
• CockroachDB: Distributed SQL with strong consistency guarantees

• Oracle Database: Feature-rich enterprise solution with advanced analytics
• Microsoft SQL Server: Windows-centric with strong integration tools
• IBM DB2: Mainframe heritage with strong enterprise features
• SAP HANA: In-memory database with real-time analytics

Find the full list on DB-Engines Ranking - popularity ranking of database management systems.

OLAP, Cloud Data Warehouse, database management, and many more.

Database Comparisons (Postgres, SQLite, DuckDB)

• Build Your Own Database

Origin:
References:
Created 2024-01-05