Re: Designing a Reporting Database
From: David Cressey <david_at_dcressey.com>
Date: Wed, 13 Jun 2001 15:40:22 GMT
Message-ID: <GPLV6.79$BB6.3480_at_petpeeve.ziplink.net>
Date: Wed, 13 Jun 2001 15:40:22 GMT
Message-ID: <GPLV6.79$BB6.3480_at_petpeeve.ziplink.net>
> I need to create several reports for a new system I'm implementing.
> The system contains about 100 tables and I need to create the most
> effecient reporting system possible.
It depends on what kind of reporting you are going to be doing.
A lot of people have benefited by using a data mart implemented by a star
schema
to support multiple reports that are minor variations on the same theme.
But you have to look at the requirements to know whether this approach will be useful. Received on Wed Jun 13 2001 - 17:40:22 CEST