Abstract:
Data integration is vital and rapidly growing area in IT industry. Most of applications, organizations and services are using data integration operations, but the challenging task in this area is resolving of conflicts. These conflicts are occurred when merge two different heterogeneous databases. Data does not represent in consistent form due to heterogeneities. These heterogeneities can misinform the user, or user may face difficulty to read data in multiple representations. For this, it is necessary to resolve conflicts while merging two different databases. Proposed solution for this problem is to identify and resolve conflicts by using XML Rule File. Conflict resolution method is different from other approaches. Here conflicts are not resolving on query level they are resolving after query generation. XML rule file parser is use, which describes that how two different databases are merged together, user generates query to acquire results from these databases. This tool has awareness of different conflicts, it identifies conflicts in results. These results are resolved by self-defined conflicts resolution functions and finally resolved data is presented to user. Conflicts resolution methods are defined in C# programming language rather than SQL query. In this project, three different approaches are used: XML for data merging approach, SQL for query processing and C# for data handling, data presentation and conflicts resolution.
