An Empirical Study by Applying Ontology on Database Administration of Enterprise Resource Planning

• Main Authors: Ya-Hsun Huang, 黃雅焄
• Other Authors: Jau-Ji Shen
• Format: Others
• Language: zh-TW
• Published: 2019
• Online Access: http://ndltd.ncl.edu.tw/cgi-bin/gs32/gsweb.cgi/login?o=dnclcdr&s=id=%22107NCHU5396012%22.&searchmode=basic

碩士 === 國立中興大學 === 資訊管理學系所 === 107 === The enterprise resource planning (ERP) system is applied to medium and large enterprises domestically and abroad. The ERP system has all of the management processes needed for business operations, and its functions involve large quantities of data tables and reports. For daily operations, there are basic maintenance costs for the database administrator (DBA), and relatively higher maintenance costs must be invested if new reports are needed. This study aims to construct a data table ontology and a report ontology chart via the ontology representation technique, and use these two ontology and field dictionary to determine the relationship between the data tables and reports during the daily operations of the company. The objective is to enable the DBA or software engineers to find the correct data table’s fields more efficiently when new reports are needed in order to reduce the errors and time costs associated with demand analysis. The results of this study can also serve as a reference for constructing automated ontology charting tools in the future.