NDLI: Data warehouse design for manufacturing execution systems

Content Provider	IEEE Xplore Digital Library
Author	Kai-Ying Chen Teh-Chang Wu
Copyright Year	2005
Description	Author affiliation: Dept. of Ind. Eng. & Manage., Nat. Taipei Univ. of Technol. (Kai-Ying Chen)
Abstract	Manufacturing execution system (MES) is a computer application system that integrates all relevant real-time information along every step in a manufacturing process. Therefore, MES is essential for manufacturers for gathering real-time production line information, supporting manufacturing decision making and increasing manufacturing efficiency. In this paper, the functional modules and data schema for MES are investigated initially. And then, multi-dimensional data model and snowflake schema for MES data warehouse are constructed. On-line analytical processing (OLAP) cubes are designed for later implementation. The implementation case uses these cubes for analyzing equipment performance, WIP and quality, such as equipment MTBF, MTTR, operation cycle time, hold reason and hold quantity. Finally, some concluding remarks are made. The results of this research also provides a reference model for enterprises when MES is evaluated as a to be system
Sponsorship	IEEE Ind. Electron. Soc. (IES) Chinese Inst. of Autom. Eng. (CIAE) Nat. Sci. Council, Taiwan, R.O.C. Minist. of Educ., Taiwan, R.O.C
Starting Page	751
Ending Page	756
File Size	880705
Page Count	6
File Format	PDF
ISBN	0780389980
DOI	10.1109/ICMECH.2005.1529355
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	2005-07-10
Publisher Place	Taiwan
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Data warehouses Manufacturing processes Computer aided manufacturing Computer integrated manufacturing Computer applications Real time systems Production Decision making Data models Performance analysis
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Using data mining technology to design an intelligent CIM system for IC manufacturing

ERP-based data warehouse model design

"Design Warehouse": a "data warehouse" for computer aided design

Design and Implementation of an Intelligent Manufacturing Execution System for Semiconductor Manufacturing Industry

A burst resolution technique for data streams management in the real-time data warehouse

Performance Prediction of Rolling Coil Based on Data Warehouse

Experimental studies in real-time, Monte Carlo simulation

A data warehouse for policy making: a case study

A methodology for the design of a fuzzy data warehouse

Data warehouse design for manufacturing execution systems

Similar Documents

Using data mining technology to design an intelligent CIM system for IC manufacturing

ERP-based data warehouse model design

"Design Warehouse": a "data warehouse" for computer aided design

Design and Implementation of an Intelligent Manufacturing Execution System for Semiconductor Manufacturing Industry

A burst resolution technique for data streams management in the real-time data warehouse

Performance Prediction of Rolling Coil Based on Data Warehouse

Experimental studies in real-time, Monte Carlo simulation

A data warehouse for policy making: a case study

A methodology for the design of a fuzzy data warehouse

Data warehouse design for manufacturing execution systems