Transcript LabVIEW – MySQL interface

LabVIEW&Windows – MySQL
interface
 SPD database general architecture
 LabVIEW – MySQL interface.
 Basic algorithm
Technology used and advantage
ITS Meeting 4 Jun 2002
Michele Caselle INFN - Bari
SPD Database architecture
ROOT
Script
languag
e
PHP
Script
languag
e
Apache Server WEB
with mod_PHP and
mod_ROOT
SQL internet
DBMS
MySQL
Perl DBMS
Server Web in BARI
DataBase
DBMS Server at CERN
Internet
LabVIEW-MySQL Interface
Client 1
Client 2
LabVIEW-MySQL Interface
LabVIEW-MySQL Interface
… Client N
Wafer Test
CATANIA, CERN
ITS Meeting 4 Jun 2002
Ladder Test
BARI, PADOVA
Assembly
BARI, LEGNARO
Michele Caselle INFN - Bari
LabVIEW- MySQL interface
4. Basic operations are:
1.
2.
3.
4.
5.
3. At the end of all test
procedures the interface
is executed in the
LabVIEW enviroment
Check if files are present.
Write all new test results
Read the new data
Check Read-Write
Log file is generated
1. LabVIEW
executes the
test procedure
SQL internet
DBMS
MySQL
DataBase
LabVIEW-MySQL Interface
DBMS Server at CERN
2. At the end of
each test an ASCII
files is generated
General.dat
JTTEST.dat
Alldacs.dat
Histos.dat
Log_file.txt
Generic Laboratory
ITS Meeting 4 Jun 2002
Michele Caselle INFN - Bari
Basic algorithm
START
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
NO
If wafer
exist
YES
If primary
key exist
Insert the new wafer
and lot code
YES
NO
For each
Files text results
Write information
Into dB
Allows to insert one new LOT and
WAFER object via WEB: so that is
possible to hold the logic references.
NO
Write operation
successful
YES
Primary key exist, means that the information on this chip and
this measure already stored in the dB
1.
2.
3.
4.
Read data presents
Check status of previous data
Delete old data
Overwrite old with present data
Possibility to operate by
means of several tools
already embedded in the
interface.
New data wrote
Read new data
from dB
NO Read operation YES
successful
New data read
Check Write-Read
Write results of the writing
in the log file
ITS Meeting 4 Jun 2002
EXIT from LOOP
END
Michele Caselle INFN - Bari
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 integration in LabVIEW environment.
It’s possible to use the interface also outside LabVIEW environment, as
a standard Windows application.
Don’t require any Windows 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.
ITS Meeting 4 Jun 2002
Michele Caselle INFN - Bari