Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Database design question
Think about a data warehouse design. Your database has more characteristics of a data warehouse than a transactional DB. You will be adding new data as new responses come in, but you will not be updating and in all likelihood not deleting data. Mostly you'll be doing queries some of which you may know ahead of time and others will be ad-hoc.
Take a look at a star schema design. It tends to do quite well in these situations.
Good luck. Received on Thu Aug 09 2001 - 10:56:01 CDT