Research On XML-based Middleware Information Exchanging Between Databases

With the development of e-business diversification,online trading has become themainstream,and the supplier can choose a lot of trading platforms.The trading platforms aredesigned to solve the problems between suppliers and business about informationexchange.For suppliers and businesses,when they want to achieve data sharing,the problem ofdatabase interaction occurs.So then it is necessary to develop a Information Transfer Systemspecifically for small and medium sized database.Typically database interaction is not only having many cumbersome operation,but alsohaving to find repeatedly to arrange the order of import data records.These operations are verydifficult to complete and error-prone.For heterogeneous database interaction problems thesupplier encountered and the lack of the insufficiency of the traditional data warehousinginformation interaction method,the article put forward an XML-based method of informationexchanging between databases and the corresponding database interaction system isdeveloped.The utmost feature and difficulty of the system is taking hibernate XML mappingtable file for converting middleware to realize information interaction,namely:the automaticstructure function of hibernate-based table completes automatically the database table’screation.The XML mapping file which are quilted in different types of database tables are thesame,so they can be the media to complete a variety of data interaction.The method can save alot of time.The method can save a lot of time.System features are easy to grasp,andnon-computer professionals can operate.The main direction of research on XML-based Information Exchanging BetweenDatabases is taking XML as middleware to realize the information exchange between data inheterogeneous databases or homogeneous databases in the environment of small andmedium-sized databases.Taking hibernate XML mapping table can shield the problemscaused by heterogeneous database such as data types difference,So the realization onXML-based information interaction between heterogeneous databases is very significant fordata information of the small and medium-sized database.