Adressing the second question, you might want to look into data warehousing. There is a world to discover on how to managing or merging various databases and sc

Adressing the second question, you might want to look into data warehousing. There is a world to discover on how to managing or merging various databases and schemes within a single "warehouse".