Abstract:PurposeSince 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/approachExtended entity‐relationship (EER) model technique is adopted to build the data model of MES.FindingsBased 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/implicationsThe 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 implicationsA 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/valueThis 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.

Building Database Model for Purchase-Sale-storage System with ER/Studio

UML-based Modeling and Implementing of Sales Management in Auto Parts Trade

Data Model Design for Manufacturing Execution System

Database Design of Communication Station by Using PowerDesigner

Information Modeling for Product Customization Platform Based on Parts Library

Conceptual Modeling for Moving Objects Database Applications

The Design and Implement of a Purchase , Sales and Inventory System Based on Data Warehouse Technology

Modeling Business for MDA Software Paradigm

Configuration Design Oriented Product Function-Structure Modeling

Distributed Multi-layer Architecture in Paper Mill Sales Management Information System

A Unified Modeling Language-Based Design And Application For A Library Management Information System

Storage and Retrieval of Business Process Simulation Models Based on IDEF3

Research on Book Purchasing Process Based on Erp

Research and Design of Computer Lab Maintenance System Based on UML

Design the Data Warehouse Conceptual Models

A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model

Design and Development of Professional Fruit-Marketplace's ERP System

Data Model Research of Complex Configured Product Based on UML

The Design of ERP Intelligent Sales Management System

Manufacturing Plant Management Information System Analysis and Design Based on UML

Research on Sysml-Based Modeling for Production Management System