# mateussilvams056-gif/f1-data-extraction-and-data-analysis architecture

> Architecture diagram of the GitHub repository mateussilvams056-gif/f1-data-extraction-and-data-analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis
- Repository: https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis

## Overview

This repository analyzes Formula 1 session data, focused on the 2023 Japan GP, and supports follow-up SQL analysis. The documented workflow is to launch the containerized processor, retrieve session data with FastF1, clean and derive lap and tyre metrics, then produce a CSV and positions graph; the README also says assets are pushed to MinIO. Separate SQL files support focused analysis, with MySQL described as the relational database. No source excerpts were provided, so relationships below rely on README statements; individual notebook operations and SQL-to-output mappings are not inferred.

Main entry points: [`f1.ipynb`](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1.ipynb) (Session processing), [`docker-compose.yml`](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/docker-compose.yml) (Pipeline launcher), [`f1_avgdeg.sql`](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_avgdeg.sql) (Average degradation), [`f1_set.sql`](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_set.sql) (Set analysis)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_pipeline["Data pipeline"]
  node_compose["Pipeline launcher<br/>[docker-compose.yml]"]
  node_notebook["Session processing<br/>[f1.ipynb]"]
  node_positions["Positions graph<br/>[f1.ipynb]"]
end

subgraph group_storage["Data storage"]
  node_japan_csv["Clean session CSV<br/>[Japan2023.csv]"]
  node_minio[("MinIO object storage")]
  node_mysql[("MySQL database")]
  node_avgdeg_csv["Degradation results<br/>[f1_avgdeg.csv]"]
  node_pitstop_csv["Pitstop results"]
  node_stint_csv["Stint results<br/>[f1_maxstint.csv]"]
end

subgraph group_analysis["SQL analysis"]
  node_avgdeg_query["Average degradation<br/>[f1_avgdeg.sql]"]
  node_pitstop_query["Fastest pitstops"]
  node_stint_query["Longest stints"]
  node_set_query["Set analysis<br/>[f1_set.sql]"]
  node_stint_detail["Stint analysis<br/>[f1_stint.sql]"]
end

node_user(("Analyst"))
node_fastf1["FastF1"]

node_user -->|"launches"| node_compose
node_compose -->|"runs processor"| node_notebook
node_notebook -->|"retrieves session data"| node_fastf1
node_notebook -->|"generates CSV"| node_japan_csv
node_notebook -->|"generates graph"| node_positions
node_notebook -->|"pushes assets"| node_minio
node_user -->|"analyzes data"| node_avgdeg_query
node_user -->|"analyzes data"| node_pitstop_query
node_user -->|"analyzes data"| node_stint_query
node_user -->|"analyzes data"| node_set_query
node_user -->|"analyzes data"| node_stint_detail
node_avgdeg_query -->|"queries"| node_mysql
node_pitstop_query -->|"queries"| node_mysql
node_stint_query -->|"queries"| node_mysql
node_set_query -->|"queries"| node_mysql
node_stint_detail -->|"queries"| node_mysql

click node_compose "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/docker-compose.yml"
click node_notebook "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1.ipynb"
click node_japan_csv "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/Japan2023.csv"
click node_positions "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1.ipynb"
click node_avgdeg_query "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_avgdeg.sql"
click node_set_query "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_set.sql"
click node_stint_detail "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_stint.sql"
click node_avgdeg_csv "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_avgdeg.csv"
click node_pitstop_csv "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_fastestpitstop.csv"
click node_stint_csv "https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_maxstint.csv"

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_compose,node_notebook,node_positions toneBlue
class node_japan_csv,node_minio,node_mysql,node_avgdeg_csv,node_pitstop_csv,node_stint_csv toneAmber
class node_avgdeg_query,node_pitstop_query,node_stint_query,node_set_query,node_stint_detail toneMint
class node_user,node_fastf1 toneIndigo
```

## Components

### Data pipeline

- [Pipeline launcher](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/docker-compose.yml): `docker-compose.yml`
- [Session processing](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1.ipynb): `f1.ipynb`
- [Positions graph](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1.ipynb): `f1.ipynb`

### Data storage

- [Clean session CSV](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/Japan2023.csv): `Japan2023.csv`
- **MinIO object storage**
- **MySQL database**
- [Degradation results](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_avgdeg.csv): `f1_avgdeg.csv`
- [Pitstop results](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_fastestpitstop.csv): `f1_fastestpitstop.csv`
- [Stint results](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_maxstint.csv): `f1_maxstint.csv`

### SQL analysis

- [Average degradation](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_avgdeg.sql): `f1_avgdeg.sql`
- **Fastest pitstops**
- **Longest stints**
- [Set analysis](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_set.sql): `f1_set.sql`
- [Stint analysis](https://github.com/mateussilvams056-gif/f1-data-extraction-and-data-analysis/blob/main/f1_stint.sql): `f1_stint.sql`

### Other components

- **Analyst**
- **FastF1**

## Connections

- Analyst → Pipeline launcher: launches (evidence: `README.md`)
- Pipeline launcher → Session processing: runs processor (evidence: `README.md`)
- Session processing → FastF1: retrieves session data (evidence: `README.md`)
- Session processing → Clean session CSV: generates CSV (evidence: `README.md`)
- Session processing → Positions graph: generates graph (evidence: `README.md`)
- Session processing → MinIO object storage: pushes assets (evidence: `README.md`)
- Analyst → Average degradation: analyzes data (evidence: `README.md`)
- Analyst → Fastest pitstops: analyzes data (evidence: `README.md`)
- Analyst → Longest stints: analyzes data (evidence: `README.md`)
- Analyst → Set analysis: analyzes data (evidence: `README.md`)
- Analyst → Stint analysis: analyzes data (evidence: `README.md`)
- Average degradation → MySQL database: queries (evidence: `README.md`)
- Fastest pitstops → MySQL database: queries (evidence: `README.md`)
- Longest stints → MySQL database: queries (evidence: `README.md`)
- Set analysis → MySQL database: queries (evidence: `README.md`)
- Stint analysis → MySQL database: queries (evidence: `README.md`)
