swsql, Instrukcje, National INSTRUMENTS, Pdf
[ Pobierz całość w formacie PDF ]
LabVIEW
Enterprise Connectivity
Enterprise Connectivity Toolset
NEW!
SQL Tools (Windows only)
Direct interaction with a local or
remote database
Connection to most popular databases
High-level, easy-to-use functions
Complete SQL operation for direct
access on columns, records, and
tables.
Internet Tools
View your
application across
the Web
Incorporate access
control/security
Send e-mail from
your applications
Send files or raw data
to an FTP server
Build Common
Gateway Interface
(CGI) programs to
perform server
operations
SPC Tools
Perform on-line SPC while collecting
data or analyzing recorded data
Create control charts
Display process statistics and
histograms
Perform Pareto analysis
Overview
As your business grows, you need enterprise connectivity tools
to help you keep track of progress from the research and
development, to the production, test, and service of your
products. The LabVIEW Enterprise Connectivity Toolset provides
integrated tools for SQL (Structured Query Language) database
operations, SPC quality control, and Internet-enabling
technology to give you the access and networking you need for
your business operation.
SQL and SPC have long been industry standards for database
connectivity and quality control in your process. However, the
Internet has opened many new opportunities and uses for
personal computers and workstations across every industry and
application area. Scientists and engineers are finding that
important functions can be performed across the Internet, such
as research, publishing conclusions, displaying data across the
Web, archiving source code versions, and scheduling for test
development teams. In addition to taking advantage of the
Internet, virtual instruments are addressing remote or distributed
applications more and more. Using the Internet component of
this toolset, you can easily incorporate a variety of electronic
communications capabilities, such as e-mail, FTP transfers, or the
Web into your virtual instrumentation applications.
SQL Tools (Windows Platforms Only)
The Enterprise Connectivity Toolset includes a collection of
functions for direct interaction with a local or remote database.
High-level functions simplify database access by intelligently
encapsulating common database operations into easy-to-use
operations. With these SQL tools, you can save, fetch, and
update data records in more than 30 different database formats
using high-level data mapping functions. Experienced database
users can use the complete set of SQL functions to execute SQL
statements from within the LabVIEW development
environment.
Structured Query Language
This toolset implements the SQL set of commands used to
describe, insert, and retrieve information in database tables. SQL
is a nonprocedural language with which you can refer to and
process sets of records in a database. There are three classes of
SQL commands:
• Statements to define the structure of the database and control
access to it, such as CREATE, ALTER, and DROP, which are
used to define, change, and delete tables.
• Statements to manipulate the contents of database tables,
such as INSERT, UPDATE, DELETE, which are used to add a
record, change a record, and/or remove a record.
• Statements to query or retrieve data from database tables,
such as the SELECT statements.
National Instruments
Phone: (512) 794-0100 • Fax: (512) 683-8411 • info@natinst.com • www.natinst.com
89
LabVIEW
Enterprise Connectivity
Compatible Databases
You can use the SQL database tools to communicate with any
local or remote database that has an ODBC driver. Most major
databases include ODBC drivers, including:
• Microsoft Access
• Microsoft SQL Server
• Sybase SQL Server
• ORACLE
In addition, the Enterprise Connectivity Toolset includes ODBC
drivers for a number of older databases for which it might be
hard to obtain an ODBC driver.
• ORACLE 7
• Microsoft SQL Server 4
• Sybase System 10
• INFORMIX 5
• INGRES
• dBASE III, IV, and V
• Clipper
• FoxBASE
• FoxPro 1.0, 2.5, and 3.0
• ASCII Text Files (read only)
• Microsoft Excel 3, 4, and 5 (read only)
• Gupta SQLBase
• DB2 (using Sybase System 10 or Gupta SQLBase Gateway)
If you distribute an application using one of these older
drivers you will need to order run-time licenses.
Front-End and Back-End Database Connections
By integrating SQL into your application, your productivity will
increase for all information-intensive problems. You can create
database front ends that present information with the powerful
GUI. You can create database back ends using data acquisition
and instrument drivers to populate database tables with vital
process, test, or research information.
You can more easily create automated test equipment (ATE)
systems by using a database to organize and retrieve complex test
regimens and store data and summary results. Manufacturing,
SPC, and SCADA systems benefit from the flexibility of SQL to
connect to numerous industry-standard databases.
You don’t even need to own a database to build these
powerful systems. The Enterprise Connectivity Toolset comes
with a database engine capable of creating flat-file databases
that you can populate with information, update, and query with
indexing, record locking, and transaction handling – all directly
from LabVIEW software.
The ODBC Standard
Microsoft developed the open database connectivity (ODBC)
standard to provide a uniform method for applications to access
databases. The database drivers supplied with the SQL toolset
component comply with the ODBC standard. Therefore, you
can port your database applications built with this toolset to
other ODBC databases with minimal changes.
90
National Instruments
Phone: (512) 794-0100 • Fax: (512) 683-8411 • info@natinst.com • www.natinst.com
LabVIEW
Enterprise Connectivity
SPC Tools
The Enterprise Connectivity Toolset also contains SPC libraries
and functions for LabVIEW process monitoring applications. You
can use these SPC tools to identify problems and actually
improve the quality of the process. With the SPC toolset
component, you can apply SPC methods to analyze and track
process performance. In addition to subVIs or functions that
perform the SPC computations, the toolset contains numerous
example programs and custom controls that demonstrate how
to incorporate typical SPC methods and displays into LabVIEW
applications. The toolset functionality addresses three areas of
SPC – control charts, process statistics, and Pareto analysis. For
each of these areas, the toolset contains analysis functions to
compute important information from your data as well as
plotting functions for displaying analysis results.
Use Pareto Analysis to display the relative importance of
problems or assignable causes in your process.
u chart/ c chart
Check control limits
Rule checker (AT&T/Western Electric or Nelson)
Process shift detector
Sequence checker
Plotting
Draw control chart
Draw chart with zones/variable limits
Draw run chart
Draw tier chart
Process Statistics
Calculation
Process mean and sigma
Compute process capability
Sample statistics
Fit normal PDF to histogram
Histogram
Plotting
Normal PDF
Normal PDF graph with limits
Vertical bar graph
Vertical bar graph with limits
Rotate graph
Pareto Analysis
Calculation
Pareto counter
Cause code lookup
Plotting
Pareto chart
Array to bar/comb graph
Control Charts
The control chart libraries include VIs or functions that can
compute points to be plotted for different types of attributes and
variables charts. Select from chart types such as X-bar and s, X-
bar and R, p, and np. Apply run rules (AT&T/Western Electric or
Nelson) to detect out-of-control points or process shift. The Chart
Draw VIs and functions create X-Y graphs with center line and
upper and lower limits; control charts with zones; control charts
with variable limits; and run and tier plots for displaying the
spread of subgroups against specification limits.
Process Statistics
The SPC tools include several VIs or functions for analyzing
process capability. It features graphing functions and VIs that can
fit a normal distribution curve to a histogram to evaluate if the
process is normally distributed. Additional functions calculate
process capability ratios, such as Cp and Cpk, as well as fraction
nonconforming for normally distributed processes.
Pareto Analysis
You can use Pareto Analysis VIs and functions in this toolset to display
the relative importance of problems or assignable causes in your
process. Create Pareto charts to graphically represent the number of
occurrences or percentage occurrence of particular causes.
SPC Toolset Functions
Control Charts
Calculation
X-bar and s chart
X-bar and R chart
x and moving range chart
Single point X-bar and R/S
Single point x/mX-bar and mR
p chart/ np chart
National Instruments
Phone: (512) 794-0100 • Fax: (512) 683-8411 • info@natinst.com • www.natinst.com
91
LabVIEW
Enterprise Connectivity
Internet-Enabling Capabilities
HTTP Web Server
View static snapshots of your virtual instruments through
standard Web browsers
View animated virtual instruments through standard Web
browsers
Specify update rates for animated displays
Allow multiple client connections
Control access to your virtual instruments through the web
With the Internet Developers Toolkit,
you can view virtual instrument front
panels over the web, FTP files, or
send e-mails from your programs.
SMTP Mail Client
Send e-mail messages
Attach File(s)
FTP Client
Automated Send File(s)
Automated Retrieve File(s)
Login
Get Directory
Change Directory
Make/Remove Directory
Send/Receive File
Delete/Rename File
Get File List
Close
Internet Tools – Web Publishing,
E-Mail, and FTP
The LabVIEW development systems have built-in Internet
functionality for publishing documents and images of VI panels.
The Enterprise Connectivity Toolset contains additional Internet
tools that you can use for more advanced requirements.
The Enterprise Connectivity Toolset includes a Web server that
goes beyond the Web server built into LabVIEW by providing
more control over security levels. You can extend the Web server
with Common Gateway Interface (CGI) programs written as
LabVIEW VIs. You can use CGIs to dynamically decide upon the
content to present across the Web. You can also use CGIs to
build more complex Web pages that mix panel images with
other information. Or, you can create pages that prompt for user
information and then act upon that information.
The Internet tools also include libraries for adding e-mail, FTP
transfer, and Telnet capabilities to your virtual instruments. Using
these client-side capabilities, you can automatically send e-mail
when alarm conditions occur, send files or raw data to an FTP
server from your application, or run programs on remote UNIX
servers. These are key capabilities for any remote field monitoring
and control application that must pass data to a centralized
reservoir or keep operators up-to-date on system status.
Build Common Gateway Interface (CGI) programs
Develop multiplatform CGIs in G
CGI template VIs included for guide
Example CGIs included
Ordering Information
Enterprise Connectivity Toolset for
LabVIEW/BridgeVIEW
Windows NT/98/95 ....................................777871-03
Database Run-Time License
Windows NT/98/95 ....................................776983-01
Enterprise Connectivity Toolset for
LabVIEW/BridgeVIEW
Mac OS .......................................................777871-23
All part numbers denote single-user licenses. For
multiuser licenses, call National Instruments.
Distribution of database drivers in an executable
requires a run-time license.
For information on other tools and other platforms,
contact National Instruments.
92
National Instruments
Phone: (512) 794-0100 • Fax: (512) 683-8411 • info@natinst.com • www.natinst.com
[ Pobierz całość w formacie PDF ]