This is the fourth part of my week-long presentation of the Football Match Result Database project. Here are the other articles in the series:Part I: Selected screenshotsPart II: Motivation, design and implementation historiesPart III: Database objective, design, and featuresPart V: Roadmap and call for contributorsThis is the moment that you — and I — have […]
This is the third part of my week-long presentation of the Football Match Result Database project. Here are the other articles in the series:Part I: Selected screenshotsPart II: Motivation, design and implementation historiesPart IV: Code releasePart V: Roadmap and call for contributorsYesterday I wrote a long article on the origins of the FMRD and the […]
This is the second part of my week-long presentation of the Football Match Result Database project. Here are the other articles:Part I: Selected screenshotsPart III: Database objective, design, and featuresPart IV: Code releasePart V: Roadmap and call for contributorsI've looked back at my previous posts on the subject and I realize that I have been […]
This is the first part of what will be a week-long presentation of the Football Match Result Database project. Here are the upcoming articles:Part II: Motivation, design and implementation historiesPart III: Database objective, design, and featuresPart IV: Code releasePart V: Roadmap and call for contributorsI have been very quiet on the Football Match Result Database […]
There are new visitors to this website all the time, so not everyone is aware of my ongoing projects, but I have been quiet about this particular project for quite some time. I have been working on the design of a match result database to facilitate my analysis work. I am very allergic to repetitive tasks, […]
On the heels of the Opta announcement is another opportunity for soccer analytics people that I found out about at the SSAC today. There is a startup called StatDNA that has devoted a lot of time to collect in-match data and develop statistical measurements that generate information from those data. They are organizing a contest […]
My post in response to the Brian Phillips article in Slate touched a little on the issues of open source versus proprietary approaches to soccer analytics, but this blog post at Hot Time in Old Town (a Chicago Fire fan’s site) has motivated me to write more at length on the subject. It’s something that […]
A couple of months ago, I published a specifications document for version 1.0 of my match result database. Between then and now, I went through the document and addressed some of the items on my to-do list, such as name changes to a couple of the tables and additional fields to other tables. I also […]
As I mentioned in my previous post, the current database design captures matches that occur under a league format without playoffs, at the club and national team level. (Implementation for national teams is a little simpler and redundant at the same time; the tblTeams table is superfluous and can be replaced by tblCountries when designating […]
I've been quiet over the past week, but I've been busy with debugging the implementation of my database and completing its documentation. I've reached a point where I've verified the integrity of the tables and can say that the database design is close enough to a "release" version — version 1.0. It's been a long […]
