Start here:

http://www.amazon.com/Building-Data-Warehouse-W-Inmon/dp/0764599445

Is it really just a Data Warehouse you want, or do you actually want an end-to-end Business Intelligence solution? A Data Warehouse is one aspect of a BI strategy...

swellguy (8/18/2011)

---

I think you articulate well a point I was trying to make. The poor pencil maker could have said 'no,' and explained the business reasons for his...

Why not create a normalized schema for the data so that it can more easily be validated and queried? I don't understand what advantage you think XML has in a...

Microsoft is just following the SQL standard. SQL Server...

As a general rule aim to be in at least Boyce-Codd / 5th Normal Form unless and until you find good reasons to do otherwise. That's the best way to...

PaulB-TheOneAndOnly (7/18/2011)

---

Well... that's the definition of a Data Warehouse 😎 and I beg to differ they are not "typically (implemented) in at least 3rd Normal Form". 3NF+ is the...

PaulB-TheOneAndOnly (7/17/2011)

---

A proper, complex, enterprise level Data Warehouse is nothing but a collection of simple Datamarts that share some conformed dimensions therefore there is not limit in regards to the...

Tom.Thomson (7/14/2011)

---

That's sort of true. But Occam's razor is a useful tool when trying to present things in a simple manner, and what a functional dependency is all about...

The author's point about A being "fixed by" the values of X presumably means a functional dependency of the form X->A. Functional dependencies are the basis of 2NF. It 's...

As far as I'm aware the...

Tom,

I'm well aware that the relational model and TTM require relations that consist of atomic attributes. What I see as a problem is that your article uses another criterion...

Jan Van der Eecken (7/1/2011)

---

Just one question. When you say

Tom.Thomson (6/30/2011)

In my view nothing that isn't all of 2NF, 3NF, and EKNF as well as 1NF is a good database...

1. I find this article problematic because it uses terminology and ideas that are not going to be universally understood in the same way by all readers. In particular it...

Good question. It has always seemed odd to me that SQL Server has two different ways of getting data out of procs - as output variables and as "result-sets". Now...

Eric, Do you really think that a "one or more" cardinality referential constraint is so much more complex than a "zero or more" constraint that it justifies a fundamentally different...