Archives of the TeradataForum

Message Posted: Wed, 13 Nov 2002 @ 03:12:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

A dimensional model CAN be in a RDBMS, OR a multidimensional DBMS (e.g. express etc). When a relational model is talked about we can pretty much take it as read that a 3NF EDW is being referred to (and looking at the context it is clear that is the case) - harping on about this trivial point is worthless.

An OLTP schema is one that is built to satisfy short sharp tactical queries. A data warehouse is not built for that purpose and is therefore categorically NOT an OLTP schema. If you don't like using 3NF come up with something less misleading - I suggest "3NF EDW" - can't get that wrong!

And also, using a dimensional model as your EDW is fine if your enterprise can be fully modelled by this rather simple method (i.e. your enterprise is not complex). If representing the relationships within your business IS complex I suggest you will encounter the shortcomings of using a sole dimensional model very quickly. So some businesses will encounter less pain than others when they only have a DM with no underpinning EDW. Fully modelling retail product sales is much easier than fully modelling telco sales - the businesses are just very different in complexity (and for that matter data volumes - another driver for the creation of dependent data marts).

Regards,

Duncan

	<Prev	Next>		<<First	<Prev	Next>	Last>>