Re: Creating an Oracle Reporting Server

Thank you all for the feed back. We are using this warehouse as a reporting server for our HR application (PeopleSoft)...we would like to store historical data and would like to update the DB daily. I guess the simple part is creating the database itself through replication, but the real trick is performance. Is this a usual problem that many of you have faced? Again, thank you all for your responses. It has helped me alot, I also found a document on Oracles web site that has their approach and how to install a data warehouse, but I am sure you all know that what is written on a document is not what usually happend in real life situations.

Regards,
Joe

andreyNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<3ef0c67f.1142865263_at_nyc.news.speakeasy.net>...
> If you don't need _all_ the data, snapshots are a good way, and can
> update incrementally.
> You can then process the data as you wish on the warehouse (summaries,
> extra indices, etc).
>
> On 17 Jun 2003 14:30:42 -0700, jchenning_at_yahoo.com (Joseph C. Henning)
> wrote:
>
> >I have a question on the number of ways you can replicate a production
> >database to a reporting server (data warehouse). Can this be done by
> >hot backups? Can this be done on a transaction basis? Just looking
> >for different ideas on how to do this task. Any help would be great.
> >
> >Regards,
> >Joe
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Thu Jun 19 2003 - 11:04:34 CDT