FASTianF1

Group project for Database 2 course, developed by Christian Marchiori and Fabio Zanini.

The aim of this project was to create a graph database representing the world of Formula 1. Formula 1 (a.k.a. F1 or Formula One) is the highest category of single-seat auto racing sanctioned by the Fédération Internationale de l'Automobile (FIA) and owned by the Formula One Group. The datasets used to create this database contain information regarding races, drivers, driver ratings, constructors, qualifying, circuits, lap times, pit stops, and championships from 1950 until the last season 2023. The repository also contains some SPARQL queries to show how the database works.

---

This repository contains:

• the ontology designed to model the F1 world (\Ontology)
• the visual graph (.png and .svg)
• the datasets used (\data)
• the jupyter notebook developed for data cleaning, ingestion and serialization (\Serialization)
• the turtle files produced by serialization (\data\rdf)
• a notebook containing the queries (\Queries)
• the logo for our project
• other useful files (also for presentation)

---

Data sources:

• Formula 1 data: Ergast API or Kaggle
• Ratings 2023 data: EA Ratings API of F1 2023 official game
• Ratings older data: GitHub
• Country to Nationality csv: GitHub

---

Various instruction to make the jupyter notebook work:

• the path are compliant with windows os, so they use '\' . To make them work with macOS or Linux, they need to be changed with '/'.

---

Schema of the FASTianF1 ontology:

The list of all data properties for each class is available in the Ontology folder.