Data warehouse for genomes

Here is an example of how could be implemented and developed a data warehouse to support genomic analysis.

Folder structure

Databases

Here are the DB scripts (.sql) in order to integrate into the DW

ER-Model

In this folder there are the ER-Schema model needed to understand the major external databases integrable into the DW

SQL scripts

There are the SQL scripts in order to develop a DW for genomes.

job_trans

Are the scripts used by Pentaho data-integration for the external

reporting

There is a simple example of report for Pentaho reporting

Schema workbench

Here are the xml of simple cubes developed starting from the DW

===

For a more detailed knowledge of how to develop a data warehouse for genomes with Pentaho read "datawarehouse_thesis.pdf"