4 ms·
It need not integrate tightly with other business systems. Especially as we move into an era of big data, it need only integrate well with databases. I am crea
by thangalin 16y ago
It need not integrate tightly with other business systems. Especially as we move into an era of big data, it need only integrate well with databases.
I am creating a website that allows the general public to create reports on how the climate has changed, such as:
http://i.imgur.com/o8fTg.jpg http://i.imgur.com/o8fTg.jpg
PHP, PostgreSQL, R, and JasperReports to analyse 273 million rows of data across 8000 weather stations spanning The Great White (soon to be Green by the looks of it) North for the last 110 years.
The trend line, shown in orange, is calculated in R using a Generalized Additive Model. There is no way I was going to (or even could) write such a complex algorithm myself. When I started the project, I was using MySQL. I migrated the database to PostgreSQL specifically so that I could use R for the analysis. I migrated the database before learning R.
- T_S_ 16y agoGood stuff.