Data model design for manufacturing execution system

Bing‐hai Zhou (Department of Industrial Engineering, School of Mechanical Engineering, Shanghai Jiaotong University, Shanghai, People's Republic of China)
Shi‐jin Wang (Department of Industrial Engineering, School of Mechanical Engineering, Shanghai Jiaotong University, Shanghai, People's Republic of China)
Li‐feng Xi (Department of Industrial Engineering, School of Mechanical Engineering, Shanghai Jiaotong University, Shanghai, People's Republic of China)

Journal of Manufacturing Technology Management

ISSN: 1741-038X

Publication date: 1 December 2005

Abstract

Purpose

Since the data model plays an important role in designing manufacturing execution system (MES) database, this paper seeks to provide a generic and adaptable data model for MES, which can facilitate and improve the MES development.

Design/methodology/approach

Extended entity‐relationship (EER) model technique is adopted to build the data model of MES.

Findings

Based on MES functions and database requirement analysis, four subject's structures of MES database is abstracted from a system integration point of view. These four structures are independent relatively but also have close interrelation. Each structure is modeled with EER model.

Research limitations/implications

The presented data model mainly focuses on discrete manufacturing MES, which perhaps limits its usefulness elsewhere, and the data model still need further testing in manufacturing enterprises with different scales.

Practical implications

A prototype MES system is developed and implemented, the results show that the proposed EER modeling approach can establish and make clear complex relationships among entities existed in a manufacturing system, which lays the foundation for adaptable and modular MES software development and implementation.

Originality/value

This paper fulfils a fundamental need of designing data model for MES and provides a main framework for developing MES data model, which provides reference for researches both in academia and industry to build specific relational data models for specific needs.

Keywords

Citation

Zhou, B., Wang, S. and Xi, L. (2005), "Data model design for manufacturing execution system", Journal of Manufacturing Technology Management, Vol. 16 No. 8, pp. 909-935. https://doi.org/10.1108/17410380510627889

Download as .RIS

Publisher

:

Emerald Group Publishing Limited

Copyright © 2005, Emerald Group Publishing Limited

Please note you might not have access to this content

You may be able to access this content by login via Shibboleth, Open Athens or with your Emerald account.
If you would like to contact us about accessing this content, click the button and fill out the form.
To rent this content from Deepdyve, please click the button.