IDEAS home Printed from https://ideas.repec.org/a/gam/jsusta/v15y2023i7p6319-d1117621.html
   My bibliography  Save this article

Knowledge Retrieval Model Based on a Graph Database for Semantic Search in Equipment Purchase Order Specifications for Steel Plants

Author

Listed:
  • Ho-Jin Cha

    (Graduate Institute of Ferrous and Energy Materials Technology, Pohang University of Science and Technology (POSTECH), 77 Cheongam-Ro, Nam-Ku, Pohang 37673, Republic of Korea
    Kwangyang Rolling Mill Automation Group, POSCO ICT, 68 Hodong-ro, Nam-Ku, Pohang 37861, Republic of Korea)

  • So-Won Choi

    (Graduate Institute of Ferrous and Energy Materials Technology, Pohang University of Science and Technology (POSTECH), 77 Cheongam-Ro, Nam-Ku, Pohang 37673, Republic of Korea)

  • Eul-Bum Lee

    (Graduate Institute of Ferrous and Energy Materials Technology, Pohang University of Science and Technology (POSTECH), 77 Cheongam-Ro, Nam-Ku, Pohang 37673, Republic of Korea
    Department of Industrial and Management Engineering, Pohang University of Science and Technology (POSTECH), 77 Cheongam-Ro, Nam-Ku, Pohang 37673, Republic of Korea)

  • Duk-Man Lee

    (AI (Artificial Intelligence) Research & Development Institute, POSCO Holdings, 440 Teheran-ro, Gangnam-gu, Seoul 06194, Republic of Korea)

Abstract

The complexity and age of industrial plants have prompted a rapid increase in equipment maintenance and replacement activities in recent years. Consequently, plant owners are challenged to reduce the process and review time of equipment purchase order (PO) documents. Currently, traditional keyword-based document search technology generates unintentional errors and omissions, which results in inaccurate search results when processing PO documents of equipment suppliers. In this study, a purchase order knowledge retrieval model (POKREM) was designed to apply knowledge graph (KG) technology to PO documents of steel plant equipment. Four data domains were defined and developed in the POKREM: (1) factory hierarchy, (2) document hierarchy, (3) equipment classification hierarchy, and (4) PO data. The information for each domain was created in a graph database through three subprocesses: (a) defined in a hierarchical structure, (b) classified into nodes and relationships, and (c) written in triples. Ten comma-separated value (CSV) files were created and imported into the graph database for data preprocessing to create multiple nodes. Finally, rule-based reasoning technology was applied to enhance the model’s contextual search performance. The POKREM was developed and implemented by converting the Neo4j open-source graph DB into a cloud platform on the web. The accuracy, precision, recall, and F1 score of the POKREM were 99.7%, 91.7%, 100%, and 95.7%, respectively. A validation study showed that the POKREM could retrieve accurate answers to fact-related queries in most cases; some incorrect answers were retrieved for reasoning-related queries. An expert survey of PO practitioners indicated that the PO document review time with the POKREM was reduced by approximately 40% compared with that of the previous manual process. The proposed model can contribute to the work efficiency of engineers by improving document search time and accuracy; moreover, it may be expandable to other plant engineering documents, such as contracts and drawings.

Suggested Citation

  • Ho-Jin Cha & So-Won Choi & Eul-Bum Lee & Duk-Man Lee, 2023. "Knowledge Retrieval Model Based on a Graph Database for Semantic Search in Equipment Purchase Order Specifications for Steel Plants," Sustainability, MDPI, vol. 15(7), pages 1-37, April.
  • Handle: RePEc:gam:jsusta:v:15:y:2023:i:7:p:6319-:d:1117621
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2071-1050/15/7/6319/pdf
    Download Restriction: no

    File URL: https://www.mdpi.com/2071-1050/15/7/6319/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Yeu-Shiang Huang & Rong-Shuan Ho & Chih-Chiang Fang, 2015. "Quantity discount coordination for allocation of purchase orders in supply chains with multiple suppliers," International Journal of Production Research, Taylor & Francis Journals, vol. 53(22), pages 6653-6671, November.
    2. Liu, Jintao & Schmid, Felix & Li, Keping & Zheng, Wei, 2021. "A knowledge graph-based approach for exploring railway operational accidents," Reliability Engineering and System Safety, Elsevier, vol. 207(C).
    3. Haichao Huang & Zhouzhenyan Hong & Huiming Zhou & Jiaxian Wu & Ning Jin, 2020. "Knowledge Graph Construction and Application of Power Grid Equipment," Mathematical Problems in Engineering, Hindawi, vol. 2020, pages 1-10, October.
    4. Stefan Bock & Filiz Isik, 2015. "A new two-dimensional performance measure in purchase order sizing," International Journal of Production Research, Taylor & Francis Journals, vol. 53(16), pages 4951-4962, August.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Xia, Liqiao & Liang, Yongshi & Leng, Jiewu & Zheng, Pai, 2023. "Maintenance planning recommendation of complex industrial equipment based on knowledge graph and graph neural network," Reliability Engineering and System Safety, Elsevier, vol. 232(C).
    2. Dindar, Serdar & Kaewunruen, Sakdirat & An, Min, 2022. "A hierarchical Bayesian-based model for hazard analysis of climate effect on failures of railway turnout components," Reliability Engineering and System Safety, Elsevier, vol. 218(PA).
    3. Chaoxun Cai & Shiyu Tian & Yuefeng Shi & Yongjun Chen & Xiaojian Li, 2024. "Influencing Factors Analysis in Railway Engineering Technological Innovation under Complex and Difficult Areas: A System Dynamics Approach," Mathematics, MDPI, vol. 12(13), pages 1-20, June.
    4. Claudio Vitari & Elisabetta Raguseo, 2019. "Big data analytics business value and firm performance: Linking with environmental context," Post-Print hal-02293765, HAL.
    5. Singh, Prashant & Pasha, Junayed & Moses, Ren & Sobanjo, John & Ozguven, Eren E. & Dulebenets, Maxim A., 2022. "Development of exact and heuristic optimization methods for safety improvement projects at level crossings under conflicting objectives," Reliability Engineering and System Safety, Elsevier, vol. 220(C).
    6. Purva Grover & Arpan Kumar Kar, 2017. "Big Data Analytics: A Review on Theoretical Contributions and Tools Used in Literature," Global Journal of Flexible Systems Management, Springer;Global Institute of Flexible Systems Management, vol. 18(3), pages 203-229, September.
    7. Liu, Jintao & Chen, Keyi & Duan, Huayu & Li, Chenling, 2024. "A knowledge graph-based hazard prediction approach for preventing railway operational accidents," Reliability Engineering and System Safety, Elsevier, vol. 247(C).
    8. Yan, Dongyang & Li, Keping & Zhu, Qiaozhen & Liu, Yanyan, 2023. "A railway accident prevention method based on reinforcement learning – Active preventive strategy by multi-modal data," Reliability Engineering and System Safety, Elsevier, vol. 234(C).
    9. Mei Liu & Boning Li & Hongjun Cui & Pin-Chao Liao & Yuecheng Huang, 2022. "Research Paradigm of Network Approaches in Construction Safety and Occupational Health," IJERPH, MDPI, vol. 19(19), pages 1-22, September.
    10. Shuangsheng Wu & Qi Li, 2021. "Emergency Quantity Discount Contract with Suppliers Risk Aversion under Stochastic Price," Mathematics, MDPI, vol. 9(15), pages 1-12, July.
    11. Valcamonico, Dario & Baraldi, Piero & Zio, Enrico & Decarli, Luca & Crivellari, Anna & Rosa, Laura La, 2024. "Combining natural language processing and bayesian networks for the probabilistic estimation of the severity of process safety events in hydrocarbon production assets," Reliability Engineering and System Safety, Elsevier, vol. 241(C).
    12. Gu, Shuang & Li, Keping & Feng, Tao & Yan, Dongyang & Liu, Yanyan, 2022. "The prediction of potential risk path in railway traffic events," Reliability Engineering and System Safety, Elsevier, vol. 222(C).
    13. Ilkyeong Moon & Yoon Jea Jeong & Subrata Saha, 2020. "Investment and coordination decisions in a supply chain of fresh agricultural products," Operational Research, Springer, vol. 20(4), pages 2307-2331, December.
    14. Junlin Hu & Weixiang Zhou & Pengjun Zheng & Guiyun Liu, 2024. "A Novel Approach for the Analysis of Ship Pollution Accidents Using Knowledge Graph," Sustainability, MDPI, vol. 16(13), pages 1-26, June.
    15. Ghoudi, Kilani & Hamdouch, Younes & Boulaksil, Youssef & Hamdan, Sadeque, 2024. "Supply chain coordination in a dual sourcing system under the Tailored Base-Surge policy," European Journal of Operational Research, Elsevier, vol. 317(2), pages 533-549.
    16. Yashar Kor & Liang Tan & Petr Musilek & Marek Z. Reformat, 2023. "Integrating Knowledge Graphs into Distribution Grid Decision Support Systems," Future Internet, MDPI, vol. 16(1), pages 1-18, December.
    17. Arunachalam, Deepak & Kumar, Niraj & Kawalek, John Paul, 2018. "Understanding big data analytics capabilities in supply chain management: Unravelling the issues, challenges and implications for practice," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 114(C), pages 416-436.
    18. Zhang, Hengqi & Geng, Hua & Zeng, Huarong & Jiang, Li, 2023. "Dynamic risk evaluation and control of electrical personal accidents," Reliability Engineering and System Safety, Elsevier, vol. 237(C).
    19. Zhang, Hengqi & Geng, Hua, 2023. "A methodology to identify and assess high-risk causes for electrical personal accidents based on directed weighted CN," Reliability Engineering and System Safety, Elsevier, vol. 231(C).
    20. Liu, Yanyan & Li, Keping & Yan, Dongyang, 2024. "Quantification analysis of potential risk in railway accidents: A new random walk based approach," Reliability Engineering and System Safety, Elsevier, vol. 242(C).

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jsusta:v:15:y:2023:i:7:p:6319-:d:1117621. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.