Microsoft Interview Question
InternsCountry: India
To actually merge and hope for a correct understanding of the data. The solution would be to think of a Federated Databasesystem. The databases exists independently, but are aware of each other and can communicate with each other through an interface.
This will save both company money and time by merging alot of data into a databasesystem.
If we did merge, the problem would be how the datas understand each other at all? This is a typical heterogeneous problem that might occur.
To actually merge and hope for a correct understanding of the data. The solution would be to think of a Federated Databasesystem. The databases exists independently, but are aware of each other and can communicate with each other through an interface.
This will save both company money and time by merging alot of data into a databasesystem.
If we did merge, the problem would be how the datas understand each other at all? This is a typical heterogeneous problem that might occur.
Extract entities from both systems and determine database tables whose rows are to be merged. (Assume both have the same normal form 3NF for simplicity). Merge columns, and then data and so on. Ensure that the foreign keys etc. are mapped correctly.
- Noobie July 29, 2013Example, Table A (a1, a2) and B(b1,b2,b3) are to be merged and column mapping is a1->b1 and a2->b2. The merged table shoud have C(a1b1, a2b2, b3)