{"title":"Database Construction and SPC Technology for Solder Paste Defect Inspection","authors":"Min Qi, Xin Chang, Yuelei Xu, Lechi Zhang","doi":"10.1145/3282286.3282304","DOIUrl":null,"url":null,"abstract":"This paper puts forward a method to construct a certain database for the process of solder paste defect inspection to sort and process various kinds of printing defect information, and realizes the data monitoring by Statistical Process Control (SPC) technology. Firstly, establish an appropriate database by SQL Server Management Studio for different kinds of printing defect information, such as excess solder, insufficient solder, solder missing, solder splash, solder offset, etc. Then, build the report server by SQL Server Business Intelligence Development Studio. Finally, complete the drawing of attribute control chart and variable control chart combining the theory of SPC. These different charts reflect the probability of various kinds of defects and their distribution in enterprise production. The new method improves the process control ability of enterprises in the production process scientifically and excellently.","PeriodicalId":324982,"journal":{"name":"Proceedings of the 2nd International Conference on Graphics and Signal Processing","volume":"394 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-10-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 2nd International Conference on Graphics and Signal Processing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3282286.3282304","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
This paper puts forward a method to construct a certain database for the process of solder paste defect inspection to sort and process various kinds of printing defect information, and realizes the data monitoring by Statistical Process Control (SPC) technology. Firstly, establish an appropriate database by SQL Server Management Studio for different kinds of printing defect information, such as excess solder, insufficient solder, solder missing, solder splash, solder offset, etc. Then, build the report server by SQL Server Business Intelligence Development Studio. Finally, complete the drawing of attribute control chart and variable control chart combining the theory of SPC. These different charts reflect the probability of various kinds of defects and their distribution in enterprise production. The new method improves the process control ability of enterprises in the production process scientifically and excellently.
提出了一种建立锡膏缺陷检测过程数据库的方法,对各种印刷缺陷信息进行分类处理,并通过统计过程控制(SPC)技术实现数据监控。首先,利用SQL Server Management Studio建立相应的数据库,针对不同类型的印刷缺陷信息,如焊料过量、焊料不足、焊料缺失、焊料飞溅、焊料偏移等。然后,利用SQL server Business Intelligence Development Studio构建报表服务器。最后,结合SPC理论,完成了属性控制图和变量控制图的绘制。这些不同的图表反映了各种缺陷的概率及其在企业生产中的分布。新方法科学、卓越地提高了企业在生产过程中的过程控制能力。