# edusatyaki/dbms-youtube-video-sharing architecture

> Architecture diagram of the GitHub repository edusatyaki/dbms-youtube-video-sharing, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/edusatyaki/dbms-youtube-video-sharing
- Repository: https://github.com/edusatyaki/dbms-youtube-video-sharing

## Overview

This repository is a DBMS course project brief for rebuilding and optimizing a YouTube-style database, not a deployed sharing service. The intended workflow is to infer a schema from the supplied exports, load it into PostgreSQL, measure the prescribed workload, optimize without changing results, and test scale. The README documents major query domains and the benchmark script, but the tree contains no schema, loader, optimized queries, or reports yet; those are planned deliverables, not implemented components.

Main entry points: [`queries/workload_30.sql`](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/queries/workload_30.sql) (30-query workload), [`README.md`](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md) (Schema and loading), [`seed_data.zip`](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/seed_data.zip) (Seed exports), [`benchmarks/run_benchmark.sh`](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/benchmarks/run_benchmark.sh) (Benchmark runner)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Data inputs"]
  node_seed["Seed exports<br/>[seed_data.zip]"]
end

subgraph group_workload["Query performance"]
  node_queries["30-query workload<br/>[workload_30.sql]"]
  node_benchmark["Benchmark runner<br/>[run_benchmark.sh]"]
end

subgraph group_project["Project workflow"]
  node_schema["Schema and loading<br/>[README.md]"]
  node_optimization["Query optimization<br/>[README.md]"]
  node_scale["Scalability evaluation<br/>[README.md]"]
end

node_student(("Project team"))
node_postgres[("PostgreSQL")]

node_student -->|"uses as input"| node_seed
node_student -->|"derives and loads"| node_schema
node_seed -->|"informs schema"| node_schema
node_schema -->|"loads into"| node_postgres
node_student -->|"runs workload"| node_queries
node_queries -->|"timed by"| node_benchmark
node_benchmark -->|"measures queries"| node_postgres
node_student -->|"optimizes queries"| node_optimization
node_queries -->|"preserves results"| node_optimization
node_student -->|"tests growth"| node_scale
node_scale -->|"evaluates capacity"| node_postgres

click node_seed "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/seed_data.zip"
click node_schema "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md"
click node_queries "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/queries/workload_30.sql"
click node_benchmark "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/benchmarks/run_benchmark.sh"
click node_optimization "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md"
click node_scale "https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_seed toneBlue
class node_queries,node_benchmark,node_postgres toneAmber
class node_schema,node_optimization,node_scale toneMint
class node_student toneIndigo
```

## Components

### Data inputs

- [Seed exports](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/seed_data.zip): `seed_data.zip`

### Query performance

- [30-query workload](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/queries/workload_30.sql): `queries/workload_30.sql`
- [Benchmark runner](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/benchmarks/run_benchmark.sh): `benchmarks/run_benchmark.sh`

### Project workflow

- [Schema and loading](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md): `README.md`
- [Query optimization](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md): `README.md`
- [Scalability evaluation](https://github.com/edusatyaki/dbms-youtube-video-sharing/blob/main/README.md): `README.md`

### Other components

- **Project team**
- **PostgreSQL**

## Connections

- Project team → Seed exports: uses as input (evidence: `README.md`)
- Project team → Schema and loading: derives and loads (evidence: `README.md`)
- Seed exports → Schema and loading: informs schema (evidence: `README.md`)
- Schema and loading → PostgreSQL: loads into (evidence: `README.md`)
- Project team → 30-query workload: runs workload (evidence: `README.md`)
- 30-query workload → Benchmark runner: timed by (evidence: `README.md`)
- Benchmark runner → PostgreSQL: measures queries (evidence: `README.md`)
- Project team → Query optimization: optimizes queries (evidence: `README.md`)
- 30-query workload → Query optimization: preserves results (evidence: `README.md`)
- Project team → Scalability evaluation: tests growth (evidence: `README.md`)
- Scalability evaluation → PostgreSQL: evaluates capacity (evidence: `README.md`)
