---
date: '2024-09-04'
description: database management systems covering relational model, entity-relationship model, views, indexes, constraints, and relational algebra.
id: DBMS
modified: 2026-06-05 15:08:42 GMT-04:00
tags:
  - sfwr3db3
  - university
title: DBMS
created: '2024-09-04'
published: '2024-09-04'
pageLayout: default
slug: thoughts/university/twenty-four-twenty-five/sfwr-3db3/DBMS
permalink: https://aarnphm.xyz/thoughts/university/twenty-four-twenty-five/sfwr-3db3/DBMS.md
generator:
  quartz: v4.6.0
  hostedProvider: Cloudflare
  baseUrl: aarnphm.xyz
full: https://aarnphm.xyz/llms-full.txt
---
Book: Database Management System [ISBN-13:978-0072465631](https://www.amazon.ca/Database-Management-Systems-Raghu-Ramakrishnan/dp/0072465638), or [[thoughts/university/twenty-four-twenty-five/sfwr-3db3/Ramakrishnan - Database Management Systems 3rd Edition.pdf|pdf]]

> \[!tip\] Midterm
>
> Thurs Oct.24 2024 (during lecture time)

Due at 2200, late penalty of 20% per 24h, max 5 days.

```bash
ssh se3db3
```

Relational Model, E-R Model, Views, Indexes, Constraints, Relational Algebra

- 2.5 exabytes of [[thoughts/data|data]] per day.

## [[thoughts/Search|search]] vs. query

- indexed keyword

- [[thoughts/PageRank]]

- data independence

- fault tolerant

- concurrency control for transactions

- reliable storage to maintain semantics

## independence

- logical: protection from changes in _logical_ structure
- physical: protection from changes in _physical_ structure