Database Translation Mechanism: Generating Data Dictionary for Relational Database

Abstract

PDF HTML XML Export Cite reminder Database Translation Mechanism: Generating Data Dictionary for Relational Database DOI: 10.21655/ijsi.1673-7288.00291 Author: Affiliation: Clc Number: Fund Project: Article | Figures | Metrics | Reference | Related | Cited by | Materials | Comments Abstract:In order to optimize workflow and improve efficiency, modern enterprises usually entrust software providers to build the Enterprise Information System (EIS). However, the software providers generally do not provide the data dictionary for the EIS relational database, which brings great difficulties for enterprises to use the data stored in the EIS database. This paper proposes a method named database translation mechanism for generating the data dictionary of the EIS relational database which only utilizes the data collected from the interfaces of EIS. Inspired by the great success that Graph Neural Networks (GNNs) have achieved, the study builds a graph structure for the EIS relational database by mining the relationships between columns and then train a GNN-based classifier to predict to which column the value belongs. In addition, a table-based sampling method is designed to construct graph datasets for mini-batch training on the large-scale graph structure. Furthermore, a uniform encoding method and a hybrid aggregator function are proposed to improve the performance of the GNN-based classifier. The trained GNN-based classifier can be used to predict the matching relationships between the columns of the EIS database and the tables extracted from the EIS interfaces given the fact that the data in the database is entered at the interfaces. In this way, the detailed information at the interface to translate the database can be used. Experimental results on a real-world ERP relational database demonstrate the superior performance of the proposed method, which efficiently exploits and utilizes the graph structure information in the relational database. Reference Related Cited by