Designing a Reporting Database

From: Todd Rubel <trubel_at_oakgroup.com>
Date: 23 May 2001 11:00:44 -0700
Message-ID: <d272bee7.0105231000.48bf2ea3@posting.google.com>

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.

I'm looking for advice on how to setup the database portion of this application. I was thinking about using views but I am afraid of the inefficiency. Next I was thinking about using separate tables written with lots of triggers.

Any advice from projects you've worked on or ideas you've heard would be greatly appreciated. Thanks. Received on Wed May 23 2001 - 13:00:44 CDT