Construction of Data Warehouse Platform in Continual Quality Improvement

Article Preview

Abstract:

Aiming at improving product quality continually, we proposed an association rules mining system (ARMS) based on idea of PDCA cycling. Data warehouse is very useful for integrating heterogeneous database. Therefore, this paper designed a data warehouse platform as process data exchange module in ARMS. The role of data warehouse platform module is to integrate XML with enterprise process for realizing process data exchange among departments. In design of data warehosue, this paper chooses three-tier data warehouse structure and snowflake schema for indicating the complex relation between process data.

You might also be interested in these eBooks

Info:

Periodical:

Pages:

13-16

Citation:

Online since:

February 2014

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2014 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] Sterjovski, Z., Nolan, D., Carpenter, D.P. Dunne., &Norrish, J. Artificial neural networks for modeling the mechanical properties of steels in various applications [J]. Journal of Materials Processing Technology, 2005, 170(30): 536-544.

DOI: 10.1016/j.jmatprotec.2005.05.040

Google Scholar

[2] Abburi, N.R., Dixit, U.S. A knowledge based system for the prediction of surface roughness in turning process [J]. Robotics and Computer-Integrated Manufacturing, 2006, 22: 363-372.

DOI: 10.1016/j.rcim.2005.08.002

Google Scholar

[3] Li, Erguo, Jia, Li, Yu, Jinshou. A genetic neural fuzzy system-based quality prediction model for injection process [J]. Computers and Chemical Engineering, 2002, 26: 1253-1263.

DOI: 10.1016/s0098-1354(02)00092-3

Google Scholar

[4] Lou, Helen H., Huang, Yinlun L. Hierarchical decision making for proactive quality control: System development for defect reduction in automotive coating operation [J]. Engineering Application of Artificial Intelligence, 2003, 16: 237-250.

DOI: 10.1016/s0952-1976(03)00060-5

Google Scholar

[5] W.H. Inmon. Building the Data Warehouse (Second Edition). Beijing: machine press, 2000. 20-45.

Google Scholar