Data model design for manufacturing execution system

Journal of Manufacturing Technology Management

Volumn 16, Issue 8, 2005, Pages 909-935

  Zhou, Bing Hai ^a   Wang, Shi Jin ^a   Xi, Li Feng ^a  

^a SHANGHAI JIAO TONG UNIVERSITY   (China)

Author keywords

Data handling; Management information systems; Manufacturing systems; Modelling

Indexed keywords

COMPUTER SIMULATION; COMPUTER SOFTWARE; DATA ACQUISITION; DATA HANDLING; DATABASE SYSTEMS; DESIGN; INDUSTRIAL MANAGEMENT;

DATA MODEL; MANUFACTURING SYSTEMS; MES DEVELOPMENT; MODELLING;

MANAGEMENT INFORMATION SYSTEMS;

EID: 27744605086     PISSN: 1741038X     EISSN: None     Source Type: Journal    
DOI: 10.1108/17410380510627889     Document Type: Article

References (26)

1. Barry, J., Aparicio, M., Durniak, T., Herman, P., Karuturi, J., Woods, C., Gilman, C., Lam, H. and Ramnath, R. (1998), "NIIIP-SMART: an investigation of distributed object approaches to support MES development and deployment in a virtual enterprise", Enterprise Distributed Object Computing Workshop, EDOC '98 Proceedings, pp. 366-77.
2. Batini, C., Ceri, S. and Navathe, S. (1992), Conceptual Database Design, Benjamin/Cummings, Redwood City, CA.
3. Burggraaf, P. (1995), "MES software: preparing your questions", Semiconductor International, Vol. 18 No. 1, pp. 65-70.
4. Chen, P. (1997), "The entity-relationship model: towards a unified view of data", ACM Transactions on Database Systems, Vol. 1 No. 1, pp. 9-36.
5. Chung, S.L. and Jeng, M.D. (2002), "Manufacturing execution system (MES) for semiconductor manufacturing", IEEE International Conference on Systems, Man and Cybernetics, Vol. 4, pp. 7-11.
6. Czejdo, B., Elmasri, R., Rusinkiewicz, M. and Embley, D.W. (1990), "A graphical data manipulation language for an extended entity-relationship model", IEEE Computer, Vol. 23 No. 3, pp. 26-35.
7. David, J.A. and Joe, H. (1995), "Does a manufacturing execution system reduce the cost of production for bulk pharmaceuticals", ISA Transactions, Vol. 34 No. 4, pp. 343-7.
8. Deuel, A.C. (1994), "Benefits of a MES for plant wide automation", ISA Transactions, Vol. 33 No. 10, pp. 123-9.
9. Fahrner, C. and Vossen, G. (1995), "A survey of database design transformations based on the entity-relationship model", Data & Knowledge Engineering, Vol. 15 No. 3, pp. 213-50.
10. Hori, M., Kawamura, T. and Okano, A. (1999), "OpenMES: scalable manufacturing execution framework based on distributed object computing", Systems, Man, and Cybernetics, IEEE SMC '99 Conference Proceedings, Vol. 6, pp. VI-398-VI-403.
11. Kolp, M. and Zimányi, E. (2000), "Enhanced ER to relational mapping and interrelational normalization", Information and Software Technology, Vol. 42 No. 15, pp. 1057-73.
12. Liao, C. and Palvia, P. (2000), "The impact of data models and task complexity on end-user performance: an experimental investigation", International Journal of Human-Computer Studies, Vol. 52 No. 5, pp. 831-45.
13. Markowitz, V. and Makowsky, J. (1990), "Identifying extended entity-relationship object structures in relational schemas", IEEE Transactions on Software Engineering, Vol. 16 No. 8, pp. 777-90.
14. Martin, G. and Uwe, H. (1991), "Towards a semantic view of an extended entity-relationship model", ACM Transactions on Database Systems, Vol. 16 No. 3, pp. 369-416.
15. MESA International White paper (1997), MES Explained: A High Level Vision, White Paper, 6 MESA International White paper, September.
16. Reda, A. (2003), "Extracting the extended entity-relationship model from a legacy relational database", Information Systems, Vol. 28 No. 6, pp. 597-618.
17. Rochfeld, A. and Negros, P. (1992), "Relationship of relationship and other interrelationship links in ER models", Data & Knowledge Engineering, Vol. 9 No. 2, pp. 205-21.
18. Saiedian, H. (1997), "Evaluation of extended entity-relationship model", Information and Software Technology, Vol. 39 No. 7, pp. 449-62.
19. Sabuncuoglu, I. and Bayiz, M. (1999), "Job shop scheduling with beam search", European Journal of Operational Research, Vol. 118 No. 2, pp. 390-412.
20. Shoval, P. and Shiran, S. (1997), "Entity-relationship and object-oriented data modeling-an experimental comparison of design quality", Data & Knowledge Engineering, Vol. 21 No. 3, pp. 297-315.
21. Sieberg, J. and Walter, R. (2003), "A scheduling and resource optimizing MES for the semiconductor and MEMS industry", Advanced Semiconductor Manufacturing Conference and Workshop, ASMC03, IEEE/SEMI, Munich, pp. 101-5.
22. Steven, W. (1996), "Getting the MES model - methods for system analysis", ISA Transactions, Vol. 35 No. 2, pp. 95-103.
23. Teorey, T.J., Yang, D. and Fry, J.P. (1986), "A logical design methodology for relational database using the extended entity-relationship model", ACM Computing Survey, Vol. 18 No. 2, pp. 197-222.
24. Victor, M. and Arie, S. (1992), "Representing extended entity-relationship structures in relational databases: a modular approach", ACM Transactions on Database Systems, Vol. 17 No. 3, pp. 423-64.
25. Zhou, B.H., Zhou, X.J., Cai, J.G. and Feng, K. (2002), "Beam search-based algorithm for flexible manufacturing system scheduling", Journal of Dong Hua University, Vol. 19 No. 3, pp. 13-18.
26. Zhou, B.H., Xi, L.F. and Cao, Y.S. (2004), "A beam-search-based algorithm for the tool switching problem on a flexible machine", The International Journal of Advanced Manufacturing Technology, online.