NAME

dw-nav - generate a web based Data Warehouse Navigator

SYNOPSIS

dw-nav [options]

OPTIONS

--dsn

--db_user

--db_password

--fact

The name of the fact table.

--dimension

The name of one or more dimensions.

EXAMPLE

dw-nav --dsn='dbi:SQLite:dbname=test.db' \
       --fact='sales' \
       --dimension='user' \
       --dimension='product'

DESCRIPTION

dw-nav will create the base of a simple Data Warehouse Navigator.

AGGREGATE NAVIGATOR

One of the main features of the Data Warehouse Navigator is the transparent Aggregate Navigator.

The Aggregate Navigator will intercept SQL queries and generate aggregate tables, whenever is possible.

The use of aggregate tables can speed up Data Warehouse by 100s or 1000s of times.

AUTHOR

Nelson Ferraz, <nferraz at gmail.com>

ACKNOWLEDGEMENTS

LICENSE AND COPYRIGHT

Copyright 2010 Nelson Ferraz.

This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.

See http://dev.perl.org/licenses/ for more information.