State of Data Last Week – #34
February 4, 2011
Inside Intuit – Is it true $5T of revenue passed through QuickBooks Online in last 10 years?
Intuit 2020 accounting report forecasts future for the Profession
#analysis – A somewhat comprehensive anthology of Free, Public Data sets
#architecture – Amazon Relational Data Service (RDS) now can run Oracle Database
#big_data – Strata 2011 presentations are now online. This editor’s favorite takeaway #1 – ‘Big Data hype may have gotten out of control when people start referring to large spreadsheet as Big Data’. #2 – ‘not being able to code today is like not being able to fence in medieval times’. #3 – ‘the difference between a map-reduce system and a fault-tolerant map-reduce system is about 300K lines of code’.
#DBMS – ‘PostgreSQL does not have query hints because we are not a for profit company’.
#learning – To paraphrase a certain ex-President – ‘Scalability problems are never more than one release away from surfacing’. A Rails guru ponders on different patterns for scalability, including ‘It’s fine to abstract (code), unless the abstraction is such that it requires too much work to understand what is going on’
#visualization – ‘Any sufficiently advanced data wrangling technology is indistinguishable from magic’ – Stanford’s ‘Wrangler’ tool for data cleaning and transformation.
- What’s the next country after Tunisia, Egypt? Check the mean age for marriage for women (hit the ‘Play’ button) and you get a trend – it’s increased to 29 years in Tunisia, 24 in Egypt.
- Don’t take it all that seriously – Amazing adventure of Madeupstats in Twitter. E.g., ‘Today, 1 in 8 relationships is ended by text message. Seems harsh? Well, half of relationships are started by text message.’
- Why Twitter is so much more popular than Facebook in Japan – ‘140 characters in Japanese will get users a lot more bang for their tweets than in English. The word ‘information’, e.g., requires a mere 2 characters in Japanese’.
- San Francisco in Movies – Data360 crunched numbers and built the list of 10 actors with most movie scenes in San Francisco. Of course, Clint Eastwood tops the list!