. .

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

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