Translating relational schema into XML schema definition with data semantic preservation and XSD graph |
| |
| Affiliation: | 1. School of Software, Tsinghua University, Beijing, China;2. Key Lab for Information System Security, Ministry of Education, Beijing, China;3. National Laboratory for Information Science and Technology, Beijing, China;4. Logistical Engineering University, Chongqing, China;5. Queensland University of Technology, Brisbane, Australia;6. Eindhoven University of Technology, Eindhoven, The Netherlands;1. Griffith University, Gold Coast, Queensland 4222, Australia;2. University of Malaya (UM), Kuala Lumpur 50603, Malaysia;3. Computer Vision and Pattern Recognition Unit, Indian Statistical Institute, India;4. School of Computing, National University of Singapore, Singapore;1. School of Information Technology and Engineering, VIT University, Vellore - 632014, India;2. Department of Computer Science, Federal University of Minas Gerais (UFMG), Av. Antônio Carlos 6627 - ICEx - 4010, Pampulha, Belo Horizonte, 31.270-901, Minas Gerais, Brazil;3. Federal Service of Data Processing (SERPRO), Av. José Cândido da Silveira, 1.200, Cidade Nova, Belo Horizonte, 31.035-536, MG, Brazil;1. Institute of Radiation Medicine, Fudan University, Shanghai, China;2. Central Laboratory, Renji Hospital, School of Medicine, Shanghai Jiaotong University, Shanghai, China;1. College of Mathematics and Software Science, Sichuan Normal University, Chengdu 610068, PR China;2. Department of Computer Science and Technology, Tongji University, Shanghai 201804, PR China;3. Key Laboratory of Embedded System and Service Computing, Ministry of Education, Shanghai 201804, PR China |
| |
| Abstract: | Many legacy systems have been created by using relational database operating not for the Internet expression. Since the relational database is not an efficient way for data explosion, electronic transfer of data, and electronic business on the Web, we introduce a methodology in which a relational schema will be translated to an Extensible Markup Language (XML) schema definition for creating an XML database that is a simple and efficient format on the Web. We apply the Indirect Schema Translation Method that is a semantic-based methodology in this project. The mechanism is that the Relational Schema will be translated into the conceptual model, an Extended Entity Relationship (EER) Model using Reverse Engineering. Afterward, the EER model will be mapped to an XML Schema Definition Language (XSD) Graph as an XML conceptual schema using Semantic Transformation. Finally, the XSD Graph will be mapped into the XSD as an XML logical schema in the process of Forward Engineering, and the data semantics of participation, cardinality, generalization, aggregation, categorization, N-ary and U-ary relationship are preserved in the translated XML schema definition. |
| |
| Keywords: | |
| 本文献已被 ScienceDirect 等数据库收录！ |
|
