Tag Archive for 'statistic'

Hey Hey,
so i haven’t blogged something since my 18. birthday, ive been quite busy… anyway.

I lately worked on a mysql db containing the whole freedb for school (teaching php ). First we just wanted a simple database for doing some SQL Stuff, but there are serious statistics you can dump!

Here’s an example: I just throwed the following SQL:
SELECT year AS Year, count( * ) AS Count, AVG( track_count ) AS Tracks FROM `cds` WHERE year >1950 AND year <2010 AND track_count >5 GROUP BY year

And this is what turned out:

Development of Music Industry

You can easily see how the whole music industry grew since 1950, but you can see the crisis as well, just look at the data after 2005 (filesharing getting big). This is probably another effect, beside cd sells: less cd’s are produced then estimated!

And adressing the track count: i always had the feeling the overall track count of my cd’s is getting smaller each year… but this is obviously not true.

————————————————————–
Okay, just a side note:
I’m now twittering on twitter.com/ireemo ! Follow me and my experiments with the Arduino, a microcontroller fully based on opensource layouts and so on.
Curious about putting AvrX on it!