Having data in a spreadsheet can be fine for many types of data and projects, but when you want to start interrogating the data in more complex ways a relational database is much more powerful. There are numerous programmes around to create such a database in (MySQL is a powerful free one), but before we get to that stage it is necessary first to plan out the database, going back to first principles.
I propose covering these first principles step by step, then working our way together through a few sample datasets to think about how we would structure that data for a relational database. If you have some data you would like to go through, feel free to bring it along.
]]>—
[Update: 3 December 2013]: A blog summarizing a little of what I presented at my THATCamp session can be found here: exponentialdecay.co.uk/blog/architecture-of-the-fr-org/ – Thanks to all those who attended!]
—
Two-weeks back I built myself a linked file-format registry. For me, one of the biggest motivations is opening up existing data and making it more queryable…
I want to share some of that experience and provide a bit of a technical background about the implementation of that work, and what a SPARQL endpoint can do for you.
Covering:
Conclusion: The technology isn’t a silver bullet, but, make your data available on the web, and use open standards.
Further Reading…
Personal blog, covering the work: exponentialdecay.co.uk/blog/tag/the-fr-org/
A bit of an example query: bit.ly/I2xwB3 (More information on this particular query in session…)
]]>