https://r0tbyt3.dev/tags/database-fundamentals/Recent content in Database-Fundamentals on Jesus OsegueraHugoen-ushttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/acid/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/acid/ACID ACID - properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. Atomicity - a transaction is either completed or not at all. Consistency - a transaction must bring the database from one valid state to another. Isolation - concurrent transactions must not affect each other. Durability - once a transaction is committed, it must persist even in the event of a system failure. Atomicity Example Scenario Scenario: A transaction to transfer $100 from account A to account B fails due to a system failure.https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/cap-theorem/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/cap-theorem/CAP theorem CAP Theorem - principle stating distributed systems can guarantee only two of: Consistency, Availability, Partition tolerance. Consistency - all nodes see the same data at the same time. Availability - every request receives a response, without guarantee that it contains the most recent data. Partition tolerance - the system continues to operate despite arbitrary partitioning due to network failures. CAP Theorem Trade-offs Consistency and Partition tolerance (CP) - The system sacrifices availability to ensure data consistency during a network partition, often returning an error or time-out if data cannot be synced.https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-constraints/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-constraints/Data constraints Data Constraints - rules enforced at the database level to ensure data integrity and validity. Related Links: ACID CAP theorem Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-definition-language/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-definition-language/Data definition language Data Definition Language - SQL commands for defining and modifying database schema structures. Related Links: ACID CAP theorem Data constraints Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-integrity-and-normalization-and-security/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-integrity-and-normalization-and-security/Data integrity and normalization and security Data Integrity, Normalization, and Security - practices ensuring data correctness, minimal redundancy, and protection. Related Links: ACID CAP theorem Data constraints Data definition language Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-manipulation-language/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-manipulation-language/Data manipulation language Data Manipulation Language - SQL commands for querying and modifying data within tables. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/Database Fundamentals Database Fundamentals - core concepts underlying all database systems including transactions, ACID, normalization, and data modeling. ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levels Related Links: Database Performance Database Types SQLhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/databases-and-data-modeling/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/databases-and-data-modeling/Databases and Data Modeling Databases and Data Modeling - design principles for organizing and representing data in database systems. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/migrations/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/migrations/Migrations Migrations - version-controlled changes to database schema applied incrementally over time. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/normalization/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/normalization/Normalization Normalization - process of organizing database schema to reduce redundancy and improve data integrity. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/orms/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/orms/ORMs ORMs - libraries mapping database tables to object-oriented code for convenient database interaction. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions/Transactions Transactions - units of work in a database that must execute atomically to maintain consistency. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions-and-isolation-levels/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions-and-isolation-levels/Transactions and isolation levels Transactions and Isolation Levels - database transaction guarantees and concurrent access control levels. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions