測試數(shù)據(jù)管理系統(tǒng)開發(fā)（本科畢業(yè)論文設計）
摘　要

產(chǎn)品數(shù)據(jù)管理（Product Data Management, PDM）作為 CIMS（Computer Integrated Manufacturing System，計算機集成制造系統(tǒng)）的集成平臺，在先進制造技術(shù)的推動下其應用日趨廣泛。網(wǎng)絡化制造環(huán)境下的 PDM 的特點是通過計算機網(wǎng)絡和數(shù)據(jù)庫技術(shù)，以產(chǎn)品為中心，把企業(yè)生產(chǎn)過程中所有與產(chǎn)品相關(guān)的信息和過程集成起來，使產(chǎn)品數(shù)據(jù)在其全生命周期內(nèi)統(tǒng)一管理，使產(chǎn)品開發(fā)過程有序進行。PDM 系統(tǒng)作為一種應用框架，其對開放性的要求和擴展性的要求與 Web 的開放系統(tǒng)結(jié)構(gòu)相互補充。Web 技術(shù)的使用增強了PDM 系統(tǒng)在異構(gòu)環(huán)境下的應用。因此，依靠網(wǎng)絡技術(shù)開發(fā)適合企業(yè)工業(yè)生產(chǎn)的數(shù)據(jù)管理系統(tǒng)，對于企業(yè)的組織管理和項目開發(fā)具有重要意義。從而實現(xiàn)企業(yè)在產(chǎn)品設計、制造過程中能夠更加穩(wěn)定、高效的完成生產(chǎn)任務。
本文用LabVIEW SQLToolkit進行數(shù)據(jù)庫訪問的方法 。利用該工具包，用戶可以創(chuàng)建一個使用數(shù)據(jù)庫來管理復雜任務、存儲測試數(shù)據(jù)并且能夠總結(jié)測試結(jié)果的自動化測試系統(tǒng)。具體內(nèi)容包括用LabVIEW將數(shù)據(jù)文件導入數(shù)據(jù)庫和將數(shù)據(jù)庫中的數(shù)據(jù)文件導出到LabVIEW程序中，而實現(xiàn)對產(chǎn)品的數(shù)據(jù)管理。


關(guān)鍵詞：自動測試系統(tǒng)；數(shù)據(jù)庫















ABSTRACT

Product Data Management as the integration platform of Computer Integrated Manufacturing System, Advanced anufacturing echnology in the promotion of the increasingly extensive application. Network manufacturing environment is characterized by the PDM through the computer network and database technology to products as the center of the production process of all product-related information and process integration, so that the data in its product life cycle within the unified management, So that the product development process in an orderly manner. PDM system as an application framework, its openness and expansion of the requirements of the requirements of the open systems and Web structure complement each other. Web technology has increased the use of PDM system in the heterogeneous environment applications. Therefore, relying on the development of network technology for enterprises of the industrial production data management system for enterprises in the organization and management and project development is of great significance. In order to achieve enterprise product design, manufacturing process can be more stable and efficient completion of production tasks.
This paper describes a method of accessing database by LabVIEW SQLToolkit. With this toolkit, the user can build ATS using the databas e to manage the complex duty, save and analysis the test data, which includes th e functions of importing data files in database from LabVIEW and outputing data files from database.


Keywords: ATS(automatic testing system); database






目 錄

摘 要 …………………………………………………………………………………………Ⅰ
ABSTRACT …………………………………………………………………………………………Ⅱ
1 緒論 …………………………………………………………………………………………..1
1.1相關(guān)軟件介紹……………………………………………………………………………..1
1.1.1 Visual Studio .NET的基本介紹 1
1.1.2 SQL SERVER的相關(guān)介紹 2
1.2 數(shù)據(jù)庫建立相關(guān)技術(shù)綜述 5
2 總體設計方案 ………………………………………………………………………………..8
2.1 系統(tǒng)數(shù)據(jù)流程圖 8
2.2 系統(tǒng)構(gòu)架 9
2.3 數(shù)據(jù)庫設計 10
2.3.1 數(shù)據(jù)庫的含義概念 10
2.3.2 數(shù)據(jù)庫系統(tǒng)的研究內(nèi)容 10
2.4 SCR系統(tǒng)模塊設計 12
3 關(guān)鍵技術(shù)與原理 ………………………………………………………………………...14
3.1 ORM的應用 14
3.2 樹型結(jié)構(gòu)的應用 15
4 主要功能實現(xiàn)...……………………………………………………………………………...17
5 視圖的應用……………………………………………………………………………………18
6 結(jié)論……………………………………………………………………………………………….19
7 致謝……………………………………………………………………………………………….20
參考文獻 …………………………………………………………………………………………21