Re: Top Ten Errors In Data Wareousing

In article <3icume$ct3@mozo.cc.purdue.edu> parmentr@oasis.cc.purdue.edu (W J Parmenter) writes: ... Regular databases are optimized for transaction processing which implies a high proportion of "create or update" activity and, we would hope, not a lot of full table scans and long- running queries. A data warehouse is a repository for static data. The tables may be updated monthly, weekly or daily, but not on-line. Warehouse tables typically have lots of indexes and may be tuned to accommodate the most frequent sorts of queries. Over time we have worked hard to provide increasingly accurate "enterprise" (a.k.a. lots of different) data. Now I see "data warehousing" projects that are turning the clock back to a time when our information systems were hopelessly out of date. How has the concept of "warehousing" addressed this? Daryl Monge AT&T Bell Labs EMAIL: daryl@adept.att.com VOICE: 708-713-4696 GEnie: D.MONGE PAPER: IX Rm 1M-315 2000 N. Naperville Rd. Naperville, Il. 60566