Skip to main content

Reference and Selective Reading

This generated surface maps a learner-facing curriculum unit to its canonical source routes.

Curriculum surface​

  • Open learner-facing unit
  • Curriculum path: content/curriculum/architecture/semester-06-databases-distributed/module-01-relational-databases-sql/reference/index.md
  • App: architecture
  • Semester: semester-06-databases-distributed
  • Module: module-01-relational-databases-sql
  • Unit kind: reference
  • Curation level: module_curated

Learning objectives​

  • Explain Reference and Selective Reading using the language of schema, constraints, query semantics, and tradeoffs instead of isolated SQL syntax.
  • Connect the learner-facing explanation of Reference and Selective Reading to real database behavior you can inspect in a running system or reason about from execution plans.
  • Use database-internals, database-system-concepts, ddia to tie relational ideas back to formal models, practical query behavior, and design decisions.

Prerequisites​

  • Comfort with sets, functions, and the idea of data modeling from earlier semesters.

Source books​

  • database-internals
  • database-system-concepts
  • ddia

Source routes​

Database Internals​

  • /books/database-internals via Database Internals: Chapter 5 - Transaction processing and recovery, Database Internals: Chapter 5 – Transaction processing and recovery

Database System Concepts​

  • /books/database-system-concepts via Silberschatz: A simple transaction model (17.2), Silberschatz: Additional basic operations, part 1, Silberschatz: Additional basic operations, part 2, Silberschatz: Aggregate functions, part 1, Silberschatz: Aggregate functions, part 2, Silberschatz: Algorithms for decomposition, part 1, Silberschatz: Basic structure of SQL queries, part 1, Silberschatz: Basic structure of SQL queries, part 2, Silberschatz: Choice of evaluation plans, part 1, Silberschatz: Database schema, Silberschatz: Decomposition using FDs, part 1, Silberschatz: Decomposition using FDs, part 2, Silberschatz: ER design issues, Silberschatz: Estimating statistics of expression results, part 1, Silberschatz: Extended ER features, part 1, Silberschatz: FD theory, part 1, Silberschatz: Features of good relational designs, Silberschatz: Functions and procedures, part 1, Silberschatz: Index definition in SQL, Silberschatz: Integrity constraints, part 1, Silberschatz: Integrity constraints, part 2, Silberschatz: Integrity constraints, part 3, Silberschatz: Join expressions, part 1, Silberschatz: Join expressions, part 2, Silberschatz: Join expressions, part 3, Silberschatz: Join expressions, part 4, Silberschatz: Join operation, part 1, Silberschatz: Join operation, part 2, Silberschatz: Keys, Silberschatz: Materialized views, part 1, Silberschatz: Materialized views, part 2, Silberschatz: Measures of query cost, part 1, Silberschatz: Measures of query cost, part 2, Silberschatz: Modification of the database, part 1, Silberschatz: More normal forms (4NF, BCNF nuances), Silberschatz: Nested subqueries, part 1, Silberschatz: Nested subqueries, part 2, Silberschatz: Nested subqueries, part 3, Silberschatz: Normal forms, part 1, Silberschatz: Normal forms, part 2, Silberschatz: Normal forms, part 3, Silberschatz: Null values, Silberschatz: Part six - query processing and optimization, Silberschatz: Part six – query processing and optimization, Silberschatz: Reducing ER diagrams to relational schemas, part 1, Silberschatz: Reducing ER diagrams to relational schemas, part 2, Silberschatz: Reducing ER diagrams to relational schemas, part 3, Silberschatz: Relational algebra, part 1, Silberschatz: Relational algebra, part 2, Silberschatz: Relational algebra, part 3, Silberschatz: Relational algebra, part 4, Silberschatz: SQL data definition, Silberschatz: SQL data types and schemas, part 1, Silberschatz: Schema diagrams, Silberschatz: Selection operation, part 1, Silberschatz: Set operations, Silberschatz: Structure of relational databases, Silberschatz: Transaction atomicity and durability (17.4), Silberschatz: Transaction concept (17.1), Silberschatz: Transaction isolation (17.5), Silberschatz: Transaction isolation and atomicity (17.7), Silberschatz: Transaction isolation levels (17.8), Silberschatz: Transactions as SQL statements (17.10), Silberschatz: Transformation of relational expressions, part 1, Silberschatz: Triggers, part 1, Silberschatz: Views, part 1, Silberschatz: Views, part 2
  • /books/database-system-concepts/chapter-26-blockchain-databases via Silberschatz: Query processing overview (15.1)

Ddia​

Supporting curriculum routes​

No supporting curriculum routes linked yet.

External enrichment​

  • PostgreSQL Documentation: Table Expressions (official_docs_companion) - Anchors relational and query-structure ideas in an authoritative database reference learners can revisit later.
  • PostgreSQL Tutorial (read_if_stuck) - Provides runnable examples that help convert the relational model from vocabulary into working intuition.

AI companion modes​

  • Explain simply
  • Diagnose my confusion
  • Revision mode
  • Connect forward / backward

Source-of-truth note​

This teaching unit is learner-facing guidance assembled from multiple canonical book routes. Use the listed source books as the primary conceptual spine for Reference and Selective Reading, and treat outside material as supporting enrichment only.