The development of accurate database systems is fundamental for the support of any software, especially in knowledge- and data-driven applications. The paper presents a database system developed to support an integrated modelling framework definition for printed circuit board (PCB) assembly that can provide decision support to business processes throughout the product and process life cycle. Specifically, by adopting an integrated modelling framework within the PCB assembly manufacturing, complete and realistic data information models were obtained and organized using a relational database management system implemented in Structured Query Language. This database system in turn supports a set of software applications implemented as part of a decision support framework, in this case known as CLOVES (Complex Low Volume Electronics Simulation). The underlying database is open, extensible, and has the ability to be configurable by original equipment manufacturers and contract electronics manufacturers to update their materials, processes, and rules. Integration to a company's enterprise resource planning system and its deployment in quality, simulation, and failure analyses call for the improvement of electronics manufacturing industry data-exchange practices.
YusufY. Y.SarhadiM.GunasekaranA.Agile manufacturing: the drivers, concepts and attributes. Int. J. Prod. Econ., 1999, 62(1), 33–43.
2.
SihaS. M.Business process improvement: empirical assessment and extensions. Bus. Process Mgmt J., 2008, 14(6), 778–802.
3.
Huertas QuinteroL. A.WestA.VelandiaD. M.ConwayP. P.WilsonA.Integrated simulation tool for quality support in the low-volume high-complexity electronics manufacturing domain. Int. J. Prod. Res., 2010, 48(1), 45–68.
4.
Segura VelandiaD. M.ConwayP. P.MonfaredR. P.WestA. A.Combining business process and failure modelling to increase yield in electronics manufacturing. Proc. IMechE, Part B: J. Engineering Manufacture, 2011, 1–18. in press. DOI: 10.1243/09544054JEM1794.
5.
WassinkJ. K.VerguldM. F.Manufacturing techniques for surface mounted assemblies, 1995 (Electrochemical Publications, Port Erin, Isle of Man)510–510.
KrishnanS.SrihariK.A knowledge-based object oriented DFM advisor for surface mount PCB assembly. Int. J. Adv. Mfg Technol., 1995, 10(5), 317–329.
8.
PadhyS. K.DwivediS. N.An object-oriented knowledge-based system for manufacturability of printed wiring boards. Comput. Ind., 1992, 18(1), 77–89.
9.
Lawlor-WrightT.Design for testability of printed circuit board assemblies. Colloquium Digest – IEE, 1997, 16, 1–4.
10.
Lawlor-WrightT.GallagherC.Development of a printed circuit board design for in-circuit test advisory system. Comput. Ind., 1997, 33(2–3), 253–259.
11.
GaoJ.BennettG.The development of a rules-based CAPP system for electronic circuit assembly. Int. J. Comput. Applic. Technol., 1998, 11(6), 436–441.
12.
FidanI.CAPP for electronics manufacturing case study: fine pitch SMT laser soldering. J. Electron. Packag., 2004, 126(1), 173–176.
13.
BonfieldT.BarberM.A multiple-perspective design advisory system for use in the layout design of printed circuit board assemblies. IEEE Trans. Electron. Packag. Mfg, 2003, 26(2), 115–122.
14.
WuC.-H.SrihariK.Automated knowledge acquisition for the surface-mount PWB assembly domain. J. Intell. Mfg, 1996, 7(5), 393–398.
15.
RamakrishnanS.SrihariK.WestbyG. R.Manufacturing-Electronics. A decision support system for the alternative assembly and reflow technology process. Comput. Ind. Engng, 1998, 35(1–2), 61–622.
16.
WuC.-H.KaoS.-C.SrihariK.GDKAT: a goal-driven knowledge acquisition tool for knowledge base development. Expert Syst., 2000, 17(2), 90–105.
17.
YangT.TsaiT.Modeling and implementation of a neurofuzzy system for surface mount assembly defect prediction and control. IIE Trans., 2002, 34(7), 637–646.
18.
WestA.HindeC.MessomC.HarrisonR.WilliamsD.Design issues associated with neural network systems applied within the electronics manufacturing domain. J. Electron. Mfg, 2000, 10(1), 19–48.
ClarkA. J.WhiteA. J.LeaneyP. G.WycherleyA. J.A quality modeling system for predicting the yield of assembly and test processes in the printed circuit assembly industry. J. Electron. Mfg, 1995, 5(2), 75–87.
21.
JooY.BartonR. R.Integrated product and process design through feedback of manufacturing experience. Comput. Ind. Engng, 1995, 28(3), 561–573.
22.
LiY.MahajanR. L.TongJ.Design factors and their effect on PCB assembly yield – statistical and neural network predictive models. In Proceedings of IEEE/CHMT European International Electronic Manufacturing Technology Symposium, 4–6 October, 1993 (Santa Clara, CA, USA) 353–361.
23.
CunninghamP.SmithB.BonzanoA.An incremental retrieval mechanism for case-based electronic fault diagnosis. J. Knowl. Based Syst., 1998, 11(3), 239–248.
24.
LeeC. K. M.LauH. C. W.YuK. M.An object-based knowledge integration system for product development: a case study. J. Mfg Technol. Mgmt, 2005, 16(2), 156–177.
25.
TsaiC.-Y.ChiuC.-C.ChenJ.-S.A case-based reasoning system for PCB defect prediction. Expert Syst. Applic., 2005, 28(4), 813–822.
26.
Vollrath, I. Reuse of complex electronic designs. Requirements analysis for a CBR application. In Proceedings of the Fourth European Workshop on Case-based reasoning, Dublin, Ireland, 23–25 September 1998 (Springer Verlag, Berlin).
27.
Segura VelandiaD. M.WestA. A.ConwayP. P.WhalleyD. C.A case-based reasoning approach for low volume, high added value electronics. In Proceedings of 8th Electronics Packaging Technology Conference (EPTC 2006), Singapore, 2006.
28.
NagarajanK.SantosD. L.SrihariK.A cost estimation tool for BGA and DCA technology. In Proceedings of the 1996 International Electronics Packaging Conference, Austin, TexasSeptember–2 October1996.
29.
GnanasambandamN.PrimaveraA.SrihariK.The reliability prediction of electronic packages: an expert systems approach. Int. J. Adv. Mfg Technol., 2005, 27(3–4), 381–391.
30.
TsengT.-L. B.JothishankarM. C.WuT. T.Quality control problem in printed circuit board manufacturing – an extended rough set theory approach. J. Mfg Syst., 2004, 23(1), 56–72.
31.
Di MaioD.NEW! The Defects Database – defect analysis, online and interactive. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2008, 19(11), 43–43. available from http://defectsdatabase.npl.co.uk/defectsdb/defects_query.php.
32.
Di MaioD.The Defects Database – plating adhesion problems. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2009, 20(1), 43–43.
33.
Di MaioD.The Defects Database – paste residue and solvent incompatibilities. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2008, 19(12), 39–39.
34.
Di MaioD.The Defects Database – lead contamination. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2009, 20(4), 41–41.
35.
Di MaioD.The Defects Database – flux shorts on BGAs. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2009, 20(6), 43–43.
36.
Di MaioD.The Defects Database – conformal coating cracking. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2009, 20(3), 36–36.
37.
Di MaioD.The Defects Database – broken traces near PBGAs. Circuits Assembly: The Magazine for Surface-mount & Board-level Assembly, 2009, 20(5), 26–26.
38.
MonfaredR. P.Enterprise modelling: A component-based approach to design and construction of change capable manufacturing cell control systems, edition 1, 2009 (VDM Verlag, Saarbrücken, Germany).
39.
Monfared, R. P. Practical application of enterprise modelling, Wolfson School of Mechanical and Manufacturing Engineering, Loughborough University, Loughborough, UK, 2003.
40.
VernadatF. B.Enterprise modeling and integration principles and applications, 1996 (Chapman & Hall, London).
41.
BerioG.VernadatF. B.New developments in enterprise modelling using CIMOSA. Comput. Ind., 1999, 40(2–3), 99–114.
42.
KosankeK.VernadatF.ZelmM.CIMOSA: enterprise engineering and integration. Comput. Ind., 1999, 40(2–3), 83–97.
43.
CIMOSA Association. CIMOSA Technical Baseline, version 3.2. CIMOSA: A primer on key concepts, purpose and business value, 1996 (CIMOSA Association), available from http://cimosa.cnt.pl/Docs/Primer/primer5.htm.
44.
ThiraviamA. R.Simple tools for complex systems: basic tools, such as process maps and Pareto charts, can make a difference and help correct noncomformance in complex settings. Qual. Progr., 2006, 39(6), 40–46.
45.
ShinaS. G.Six Sigma for electronics design and manufacturing, 2002 (McGraw-Hill Professional, New York, USA).
46.
IPC. IPC 9261, In-process DPMO and estimated yield for PWAs, 2002 (IPC, Illinois, USA).
47.
MannilaH.Methods and problems in data mining. Lecture Notes Comput. Sci., 1997, 1186, 41–41.
48.
IPC. IPC 7351A, Generic requirements for surface mount design and land pattern standards, 2007 (IPC, Illinois, USA).
49.
WhalleyD.A simplified reflow soldering process model. J. Mater. Process. Technol., 2004, 150(1–2), 134–144.
50.
WilsonA. R.WestA. A.Segura VelandiaD. M.ConwayP. P.WhalleyD. C.Huertas QuinteroL. A. M.MonfaredR. P.Characterization of printed solder paste excess and bridge related defects. In Proceedings of the 2nd Electronics System Integration Technology Conference (ESTC 2008), Greenwich, UK, 1–4 September 2008..
Huertas QuinteroL. A. M.WestA. A.Segura VelandiaD. M.A hierarchical object oriented software structure for manufacturing simulation. In Proceedings of Industrial Simulation Conference, Loughborough, UK, 1–3 June 2009. .
54.
Segura VelandiaD. M.MonfaredR. P.WestA.ConwayP. P.WhalleyD. C.Huertas QuinteroL. A. M.Role of CAD post-processing in a quality tool for low volume high-complexity electronics manufacture. In Proceedings of the 10th International IEEE Electronics Packaging Technology Conference, Singapore, 9–12 December 2008 .
IPC. IPC-2581 – with Amendment 1. Generic Requirements for Printed Board Assembly Products Manufacturing Description Data and Transfer Methodology, 2007, available from http://webstds.ipc.org/2581/2581.htm.
