Entity Identification Problem

Schema integration is a difficult task. How can like real world entities from multiple data sources be matched up? For example- how can the data analyst or the computer be sure that customer Id in one database, and customer number in another refer to the same entity? Databases and data warehouses typically have metadata i.e. data about the data. Such metadata can be used to help avoid errors in schema integration.

Click Here for Data Warehousing and Data Mining Main Page