Relational schema and XML schema bidirectional mapping algorithm based on the intermediate object tree

In order to maintain the integrity of data information in heterogeneous data interaction more effectively, this paper firstly analyzed the advantages of XML Schema in the field of data exchange. And then the hierarchical logic structure of the object tree is used to represent the relational schema structure, proposed the bidirectional mapping algorithm based on the intermediate object tree, the relational schema and XML Schema bidirectional mapping rules are established. Finally, the proposed algorithm is realized according to the rules. The results show that the XML Schema generated by the mapping conforms to the W3C standard and can accurately transmit the referential integrity and the fields of semantic constraints between the relational schema tables.

[1]  Jorge Pérez,et al.  Schema mappings and data exchange for graph databases , 2013, ICDT '13.

[2]  Andy Crabtree,et al.  Human Data Interaction: Historical Lessons from Social Studies and CSCW , 2015, ECSCW.

[3]  Curtis E. Dyreson,et al.  Schema-Mediated Exchange of Temporal XML Data , 2006, ER.

[4]  Xiaoting Wang,et al.  Semantic similarity calculation method in ontology mapping , 2012, 2012 IEEE 2nd International Conference on Cloud Computing and Intelligence Systems.

[5]  D.S. Wills,et al.  On the extraction and analysis of prevalent dataflow patterns , 2004, IEEE International Workshop on Workload Characterization, 2004. WWC-7. 2004.

[6]  Antoon Bronselaer,et al.  Coreference detection in an XML schema , 2015, Inf. Sci..

[7]  Ying Zhang,et al.  A High Performance Schema-Specific XML Parser , 2007, Third IEEE International Conference on e-Science and Grid Computing (e-Science 2007).

[8]  Thomas Schwentick,et al.  BonXai , 2017, ACM Trans. Database Syst..

[9]  Joseph Fong,et al.  Translating relational schema into XML schema definition with data semantic preservation and XSD graph , 2005, Inf. Softw. Technol..

[10]  Claire David,et al.  XML Schema Mappings , 2014, J. ACM.

[11]  Ali Idri,et al.  Extraction of relational schema from deep web sources: a form driven approach , 2014, 2014 Second World Conference on Complex Systems (WCCS).