By admin on 3-7-2009 9:36

In a previous blog entry I started describing the benefits of the Data Vault especially for the business, as it is not always easy to explain why a data warehouse architecture is required to support reporting and planning processes. In this second entry I bring three other reasons to the table: data preservation, enhanced auditability and traceability and finally ease of integration of new mergers and acquisitions.

Read More »

By admin on 2-6-2009 12:57

A new trend has entered the Data Warehouse market place: the data warehouse appliance. The idea is to offer a complete solution for the data warehouse in a single purpose, dedicated box.

This is an interesting new proposition, that allows new data warehouse projects to hit the ground running. You need a green-field situation though, and be aware that most setting up the system for data warehousing is not by far the most costly aspect of building (and owning!) a data warehouse.

Read More »

By admin on 2-6-2009 12:51

Generally the industry recognizes three distinct categories of data in a BI environment:

• Transaction data
• Master data

• Meta data

These different type are treated very differently by most data warehouse systems, in particular the ones that are built from fact tables and dimension tables. Close inspection learns that the distinction is not always clear, and depends on the analysis needs of the organisation. The data warehouse can be (and should be) oblivious of the differences between transaction, master and meta data.

This notion calls for a very generic and flexible data modeling technique. One that is still simple enough to quickly comprehend and scalable enough to be used in any data warehouse environment , from very small scale to multiple-petabytes. We believe such a modeling technique is the Data Vault, as designed and described by Dan Linstedt.  Visit our dedicated sister-company  www.qosqo.nl for details.

Read More »