# edusatyaki/dbms-google-maps-navigation architecture

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

- Interactive diagram: https://gitdiagram.com/edusatyaki/dbms-google-maps-navigation
- Repository: https://github.com/edusatyaki/dbms-google-maps-navigation

## Overview

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: [`queries/workload_30.sql`](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/queries/workload_30.sql) (30-query workload), [`benchmarks/run_benchmark.sh`](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/benchmarks/run_benchmark.sh) (Benchmark runner), [`seed_data.zip`](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/seed_data.zip) (Seed exports)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data Foundation"]
  node_seed["Seed exports<br/>[seed_data.zip]"]
  node_schema["Schema and load"]
end

subgraph group_queries["Query Workload"]
  node_workload["30-query workload<br/>[workload_30.sql]"]
end

subgraph group_evaluation["Performance Evaluation"]
  node_baseline["Baseline timings"]
  node_benchmark["Benchmark runner<br/>[run_benchmark.sh]"]
  node_optimization["Query optimization"]
  node_scalability["Large-data test"]
end

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

node_student -->|"designs and loads"| node_schema
node_seed -->|"provides input"| node_schema
node_schema -->|"loads schema and data"| node_postgres
node_student -->|"runs queries"| node_workload
node_workload -->|"executes against"| node_postgres
node_benchmark -->|"times queries"| node_workload
node_benchmark -->|"records timings"| node_baseline
node_student -->|"optimizes queries"| node_optimization
node_optimization -->|"evaluates changes on"| node_postgres
node_student -->|"tests at scale"| node_scalability

click node_seed "https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/seed_data.zip"
click node_workload "https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/queries/workload_30.sql"
click node_benchmark "https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/benchmarks/run_benchmark.sh"

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,node_schema toneBlue
class node_workload,node_postgres toneAmber
class node_baseline,node_benchmark,node_optimization,node_scalability toneMint
class node_student toneIndigo
```

## Components

### Data Foundation

- [Seed exports](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/seed_data.zip): `seed_data.zip`
- **Schema and load**

### Query Workload

- [30-query workload](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/queries/workload_30.sql): `queries/workload_30.sql`

### Performance Evaluation

- **Baseline timings**
- [Benchmark runner](https://github.com/edusatyaki/dbms-google-maps-navigation/blob/main/benchmarks/run_benchmark.sh): `benchmarks/run_benchmark.sh`
- **Query optimization**
- **Large-data test**

### Other components

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

## Connections

- Project team → Schema and load: designs and loads (evidence: `README.md`)
- Seed exports → Schema and load: provides input (evidence: `README.md`)
- Schema and load → PostgreSQL: loads schema and data (evidence: `README.md`)
- Project team → 30-query workload: runs queries (evidence: `README.md`)
- 30-query workload → PostgreSQL: executes against (evidence: `README.md`)
- Benchmark runner → 30-query workload: times queries (evidence: `README.md`)
- Benchmark runner → Baseline timings: records timings (evidence: `README.md`)
- Project team → Query optimization: optimizes queries (evidence: `README.md`)
- Query optimization → PostgreSQL: evaluates changes on (evidence: `README.md`)
- Project team → Large-data test: tests at scale (evidence: `README.md`)