Over the Christmas season and New Year break, I have been working on my blog www.dwhwiki.info.
I’ve published a series of articles on the problem of historical data:
Dear System Administrators… is an article that describes the problem which I face very often as a business intelligence professional: having no historical data because nobody archived operational data.
The other articles of the series provide a hands-on guide for creating database exports for a variety of database servers:
- Export all tables of an Oracle database
- Export all tables of a Microsoft SQL Server database
- Export all tables of a DB2 database
- Export all tables of a PostgreSQL database
- Export all tables of a Firebird/Interbase database
- Export all tables of a MySQL database
In addition, I have added a review of the book Beautiful Data by O’Reilly which I have evaluated for my class at Steinbeis University.