. .

YAPC::EU 2010 - The Renaissance of Perl



Perl in the Data Warehouse

Perl in the Data Warehouse

By Nelson Ferraz from sao-paulo.pm, Amsterdam.pm
Date: Thursday, 5 August 2010 14:30
Duration: 50 minutes
Target audience: Intermediate
Language: English
Tags: architecture business cpan data database db dimensional dimensions dw enterprise etl facts information modules perl systems tools warehouse

Perl is an essential but often invisible tool in many companies, specially in the Data Warehouse ETL (Extract, Transform, Load) process. However, if you search cpan for "data warehouse" you won't find many modules clearly dedicated to that.

In this talk we are going to talk about some common data warehouse tasks, and propose a generic set of tools to deal with Data Warehouses - the Perl Data Warehouse Toolkit.


The code for the proposed modules is now available at:

* http://search.cpan.org/dist/DataWarehouse/
* http://github.com/nferraz/Perl-Data-Warehouse-Toolkit

Attended by: Marco Masetti (‎grubert‎), Leo Lapworth (‎Ranguard‎), osfameron, Søren Lund (‎slu‎), Damon Davison (‎allolex‎), Nelson Ferraz, Francoise Dehinbo (‎franky‎), John Scoles (‎byterock‎), Anders Nielsen (‎anielsen‎), Adam Bartosik, Daniel Brunkhorst, Joel Bernstein (‎joel‎), Clinton Gormley (‎DrTech‎), Thomas Netousek, Karl Moens (‎CountZero‎), Adeola Awoyemi (‎dialog‎), Shmuel Fomberg, Joerg Meltzer (‎codeacrobat‎), lorenzo, Leon Timmermans (‎leont‎), Oliver Thieke (‎o-thieke‎), Frederico Recsky (‎Frederico‎), Alan Haggai Alavi (‎alanhaggai‎), Jose Luis Martinez, Giel Goudsmit, Lukasz Warian,

Our sponsors


  • Booking.Com
  • YAPC::Europe 2009
  • cPanel


  • Shadowcat
  • 123 people
  • Venda
  • Dada


  • YAPC::Europe Foundation
  • Smart Open Software
  • MySQL
  • Exonetric
  • pair Networks


  • GitHub
  • Italpro
  • Geoesse
  • $foo Perl Magazin
  • Lokku
  • Apress
  • No Starch Press
  • O'Reilly Media

Media Partners

  • Linux Magazine


  • Regione Toscana
  • Comune di Pisa