Hello guys,
I have to write business solution for shortterm and new term.
Scenario like this.
There are two companies one is in JAPAN and other one is in UK they both making bikes.
Now they merger togather, CEO is asking the HRM department to have data of employees.
Now company 1 is having won XP workstation with IBM DB2 databse server and company 2 is having Mysql databse with lynux operating system terminals.
Now management strategy is:
Company is going to keep their old system working on but i have to provide solution which would merge those two databse and make a report of both companies employee name, id and so on and that would be the short term solution.[here i think federated databse connection]
For mid term solution i have to make mydatabase ditributed so i dont have to save data in two different databses.
I am clear that what i have to do but i have questions like:
Do i need to change schema of the database ?
and how i can make report over this two solution. i have to add list of requirements for the integration of data and creation of the report
also a proposed solution togather with my justification for the advice and a plann meeting the short term requirement, including en evaluation of the existing database approch and federated databse.
I would be much appericiate if some master mnd can advice me where to start ....
Please help me...
Thanks in advance..