Design a huge DB ?? help me

From: tears <u40508_at_uwe>
Date: Tue, 08 Jan 2008 18:03:05 GMT
Message-ID: <7de9aeb0159d8_at_uwe>

Hello ,

can you help me please to analyse this situation and choose an appropriate design for that

The prloblem / Situation

B-Globe is a huge company has many branches all over the world. Every branch has its own IT center which was developed indepedently. According to the recent needs of its decision makers, an IT consultant had been hired to evaluate the situation and suggest solution. He studied the situation and came up with these notes:
a) The IT centers have heterogenous DBs with different objectives. b) The needs of the company decision makers rapidly increased during the last 12 months and are expected to increase more and more. c) The complete monthly report may take about 2 weeks to gather the information from the different centers and combined them together in an appropriate format.
d) The quartly report may take about four weeks for preparation. e) Studing the data of all branches (according to the current architectire) to analyze the company trends and make a predictive study for the future strategy may cost the company a high percentage (more than 40%) of the expected gain of the new strategy.
If you are the person who will study this situation to propose a solution for this problem, what are your suggestions in a clear and well-defined steps. The copmany can not accept a solution which is not based on well-defined technology and also it is impossible to suggest a solution of rebuilding all the company IT centers in a homogeneous
and modern DBs!!.

please suggest any assumptions or direct me to an appropriate reference (site or book) ..
I think we can use the federated database architecture (five schema ) , data warehousing or something like that ... plz think with me Received on Tue Jan 08 2008 - 19:03:05 CET

Original text of this message