Design And Implementation Of A Circuit Board ATS Software Platform Data Management Module

With the rapid development of science and technology, users of Automatic Test System (ATS) raise their functional requirements and performance requirements higher and higher, and accordingly ATS requires more complex data to meet users’demand. My paper is mainly on the design and implementation of the data management module in the automatic test system software platform.The ATS for general board is signal-oriented. Our team realized the TPS development platform using visual programming techniques, and an Oracle database is designed to manage the data(target data), which is needed in the ATS. The data management module is an application software that completes the management of the target data by calling the Oracle database.Firstly, in this paper, the Entity-Relationship model is used for the design of Oracle database in ATS. Based on the demand analysis, pragmatic Entity-Relationship module was abstracted in the stage of conceptual design, and then the conceptual module was transformed into relational module, and optimized with normal forms in the stage of logic dedign, at last I realized the table in Oracle with the aid from the DBMS. In order to avoid loss of data,which may be caused by incorrect manipulation or OS fault, I make use of RMAN and Flashback to backup and restore the database.Then, I designed and implemented the data management software in a program environment. The application parts of the ATS software, includes the data management, are integrated in LabWindows/CVI. Depending on the target data, the module is divided into user information management, test resource management and test data management. Respectively, each part has its management interface and backgroud program. The user information management is incharge of the ATS users’information; the test resource management mainly administrates the UUT signals and the connection of instruments,switches and ICA; the test data management program development is the most difficulty. I designed this part using multi-threading technology, of which the test procedure is started, test results are displayed and two worker threads are opened in the main thread. The data acquisition is implemented in one worker thread and in the other one, test results are processed and stored in the database.Finally, I designed an application to manage test resuls, and they are described with XML for data exchange here.Using the data management software in the ATS, we could manage the target data easily and simply, which achieves the predetermined target.