线束测试管理系统的开发与实现
摘要
线束测试仪是一种保证线束质量和可靠性的最基本的测试仪器,它通过线束导通测试的方法可剔除存在短路、断路、误配线、接触不良和瞬间断路等故障的早期失效产品,提高产品质量,因而广泛应用于家用电器、通讯设备、飞机、汽车和军用仪器设备的线束测试中。
本论文介绍了基于数据库的线束测试管理系统的研发过程,采用面向对象的程序开发思想,结合规范化的数据库设计流程对线束测试管理系统进行设计,重点讨论了线束测试、信息管理和通信功能几个重要模块的研发过程。
论文首先阐述了课题背景和线束测试仪的国内外现状,介绍了项目所采用的数据库系统的特点。然后分析了线束测试的基本原理和几种基本的失效模式,对线束测试仪进行了需求分析以及线束测试系统硬件结构和软件结构的分析,随后描述了线束测试管理系统的实现方案。第三部分根据数据库系统的规范化设计方法来设计线束测试管理系统的概念模型、分析信息的数据流图、指定数据库存取方法的选取。第四部分为本论文的重点章节,主要介绍了线束测试管理系统中三个重要功能模块的设计过程。包括线束测试功能模块、信息管理功能模块和通信功能模块的实现过程,并给出了部分功能模块运行的结果。
本论文开发的线束测试管理系统,能管理并存储线束测试的大量数据,方便操作人员查看线束测试情况和演示在线测试过程,并且能随时更新数据库,从而可以测试多种类型的线束,其应用前景十分广阔。
Wiring harness test instrument is a kind of device that is responsible for quality and reliability of wiring harness. By connection test principle it can eliminate invalidation products that can not work properly for their failure, such as open circuit,short circuit, wrong connection, loose connection and instant open circuit. As a result it improves quality of product. Now this kind of device is widely used in wiring harness test of household appliances, communication devices, aero plane, cars, and military equipment.
This dissertation mainly introduce the wiring harness management system based on database. The system is designed according to the developing concept of object-orient and standard developing process of database design. The modules of wiring harness test, formation management and communication are mainly discussed in this paper.
First, the background about this project is discussed , then the database system and the wiring harness management system are introduced in this dissertation. Second, the basic principles and invalid modes of the wiring harness check management system are analyzed including the requirement specification. Third, the models of wiring harness management system is designed and the data flow charts for information analysis are designed and the storage manner of the database is pointed out according to the standard developing process of database design. At last, the designing processes of the three important function modules in this system are introduced, including wiring harness test, information management and communication module.
With this software of wiring harness test management system, the large number of data could be managed and stored and the process of the test could be demonstrated by operators conveniently, as well as the easily updating of the database makes the wiring harness management system very useful.
本论文介绍了基于数据库的线束测试管理系统的研发过程,采用面向对象的程序开发思想,结合规范化的数据库设计流程对线束测试管理系统进行设计,重点讨论了线束测试、信息管理和通信功能几个重要模块的研发过程。
论文首先阐述了课题背景和线束测试仪的国内外现状,介绍了项目所采用的数据库系统的特点。然后分析了线束测试的基本原理和几种基本的失效模式,对线束测试仪进行了需求分析以及线束测试系统硬件结构和软件结构的分析,随后描述了线束测试管理系统的实现方案。第三部分根据数据库系统的规范化设计方法来设计线束测试管理系统的概念模型、分析信息的数据流图、指定数据库存取方法的选取。第四部分为本论文的重点章节,主要介绍了线束测试管理系统中三个重要功能模块的设计过程。包括线束测试功能模块、信息管理功能模块和通信功能模块的实现过程,并给出了部分功能模块运行的结果。
本论文开发的线束测试管理系统,能管理并存储线束测试的大量数据,方便操作人员查看线束测试情况和演示在线测试过程,并且能随时更新数据库,从而可以测试多种类型的线束,其应用前景十分广阔。
Wiring harness test instrument is a kind of device that is responsible for quality and reliability of wiring harness. By connection test principle it can eliminate invalidation products that can not work properly for their failure, such as open circuit,short circuit, wrong connection, loose connection and instant open circuit. As a result it improves quality of product. Now this kind of device is widely used in wiring harness test of household appliances, communication devices, aero plane, cars, and military equipment.
This dissertation mainly introduce the wiring harness management system based on database. The system is designed according to the developing concept of object-orient and standard developing process of database design. The modules of wiring harness test, formation management and communication are mainly discussed in this paper.
First, the background about this project is discussed , then the database system and the wiring harness management system are introduced in this dissertation. Second, the basic principles and invalid modes of the wiring harness check management system are analyzed including the requirement specification. Third, the models of wiring harness management system is designed and the data flow charts for information analysis are designed and the storage manner of the database is pointed out according to the standard developing process of database design. At last, the designing processes of the three important function modules in this system are introduced, including wiring harness test, information management and communication module.
With this software of wiring harness test management system, the large number of data could be managed and stored and the process of the test could be demonstrated by operators conveniently, as well as the easily updating of the database makes the wiring harness management system very useful.
引文
1) 何丹亚主编,汽车电器与电子设备,人民交通出版社,1998
2) 何渝生、余成波等,汽车电子技术及控制系统。国防工业出版社,1996.6
3) 高学松、都思丹,install shield 制作数据库安装程序研究,微处理机,2005.8:42-43
4) 徐向阳主编,汽车电器与电子控制技术,机械工业出版社,1999
5) 谢云、易波等,现代电子技术实践,机械工业出版社,2003.2
6) 李维,Delphi7 高效数据库程序设计,机械工业出版社,2003
7) Blakeley.Jose A、Cunningham.Conor,Distributed/heterogeneous query processing in Microsoft SQL Server,21st International Conference on Data Engineering, ICDE,2005
8) Robert Sturn, A computer model for the clearance of insoluble particles from the tracheobronchial tree of the human lung, Computers in Biology and Medicine,2007.3:680-690
9) 邓小善,SQL Server 数据库索引设计的研究,中国科技信息,2006.22:148-152
10) Velios.Athanasios、Pickwoad.Nicholas,The database of the St. Catherine's library conservation project in Sinai, Egypt,Archiving 2005 - Final Program and Proceedings,2005:73-78
11) Sivamard.Suparurk 、 Chittayasothorn , A temporal transparency database application development environment , Proceedings of the International Conference on Information Technology Interfaces,2005:161-166
12) 朱松豪 刘巧英,Delphi 动态报表的设计与实现,计算机应用及软件,2005.02:136-138
13) 刘韬 楼兴华等,SQL Server 2000 数据库系统开发实例导航,人民邮电出版社,2004
14) 陈惟彬,Delphi 进销存程序设计,清华大学出版社,2002
15) 涂晓斌等,用 Delphi 建立起数据库与 Excel 之间的数据通信,华东交通大学学报,2005.02:80-82
16) 谢志宇、郑林华、王梓斌,SQL Server 数据库的安全设计与应用,电脑知识与技术,2006.32:30-31
17) 刘卫,SQL 在 Delphi 数据库查询中的应用,计算机与现代化,2005.11:76-78
18) 王洪香,基于 SQL Server 数据库完整性约束的几点探讨,办公自动化,2006.21:25-27
19) Zheng Xiaoqing、Chen Huajun,Query optimization in database grid,Lecture Notes in Computer Science,2005:486-497
20) 王静,靳引利,汪贵平,基于 Delphi 的串口通信实践,现代电子技术。2006.19:127-129
21) Clay Shannon,Delphi 程序调试参考手册,中国电力出版社 2003
2) 何渝生、余成波等,汽车电子技术及控制系统。国防工业出版社,1996.6
3) 高学松、都思丹,install shield 制作数据库安装程序研究,微处理机,2005.8:42-43
4) 徐向阳主编,汽车电器与电子控制技术,机械工业出版社,1999
5) 谢云、易波等,现代电子技术实践,机械工业出版社,2003.2
6) 李维,Delphi7 高效数据库程序设计,机械工业出版社,2003
7) Blakeley.Jose A、Cunningham.Conor,Distributed/heterogeneous query processing in Microsoft SQL Server,21st International Conference on Data Engineering, ICDE,2005
8) Robert Sturn, A computer model for the clearance of insoluble particles from the tracheobronchial tree of the human lung, Computers in Biology and Medicine,2007.3:680-690
9) 邓小善,SQL Server 数据库索引设计的研究,中国科技信息,2006.22:148-152
10) Velios.Athanasios、Pickwoad.Nicholas,The database of the St. Catherine's library conservation project in Sinai, Egypt,Archiving 2005 - Final Program and Proceedings,2005:73-78
11) Sivamard.Suparurk 、 Chittayasothorn , A temporal transparency database application development environment , Proceedings of the International Conference on Information Technology Interfaces,2005:161-166
12) 朱松豪 刘巧英,Delphi 动态报表的设计与实现,计算机应用及软件,2005.02:136-138
13) 刘韬 楼兴华等,SQL Server 2000 数据库系统开发实例导航,人民邮电出版社,2004
14) 陈惟彬,Delphi 进销存程序设计,清华大学出版社,2002
15) 涂晓斌等,用 Delphi 建立起数据库与 Excel 之间的数据通信,华东交通大学学报,2005.02:80-82
16) 谢志宇、郑林华、王梓斌,SQL Server 数据库的安全设计与应用,电脑知识与技术,2006.32:30-31
17) 刘卫,SQL 在 Delphi 数据库查询中的应用,计算机与现代化,2005.11:76-78
18) 王洪香,基于 SQL Server 数据库完整性约束的几点探讨,办公自动化,2006.21:25-27
19) Zheng Xiaoqing、Chen Huajun,Query optimization in database grid,Lecture Notes in Computer Science,2005:486-497
20) 王静,靳引利,汪贵平,基于 Delphi 的串口通信实践,现代电子技术。2006.19:127-129
21) Clay Shannon,Delphi 程序调试参考手册,中国电力出版社 2003