Data Warehousing with MySql

[e]

[e]

[e]

Data Warehousing with MySql

Data Warehousing is the idea of setting up a separate database structure for purely reporting purposes, so you can stop compromising between reporting and transactional demands.
MySql is a database that is fast, easy to use, and (generally) free.

> Aggregation
> Benchmarks
> ClickstreamData
> DatesAndTimes
> Home
> Indexing
> KPIs
> Links
> MathML
> Money
> MysqlCompared
> PhpPlugins
> Recipe
> Regression
> Scripting
> Sudoku
> SummaryData
> TableTypes
> TuningMysql

New Page:

search:
>

contact: tom (.) cunningham (at) gmail (dot) com

[e]

[e]

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.

Total Time: 0.06s

REQUEST:Array
(
    [link_body/body] => {incl:Links}
    [PHPSESSID] => b9a289e2959005ab5c102380940272d1
)
SESSION:Array
(
    [body/body] => {incl:Links}
)
MESSAGES:PLUGINS: