Re: Business Intelligence and Software Development

eric.mortensen_at_objectware.no (Jan Eric Mortensen) wrote in message news:<27b05bfb.0305230032.3413ce38_at_posting.google.com>...
> About BI and OLTP in the same DB:
>
> > >
> > > In theory, or course, the answer is that there is no such thing as
> > > separate databases... you need to bug your DBMS supplier to support
> > > both OLTP and BI against single databases...
> > >
> > > Regards
> > > Paul Vernon
> > > Business Intelligence, IBM Global Services
> >
> > Support both sure, but its no way to get great performance. The two goals
> > are at odds with one another form the start.
>
> Very true.
>
> OLTP = many users with short bursts of activity (SQL that hits single
> rows)
> BI = few users with long, heavy activity (often full table scans)
>
> These requirements lead to different indexing and tuning strategies
> and so on.

In other words, the single logical database needs to support redundant physical data stores with different physical properties. I thought Paul already made that clear in his earlier post. Received on Sat May 24 2003 - 01:39:59 CEST