This content has been marked as final. Show 7 replies
If you don't give any information you are wasting our time.
How big will the database be ? What will the users be running ? Where is the data coming from ? What is the DWH for ? What disk storage ? Single instance or RAC ? What budget ? How much RAM ? What hardware ?
If you want to run a serious Oracle datawarehouse, please don't run it on Windows. Put it on an OS that works - e.g Linux or Solaris or AIX.
Oh.. Thanks robert..
The Users will be using for reporting purpose.
The front end will be JAVA.
RAM: 32 GB
Hardware: Intel Xenon E5430 with 8 CPUs.
RAC: No (Single Instance)
Data will be refreshed every night using materialzed views
Sorry, but I still don't understand what your question is ?
You have already decided on the hardware, OS, database, memory, so what else do you want to know ?
Datawarehouses don't usually have a Java front-end. They usually use a reporting tool like Discoverer, OBIEE etc.
Actually Robert they have decided to build a seperate application for datawarehousing.
We need to decide what are the changes can be done from OLTP. In the sense like schema redesigning and partioning etc., So that I'm searching for what are the feature will improve the performance in Data warehouse mode from the database perspective.
they are going to use this to keep query our 10 years record.
People get paid huge amounts of money to design high performance datawarehouse schemas, and it takes months or years. There are many design methods, starting with the report requirements, then working back to the data source.
Datawarehouses can benefit from partitioning, table compression, transportable tablespaces, larger block sizes, materialised views, streams, bitmap indexes, fact and dimension tables etc.
A forum is really not the place to learn this. Best to get a good book on Oracle DWH design. Others on this forum may be able to recommend one.
I found couple of link for data warehouse environment in oracle :
Thanks Robert and Girish.
Your suggestiongs made me understand the importance and criticality to design good Data warehouse solution.