Re: Business Intelligence and Software Development

From: Jan Eric Mortensen <eric.mortensen_at_objectware.no>
Date: 23 May 2003 01:32:52 -0700
Message-ID: <27b05bfb.0305230032.3413ce38@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.

With regards to the original question my advice is also to have the two teams work together, preferably as a single development team. That cuts down on communication costs and makes it more likely that the OLTP can support the BI requirements (and vice versa).

Regards,
Eric Mortensen Received on Fri May 23 2003 - 03:32:52 CDT