How edusatyaki/dbms-google-maps-navigation works
This repository is a course project brief for rebuilding and optimizing a PostgreSQL navigation database, not a completed application. Its documented workflow is to derive and load a schema from seed exports, run the supplied 30-query workload, measure a baseline, optimize without changing results, and test scalability. The tree contains the seed archive, workload SQL, and benchmark script, but not the planned schema, load, optimization, or report artifacts. Relationships below follow the README; no source excerpts were available.
Main entry points: workload_30.sql 30-query workload · run_benchmark.sh Benchmark runner · seed_data.zip Seed exports
Components 9
Data Foundation
- Seed exports
seed_data.zip - Schema and load
Query Workload
- 30-query workload
queries/workload_30.sql
Performance Evaluation
- Baseline timings
- Benchmark runner
benchmarks/run_benchmark.sh - Query optimization
- Large-data test
Other components
- Project team
- PostgreSQL
Connections 10
- Project team → Schema and load: designs and loads
README.md - Seed exports → Schema and load: provides input
README.md - Schema and load → PostgreSQL: loads schema and data
README.md - Project team → 30-query workload: runs queries
README.md - 30-query workload → PostgreSQL: executes against
README.md - Benchmark runner → 30-query workload: times queries
README.md - Benchmark runner → Baseline timings: records timings
README.md - Project team → Query optimization: optimizes queries
README.md - Query optimization → PostgreSQL: evaluates changes on
README.md - Project team → Large-data test: tests at scale
README.md