Research And Application Of Data Exchange Based On XML

With the development of network technology and the accumulation of different forms of data, much business data in companies is stored in different relational databases, run on different developing platforms and operating systems, which constitutes a heterogeneous system. Because XML has become the Web data exchange standard, so in the area of relational database related research, an important area of realizing the exchange and sharing of heterogeneous data based on XML has become a research hotspot.In this paper, the existing heterogeneous data exchange theory and implementation method are studied deeply, the key technology is discussed, the models and methods of conversion between relational data and XML are analyzed and compared. Against the state of high cost and low efficiency, a modular idea is proposed, a new conversion method BTT (Bottom To Top) between relational database and XML is proposed too. First of all, a vector model of relational database and a XML schema tree model are proposed, preserving the structure, properties and user-defined constraint information. Second, based on vector model and XML schema tree model, a new conversion methods of BTT and its mapping rules are proposed. BTT not only maintains the structure information, attribute information and constraint information to convert correctly, but also accompletes modular's packaging and reuse, making the maintenance for transformed XML document in high efficiency. Furthermore, through a large number of experimental data to prove that comparing with other method, BTT has an obvious advantage in the maintenance. Finally, combining the billing system under nation centralized mode, BTT is applied which has a great practical significance.