Home » RDBMS Server » Server Administration » configure database server for only run report
configure database server for only run report [message #199464] Tue, 24 October 2006 10:07 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I have to design architecture a server to run only report from a client and i have some question as the following:
1.Should i separate the from the production?
2.How i will move data from production to a server report for fast?
3.How i will config a database for a good performance?

Thks for advance !

Chara
Re: configure database server for only run report [message #202905 is a reply to message #199464] Mon, 13 November 2006 04:27 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

1.Should i separate the from the production?
Ans: Depends on the size of the report database and depends on the reporting requirements ..also depends on the H/W of the server ..

2.How i will move data from production to a server report for fast?
Ans: if the report server is required to be a replicated site of the production server , then multi master replication is one of the recommended options.. you have mat views setup in the reporting site and set their refresh interval as per the requirement.

Ans: Please check metalink / try to google around ..there are many docs available in setting up a database tuned for OLAP requirement ..

-Sai Jeedigunta
http://vasujeedigunta.blogspot.com
Previous Topic: IS it possible-->Grant DROP Table to <username>/<rolename>
Next Topic: How to use DBMS_SCHEDULER ??
Goto Forum:
  


Current Time: Wed Dec 07 16:28:15 CST 2016

Total time taken to generate the page: 0.10457 seconds