Thomas Hada

Databases


With a team of 3 other students I created a relational database using Microsoft Access. The database contained data for approximately 5000 music files, retrieved from the Million Song Dataset. The data was stored in an HDF5 file, which we parsed using a Perl script to pull out only the data we wanted, as well as cut down the size of the database since Access does not handle large volumes of data well. Several custom reports were also created to display important information. Below are some screenshots of the database, various forms, and the reports we included.