ais-data-warehouse

To design and populate a data warehouse for AIS messages from Data@Liánchéng in PostgreSQL and build an interface to query the data warehouse

Deliverables

Select Types 1, 2, 3 and 5 messages in September 2023 of AIS data from Data@Liánchéng data in PostgreSQL with an unzipping extractor and Emacs for extraction, filtering, and cleaning
Create and populate one or more relational fact tables for the selected and staged AIS messages in JSON format.
Create and populate the relevant dimension tables
Propose and implement four SQL queries that illustrate the benefits of the star schema dimensional model and of the design
Design and implement a Web-based interface to query the data warehouse with 4 hard-coded queries and 3 interactive query construction using Dash library

Name		Name	Last commit message	Last commit date
Latest commit History 6 Commits
Interface Implementation.ipynb		Interface Implementation.ipynb
README.md		README.md
Web_Scrapers_final.ipynb		Web_Scrapers_final.ipynb
report.pdf		report.pdf