LabVIEW&Windows – MySQL interface

1. LabVIEW&Windows – MySQL interface • SPD database general architecture • LabVIEW – MySQL interface. • Basic algorithm • Technology used and advantage

2. ROOT Script language PHP Script language Apache Server WEB with mod_PHP and mod_ROOT DBMS MySQL Server Web in BARI DataBase DBMS Server at CERN LabVIEW-MySQL Interface LabVIEW-MySQL Interface LabVIEW-MySQL Interface … Client N Client 2 Client 1 Wafer Test CATANIA, CERN Ladder Test BARI, PADOVA Assembly BARI, LEGNARO SPD Database architecture SQL internet Perl DBMS Internet

3. 4.Basic operations are: • Check if files are present. • Write all new test results • Read the new data • Check Read-Write • Log file is generated 3.At the end of all test procedures the interface is executed in the LabVIEW enviroment 1. LabVIEW executes the test procedure LabVIEW-MySQL Interface 2. At the end of each test an ASCII files is generated General.dat JTTEST.dat Alldacs.dat Histos.dat Generic Laboratory Log_file.txt LabVIEW- MySQL interface SQL internet DBMS MySQL DataBase DBMS Server at CERN

4. Check if it’s possible to establish a connection with the SPD dB,if not the write operation is aborted. DBI Connection Check if all “test files” are present and the hierarchy directories are correct. Check the consistent files Primary key exist, means that the information on this chip and this measure already stored in the dB If wafer exist If primary key exist NO YES YES Insert the new wafer and lot code • Read data presents • Check status of previous data • Delete old data • Overwrite old with present data NO For each Files text results Possibility to operate by means of several tools already embedded in the interface. New data wrote Allows to insert one new LOT and WAFER object via WEB:so that is possible to hold the logic references. Write information Into dB Write operation successful NO YES New data read Read new data from dB Read operation successful NO YES Check Write-Read Write results of the writing in the log file EXIT from LOOP Basic algorithm START END

5. Technology used and Advantage Technology used: • Developed in Perl language and compiled for Windows platform • The interface uses the API called DBI:MySQL • The LabVIEW and MySQL exchange information by means of SQL language Advantage: • Fast execution time. • Good integrationin LabVIEW environment. • It’s possible to use the interface also outside LabVIEW environment, as astandardWindows application. • Don’t require anyWindows configuration, it’s enough to copy the file. • Don’t require MySQL client for Windows, because the interface contains a MySQL client. • Tested for Windows 9x, NT, 2000 and XP.