基于WEB的零件生产流程质量追踪查询系统的研究与开发

发布时间：2019-01-13 08:21

【摘要】：随着经济全球化的发展和国际分工的推进,制造企业正面临着日益激烈的国际竞争,企业在获得极大发展空间的同时也承受着威胁和挑战。企业的核心竞争力集中体现在企业所提供的产品上,体现在产品的质量、价格、交货期上。这要求企业在提高产品质量,降低成本的同时,缩短供货时间,迅速有效地进入市场,并不断适应市场的变化,在竞争中取胜。生产制造管理作为形成产品的主要过程,是影响产品质量、价格、交货期的决定因素,它必然是构成企业核心竞争力的关键。本文首先对质量追踪系统的概念和内涵、国内外研究及应用进行综述。之后对依托制造执行系统的质量追踪系统的相关技术,包括系统平台搭建、WEB相关开发及系统测试等进行了介绍。通过对时下比较流行的WEB数据库进行比较与排除,选出了适合于数据仓库的数据库配置,设计出一套可以通过WEB画面直接定义检索结果输出的参数接口定义以及数据查询功能。另外,综合现行的WEB服务器配置方案,将本系统从制造执行系统中剥离出来,进行单独构建。即定位于脱离制造执行系统自身的跟踪查询体系,借用制造执行系统管理数据库的外部接口,开发着眼于自定义WEB检索模式、数据查询、以及报表打印的功能的生产流程质量追踪查询系统。致力于查询的轻量化,提高系统灵活性,提高数据库检索效率,自定义检索、输出与打印。系统将使用统一的数据库、通过网络联接可以同时为生产部门、质检部门、工艺部门等提供产品质量管理信息服务;废除人工报表,并对产品的质量检测数据进行查询、统计和分析,精确区分产品质量的随机波动与异常波动,将质量隐患消灭于萌芽之中,保证产品质量。
[Abstract]:With the development of economic globalization and the promotion of international division of labor, manufacturing enterprises are facing increasingly fierce international competition. The core competence of the enterprise is embodied in the products provided by the enterprise, in the quality, price and delivery time of the product. This requires enterprises to improve product quality, reduce costs, shorten the supply time, quickly and effectively enter the market, and constantly adapt to market changes, win in the competition. As the main process of forming products, manufacturing management is the decisive factor that affects the quality, price and delivery time of products. It is the key to constitute the core competitiveness of enterprises. In this paper, the concept and connotation of quality tracking system, research and application at home and abroad are reviewed. Then the related technology of quality tracking system based on manufacturing execution system is introduced, including system platform construction, WEB development and system testing. By comparing and excluding the popular WEB database, the database configuration suitable for data warehouse is selected, and a set of parameter interface definition and data query function which can directly define the retrieval result output through WEB screen are designed. In addition, according to the current WEB server configuration scheme, the system is separated from the manufacturing execution system and constructed separately. That is, it is located in the tracking query system which is independent of the manufacturing execution system itself, and the external interface of the manufacturing execution system management database is used to develop the self-defined WEB retrieval mode and data query. And report printing function of the production process quality tracking query system. We focus on lightweight query, improve system flexibility, improve the efficiency of database retrieval, custom retrieval, output and print. The system will use unified database, through the network connection can simultaneously provide the product quality management information service for the production department, the quality inspection department, the craft department and so on; The artificial report form is abolished, and the product quality test data are queried, counted and analyzed, the random fluctuation and abnormal fluctuation of product quality are accurately distinguished, the hidden trouble of quality is eliminated in the bud, and the product quality is guaranteed.
【学位授予单位】：天津大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：TP311.52;TP393.09

【参考文献】