Transformation based Strategy to Convert Relational Database for Public Sector

Mohammed Sadhik Shaik

Abstract: A method for transforming an RDB into an XML file is presented in this paper. When you migrate your database, all of the schema and data are transferred from one RDB to another using an XML script. This allows you to access and work with your data in a new environment. The data in the source database is converted into the target database according to the new schema, after which the home schema is translated into the target schema and given semantic enhancements. Converting RDB data to XML is a good fit for the semantic enrichment technique since it improves the metadata model from the source database and captures important parts of the destination XML schema. In order to convert RDB data into an XML Schema, algorithms are developed to build the target database according to a set of migration criteria. We have constructed a prototype system and tested it experimentally by observing its results, discussing our achievements, and providing feedback on the results. After reviewing the results, it was determined that the suggested solution was correct and worked.

Keywords: relational database, XML document, database, metadata, data transformation