A group project that was developed for a university assignment on the subject of Databases.
The project requirements are as followed:
- Use dataset "UK Road Safety: Traffic Accidents and Vehicles" from Kaggle.
- Design optimized SQL queries for looking up accident information in the dataset.
- Create database indexes to speed up queries.
- Break up tables into partitions based on specific ranges and database relations.
- Write a Java program using Spark to execute same SQL queries and calculate statistics.
Group members involved in this project:
Ioannidis Panagiotis, Paravantis Athanasios, Nikas Dionisios