This is a busy week for everyone doing analytics work. People are rushing to complete their final analyses of the 32 finalists, make tournament predictions, and whatever software tools they need to carry out their tasks. Here is what I'm working on this week: Debugging the data entry forms that implement the Football Match Result […]
Over the last three days I've made significant progress on the implementation of my database design. I have used OpenOffice Base 3.0 to build the database and the entry forms, and after much effort I was able to design forms that could load all of the major tables of the database. It was a very […]
It's been about a month since my most recent post related to the Football Match Result Database, so I'd like to give an update on what I've been doing since then.In March I bought a book on relational database design and completed a specifications document for the FMRD. In April I bought another book and […]
This morning I posted my specifications for the Football Match Result Database. Tonight I'll discuss the design and explain my thinking behind some of the tables. (more…)
Sorry for being away from the site (actually both sites) for a while, but I was preoccupied with completing this database specification task. I've finally arrived at a point where I can share my plans with someone else, which I will do in a few moments.First of all, I would like to acknowledge those who […]
I am reading through that book on database design, and it has helped me greatly in formulating an effective database for my research projects. The book has also shown me where I have made mistakes before in previous attempts at database development, and I hope to create something more useful this time around. Maybe I'll […]
Recently, I've spent a considerable amount of time discussing team and player metrics on this site, as well as some work on certain tournament formats, but it is clear that I need a better approach to collecting and storing match data. I've been able to demonstrate the efficacy of some of these metrics by collecting […]
I've been busy with work and then travel over the past two days, but tonight I was able to get to work on a list of tables and fields that I think would be relevant for a soccer match database. There might be other fields that other users would put in for other competitions, but […]
I haven't been on the site in a while, and for good reason. Work has picked up (thankfully!) and I've gotten bogged down with papers to read and analysis questions that need answering. I am realizing just how lazy I really am, which is funny to read from someone with three university degrees. (Or maybe […]
