LabVIEW&Windows – MySQL
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

LabVIEW&Windows – MySQL interface PowerPoint PPT Presentation


  • 76 Views
  • Uploaded on
  • Presentation posted in: General

LabVIEW&Windows – MySQL interface. SPD database general architecture LabVIEW – MySQL interface. Basic algorithm Technology used and advantage. ROOT Script language. PHP Script language. Apache Server WEB with mod_PHP and mod_ROOT. DBMS MySQL. Server Web in BARI. DataBase.

Download Presentation

LabVIEW&Windows – MySQL interface

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Labview windows mysql interface

LabVIEW&Windows – MySQL

interface

  • SPD database general architecture

  • LabVIEW – MySQL interface.

  • Basic algorithm

  • Technology used and advantage


Labview windows mysql interface

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


Labview windows mysql interface

  • 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


Labview windows mysql interface

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


Labview windows mysql interface

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.


  • Login