Bizgres 0.7 Released – Open Source platform for Business Intelligence and ETL

Lucas Jellema

I just read in a Dutch IT magazine (Computable) about the release of Bizgres 0.7. Bizgres is an open source project: The Bizgres Project (www.bizgres.org), a Greenplum-sponsored, community-supported, open source project with the goal of building a complete platform for Business Intelligence (BI) exclusively from free software, announced today new […]

Oracle Warehouse Builder 10g Paris Release … Oh ja, ook voor Data Warehouses! (article on the OWB 10gR2 Paris Release)

Lucas Jellema 1

This article is about a very interesting Oracle tool: Warehouse Builder. A tool that is much more versatile than its name suggests. OWB can be used for diverse activities as graphical Database Design and DDL generation, Data Profiling and Cleansing, Generation of PL/SQL code for loading and transforming data, generation […]

Introducing Materialized Views as mechanism for Business Rule implementation (complex declarative constraints)

Lucas Jellema 7

Put on the trail by Tom Kyte – and after many useful discussions with my colleague Andre, we will take a look in this article at implementing complex business rules declaratively using Materialized Views. A previous post – Declarative Implementation of Mandatory Master-Detail relationship (Order must have Order Lines) – […]

Paris for the Designer

Andre Crone 2

Today I looked into a pre release of Oracles Warehouse Builder 10gR2 (Paris). This comprehensive tool can be used to create complex data warehoused holding data from many different data sources like tables (in different databases), files etc. I was really pleased by the very good reverse engineering capabilities of […]

Pivoting in SQL using the 10g Model Clause

Lucas Jellema 4

In this post we discuss pivoting of records in SQL – either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) and fairly complex, tricky SQL statements. In Oracle 10g, using the MODEL clause, there is a clean, fairly straightforward way to achieve elegant pivoting – even nested pivoting – in single SQL statements. This post shows the pivot operation using the Model clause.