Mapping Relational Database to Full-Text XML for Open Journal System Cross-Platform Article Distribution
Article Sidebar
Main Article Content
Abstract
In academic publications, the automation of full-text eXtensible Markup Language (XML) is increasingly essential, as generating full-text XML for article distribution is a complex and time-consuming process that requires metadata extraction from a relational database and transformation into hierarchical structures such as Journal Article Tag Suite (JATS). The lack of automation in this transformation process may cause inconsistencies and inaccuracies and may cause errors due to human error. The primary aim is to develop an automation system for transforming metadata from a relational database to full-text XML by reducing errors and speeding the process of generating full-text XML. This is crucial since the demand for automation has been increasing year by year. Furthermore, the motivation behind this research is the growing adoption of the Open Journal System (OJS), one of the popular platforms for managing scholarly journals. It supports a relational database to store the metadata and article information. Therefore, developing an automated system is essential for transforming this structured metadata to full-text XML. To address this issue, various techniques for mapping will be explored to enable the transformation of relational database structures into full-text XML formats. The proposed method involves metadata extraction, mapping logic, and various validation mechanisms to ensure the XML is structured and the accuracy of it. The preliminary result indicates that the metadata has been successfully mapped from a relational database to XML. However, the JATS-specific tagging has not yet been implemented and will be addressed in future work. This research is significant to the publication community, as it brings convenience by reducing some manual work and ensuring metadata standardization.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
All articles published in JIWE are licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0) License. Readers are allowed to
- Share — copy and redistribute the material in any medium or format under the following conditions:
- Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use;
- NonCommercial — You may not use the material for commercial purposes;
- NoDerivatives — If you remix, transform, or build upon the material, you may not distribute the modified material.
References
J. Greenberg, M.F. Wu, W. Liu, and F. Liu, “Metadata as Data Intelligence,” Data Intelligence, vol. 5, no. 1, pp. 1-5, 2023, doi: 10.1162/dint_e_00212.
N.A. Sajid et al., “A Novel Metadata Based Multi-Label Document Classification Technique,” Computer Systems Science and Engineering, vol. 46, no. 2, 2023, doi: 10.32604/csse.2023.033844.
Z. Boukhers, and C. Yang, “Comparison of Feature Learning Methods for Metadata Extraction from PDF Scholarly Documents,” Jan. 2025, doi: 10.48550/arXiv.2501.05082.
N. Samadi, and S.D. Ravana, “XML CLUSTERING FRAMEWORK BASED ON DOCUMENT CONTENT AND STRUCTURE IN A HETEROGENEOUS DIGITAL LIBRARY,” Malaysian Journal of Computer Science, vol. 36, no. 2, 2023, doi: 10.22452/mjcs.vol36no2.2.
A. Kocher, A. Markaj, and A. Fay, “Toward a Generic Mapping Language for Transformations between RDF and Data Interchange Formats,” in IEEE International Conference on Emerging Technologies and Factory Automation, ETFA, 2022, doi: 10.1109/ETFA52439.2022.9921513.
M. Ali, and M.A. Khan, “Performance Enhancement of XML Parsing Using Regression and Parallelism,” Computer Systems Science and Engineering, vol. 48, no. 2, 2024, doi: 10.32604/csse.2023.043010.
S.C. Haw, A. Amin, P. Naveen, and K.W. Ng, “Performance Evaluation of XML Dynamic Labeling Schemes on Relational Database,” International Journal of Technology, vol. 13, no. 5, 2022, doi: 10.14716/ijtech.v13i5.5871.
O. Iwashokun, and A. Ade-Ibijola, “Parsing of Research Documents into XML Using Formal Grammars,” Applied Computational Intelligence and Soft Computing, vol. 2024, 2024, doi: 10.1155/2024/6671359.
B. Tabatadze, “Technological Aspects of Open Journal Systems (OJS),” Journal of Technical Science and Technologies, vol. 8, no. 1, pp. 23–29, Apr. 2024, doi: 10.31578/jtst.v8i1.151.
S.M. Haider, and M. Kashif, “Open Journal System,” Annals of Abbasi Shaheed Hospital and Karachi Medical & Dental College, vol. 24, no. 2, 2019, doi: 10.58397/ashkmdc.v24i2.30.
E. Bastianello, C. Tomlinson, and A. Adamou, “PubLink: Editorial Workflow for Digital Scholarly Publications in the Humanities,” in Proceedings of the 35th ACM Conference on Hypertext and Social Media, New York, NY, USA: ACM, Sep. 2024, pp. 318–322, doi: 10.1145/3648188.3677051.
T. Taipalus, “Database management system performance comparisons: A systematic literature review,” Journal of Systems and Software, vol. 208, pp. 111872, Feb. 2024, doi: 10.1016/j.jss.2023.111872.
L.J. Musap, “Enhancing scientific publishing: automatic conversion to JATS XML,” European Science Editing, vol. 2023, no. 49, 2023, doi: 10.3897/ese.2023.e114977.
A.M. Maatuk, T. Abdelaziz, and M. A. Ali, “Migrating relational databases into XML documents,” in Proceedings - 2020 21st International Arab Conference on Information Technology, ACIT 2020, 2020, doi: 10.1109/ACIT50332.2020.9299967.
R. Chen, G. Cai, J. Chen, and Y. Hong, “Integrated method for distributed processing of large XML data,” Cluster Comput, vol. 27, no. 2, 2024, doi: 10.1007/s10586-023-04010-0.
X. Sun, N. Li, and L. Zhang, “Automatic Generation of Test Documents Based on Knowledge Extraction,” in ACM International Conference Proceeding Series, 2022, doi: 10.1145/3524304.3524307.
S.C. Haw, L.J. Chew, D.S. Kusumo, P. Naveen, and K.W. Ng, “Mapping of extensible markup language-to-ontology representation for effective data integration,” IAES International Journal of Artificial Intelligence, vol. 12, no. 1, 2023, doi: 10.11591/ijai.v12.i1.pp. 432-442.
I.K. Raharjana, B. Zaman, O.I. Husna, R. Ferdiansyah, A.S. Putri, and F.D.K. Sari, “Improving reviewer selection in Open Journal Systems using a Scopus search application programming interface in the <i>Journal of Information System Engineering and Business Intelligence</i>,” Science Editing, vol. 12, no. 1, pp. 20–27, Feb. 2025, doi: 10.6087/kcse.356.
O. Odu, and A. Ekanger, “How we tried to JATS XML,” Ravnetrykk, no. 39, 2020, doi: 10.7557/15.5517.
H. Garcia-Gonzalez, and J.E. Labra-Gayo, “XMLSchema2ShEx: Converting XML validation to RDF validation,” Semant Web, vol. 11, no. 2, pp. 235–253, Feb. 2020, doi: 10.3233/SW-180329.
M. Beck, M. Schubotz, V. Stange, N. Meuschke, and B. Gipp, “Recognize, Annotate, and Visualize Parallel Content Structures in XML Documents,” in Proceedings of the ACM/IEEE Joint Conference on Digital Libraries, 2021, doi: 10.1109/JCDL52503.2021.00078.
Y. Cho, “Open-source code to convert Journal Article Tag Suite Extensible Markup Language (JATS XML) to various viewers and other XML types for scholarly journal publishing,” Science Editing, vol. 9, no. 2, 2022, doi: 10.6087/kcse.284.
C. Borchert, R. Cozatl, F. Eichler, A. Hoffmann, and M. Putnings, “Automatic XML Extraction from Word and Formatting of E-Book Formats: Insight into the Open Source Academic Publishing Suite (OS-APS),” Publications, vol. 11, no. 1, 2023, doi: 10.3390/publications11010001.