Many organizations use relational databases (RDB) at this time. These databases can be different producers (Oracle, MS SQL Server and etc.), operate different operating systems and use different software. But the main problem if organizations want collaborate they must exchange data between them. Sometimes if they use different data structures exchange data between them is very hard or impossible. If they want integrate different databases they must use general standard. This standard must be adjustable for different databases. One of the general standards is XML. The main purpose of this project was to analyse two functional requirements supply methods (UML and Communication Action Loops), possible architecture decisions and separate replication streams of distributed databases. One of the possible architecture decisions is replication using XML. Considering to this was created the appropriate software tool. Using this software, administrator can manipulate data and exchange data between two databases (MS SQL Server and Oracle) using XML. We have same data in two databases and we need write same date in two different databases and in this project used XML to solve this problem.

Šiuo metu informacija yra sukaupta paskirstytuose šaltiniuose, kurie kaip saugojimo priemonę naudoja duomenų bazes. Šios bazės yra skirtingų tipų. Vartotojo tikslas yra naudoti keletą nepriklausomų informacijos šaltinių kaip vieną. Dėl savo nepriklausomumo nuo DBVS ir platformos tipo, XML tapo ypatingai naudingas atviroms susisiekiančioms sistemoms, kuomet duomenys apsikeičiami tarp paskirstytų duomenų šaltinių. Šiame darbe pateikiamas ontologijų, kaip dalykinės srities apibrėžimo informacijos paieškai, panaudojimas. Tai leidžia optimizuoti reikiamos informacijos paieškos procesą ir išvengti užklausos rezultatų pertekliškumo. / The main problem in heterogeneous database integration is data incompatibility in different databases. XML is perfect solution in data exchange between different databases as it is independent from OS, applications or hardware. To implement XML in data exchange XML must be created corresponding to the databases. This work propose use of ontologies for information retrieving from heterogenous data bases. Such method let optimize user query to avoid wasted information.