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.
Journal of Manufacturing Technology Management – Emerald Publishing
Published: Dec 1, 2005
Keywords: Management information systems; Manufacturing systems; Data handling; Modelling
It’s your single place to instantly
discover and read the research
that matters to you.
Enjoy affordable access to
over 18 million articles from more than
15,000 peer-reviewed journals.
All for just $49/month
Query the DeepDyve database, plus search all of PubMed and Google Scholar seamlessly
Save any article or search result from DeepDyve, PubMed, and Google Scholar... all in one place.
Get unlimited, online access to over 18 million full-text articles from more than 15,000 scientific journals.
Read from thousands of the leading scholarly journals from SpringerNature, Elsevier, Wiley-Blackwell, Oxford University Press and more.
All the latest content is available, no embargo periods.
“Hi guys, I cannot tell you how much I love this resource. Incredible. I really believe you've hit the nail on the head with this site in regards to solving the research-purchase issue.”Daniel C.
“Whoa! It’s like Spotify but for academic articles.”@Phil_Robichaud
“I must say, @deepdyve is a fabulous solution to the independent researcher's problem of #access to #information.”@deepthiw
“My last article couldn't be possible without the platform @deepdyve that makes journal papers cheaper.”@JoseServera