Downloads: 3 | Views: 204 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper | Computer Science | United States of America | Volume 12 Issue 6, June 2023 | Popularity: 5.2 / 10
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
Edition: Volume 12 Issue 6, June 2023
Pages: 3010 - 3015
DOI: https://www.doi.org/10.21275/SR23068145931
Please Disable the Pop-Up Blocker of Web Browser
Verification Code will appear in 2 Seconds ... Wait