The variable scope in javascript can still surprise me. This is a nice one I debugged today: A variable that is not defined by “var” have a global scope. This can be a real pain since the globalization is implicit and easy to forget. I forgot the “var” when writing a for loop and could…
StarSchema (OLAP) setup for reporting in CakePHP
Jun 4, ’09 7:38 PM
When you need to gather statistics and reporting data from a large number of transactions (easily >1’000’000 rows) you need to transfer that data over to a reporting-friendly format to keep request times down. One popular database design for this is called a Star Schema. This is a simple re-usable StarSchema setup for CakePHP.