How edusatyaki/dbms-youtube-video-sharing works
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: workload_30.sql 30-query workload · README.md Schema and loading · seed_data.zip Seed exports · run_benchmark.sh Benchmark runner
Components 8
Data inputs
- Seed exports
seed_data.zip
Query performance
- 30-query workload
queries/workload_30.sql - Benchmark runner
benchmarks/run_benchmark.sh
Project workflow
- Schema and loading
README.md - Query optimization
README.md - Scalability evaluation
README.md
Other components
- Project team
- PostgreSQL
Connections 11
- Project team → Seed exports: uses as input
README.md - Project team → Schema and loading: derives and loads
README.md - Seed exports → Schema and loading: informs schema
README.md - Schema and loading → PostgreSQL: loads into
README.md - Project team → 30-query workload: runs workload
README.md - 30-query workload → Benchmark runner: timed by
README.md - Benchmark runner → PostgreSQL: measures queries
README.md - Project team → Query optimization: optimizes queries
README.md - 30-query workload → Query optimization: preserves results
README.md - Project team → Scalability evaluation: tests growth
README.md - Scalability evaluation → PostgreSQL: evaluates capacity
README.md