Links · Data Warehousing with MySQL

Links



MySql.com


  • Data Warehouse Workshop - in San Francisco, $US1000-.
  • Presentation on Implementing Star Schemas in Mysql from 2005 Mysql conference.

    General Data Warehousing


  • V good introductory article explaining why to have a data-warehouse, and code from an actual data-warehouse used for a Levis website: Data Warehousing.

    The Two Schools of Thought


  • Ralph Kimball (http://www.ralphkimball.com/)
  • Bill Inmon (http://www.b-eye-network.com/home/index.php)

    Discussion & Articles


  • Good Articles DBAzine - Data Warehouse [dbazine.com]
  • Mailing list: http://www.datawarehousing.com/list.asp
  • Online discussion (registration required): http://www.datawarehousing.com/Forum/browseforum.asp

    MySql Tips for D-Warehouse


  • The Open Source Data Warehouse -- Roger Magoulas [mysqluc.com] (July 05). Powerpoint slides from his presentation. Good.

    Case Studies


  • See: Benchmarks
  • Golden's Rules: Data warehousing at 75% off with open source (Nov 04)

    Software which uses MySql


  • Open source application for data mining on MySQL (March 04)
  • OLAP4All -- uses MySql to analyze & aggregate data which you feed into it. Commercial.

    Miscellaneous


  • Data Warehouse Wiki -- wiki of d-warehouse things.
  • HackMySql.com -- articles about optimising of queries.
  • Data Warehousing with MySql -- John Paul Ashenfelter's presentation from MySql 2004 conference.