Re: Designing a Reporting Database
From: Frugal Sam <frugalsam_at_hotmail.com>
Date: Sat, 23 Jun 2001 07:10:09 GMT
Message-ID: <lhXY6.6017$3d3.456284_at_bgtnsc05-news.ops.worldnet.att.net>
Date: Sat, 23 Jun 2001 07:10:09 GMT
Message-ID: <lhXY6.6017$3d3.456284_at_bgtnsc05-news.ops.worldnet.att.net>
I am currently working on a similar project. Of course, I have much fewer than 100 tables to work with.
The first thing I would suggest you do, before focusing on the design of
your reporting database, is to analyze the reporting requirements of your
users.
As you learn more and more about how your users plan to query this data, the
database design might well become almost trivial.
All the best. Received on Sat Jun 23 2001 - 09:10:09 CEST