/Postgrsql-Database-Development-Vehicles-traffic-accidents

Java, Apache Spark, PostgrSql

Primary LanguageJava

Database-Development-Vehicles-traffic-accidents

In this Database we have worked with open Data of United Kingdom goverment, which had been published from MInistry of Transport and more specifically UK Road Safety: Traffic Accidents and Vehicles

URL: https://www.kaggle.com/tsiaras/uk-road-safety-accidents-andvehicles/home

1) Postgresql

Every time a query is executed you will show every second time that the query is executed you will show the execution time

image

Above are execution times of queries in PostgreSQL

2)Query implementation in Spark (RDD)

image

This Java - Postgresql project is completely analyzed inside Database Development Vehicles traffic accidents.pdf which is a word document