Generating the Good XML Schema from Relational Database by using String Matching Algorithms

Abstract

Data exchanging is involving as an important role in the Web application and Extensible Markup Language (XML) is also accepted as the standard for exchanging information between the heterogeneous systems. The XML schema acts as the standard format between the sender and receiver for the XML documents. As a result, the design of the schema document is very important because most of the XML documents are validated with their schema. In this paper, the two string matching algorithms (Maximum Consecutive Substring at right and any) are proposed for detecting the common attributes in the relations. Then, these string matching algorithms are applied for detecting the common attributes in the relations. The similar attributes are grouped and converted as element group in XML schema document for converting the relational database to XML schema document. The resulted XML schema is more modular; more understand for the human readers and reduce the maintainability effort.