Week 4This week I formatted all of the data to prepare it for database entry. I wrote a Java program that will allow me to take separated fields and combine them in any way I choose, which I am using to make table creation in the database easier.
I explored some different SQL databases and it seems that MySQL doesn't yet support views, which I might want to use when formulating my visualizations. PostGreSQL seems to be better able to handle declarative queries and views, so I worked with the sys admin here to get the necessary software installed and daemon run on the CSCL server. I began an Entity-Relationship diagram for the database, which I am considering as I write the design document for the software project.
Eva and I went hiking on Mount Nittany on Saturday afternoon and saw a great view of State College and University Park.