Structured Export Markup Language – An Interpretive Transformer for Exporting XML Document from Relational Database

Description

Most enterprises are using relational databases for handling real-time business operations. They need to generate various XML documents for data exchanges internally with various departments and externally with business partners. There are various ways of generating XML documents based on the data stored in relational databases, including programming, and various frameworks and commercial software applications. However, the programming approach is still the most popular one. Nevertheless, there are various problems with such an approach. For example, it may be difficult to use, time-consuming, and error-prone, and software developers are not sufficiently proficient in handling various hidden but critical issues. Frameworks and languages proposed by other research are either not generic or cannot generate arbitrary XML documents. Therefore, this project proposes a simple and complete solution with the introduction of an interpreter transformer, Structured Export Markup Language (SEML), for exporting relational data into XML documents. The solution can be used as a generic tool for extract, transform, and load (ETL) purposes.