Re: Run OLTP and DW/OLAP in the same database

In article <86c8aa$d9j6_at_imsp212.netvigator.com>,   "S S Wan" <sswan_at_hongkong.com.NOSPAM> wrote:
> Can I do thing as in the subject? It seems to save
> the effort of pouring data from one DB to another.
>

Assuming your OLTP system is of any size, then no.

Generally speaking...........

The design of a good OLTP system is,

1. fully normalized,
2. Data is always retrieved via an index
3. Data is modified as well as read
4. And typically, lots of users doing fairly small transactions

A typical DW

1. Tables are not normalized
2. Full Table scans are legimate
3. Data is not modified
4. A few users running relatively long queries

Ben

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jan 22 2000 - 17:48:01 CST