Data Warehousing with MySql

[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:
>

edit css

show debugging

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

[e]

Clickstream Data

Ie., building a data-warehouse for web-visits data.

Typical Dimensions

session_dimension ()

page_dimension (page_key, path, item_name)

referer_dimension (referer_key, referer)

Typical Fact Tables

fact_page_events (date_key, time_key, user_key, page_key)

fact_sessions (date_key, session_key)

fact_page_aggregate (date_key, page_key, num_hits)

fact_page_transitions (from_page_key, to_page_key, num_transitionn)

Resources

The Data Webhouse Toolkit Ralph Kimball & Richard Merz.

DB Schemas for NetTracker software. This is a large comprehensive schema: ~50 base tables, and ~30 aggregate tables. [Sep 05]

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