Búsqueda personalizada

Estadistica con Labview

Dudas, comentarios sobre simulacion con Labview de instrumentacion electronica

Estadistica con Labview

Notapor gus » Dom, 15 Abr 2012, 10:46

Database Communication in LabVIEW



Introduction to LabVIEW ................................................................................................................ 1
1.1 Dataflow programming ........................................................................................................... 1
1.2 Graphical programming ........................................................................................................... 1
1.3 Benefits .................................................................................................................................... 2
2 Database Systems ........................................................................................................................... 3
2.1 RDBMS Components ............................................................................................................... 3
2.2 Data warehouse ...................................................................................................................... 4
2.3 Relational Database ................................................................................................................. 4
2.4 Real-time databases ................................................................................................................ 4
2.5 Database Management Systems ............................................................................................. 5
2.6 MDAC ....................................................................................................................................... 5
2.6.1 ODBC ................................................................................................................................ 5
2.6.2 OLE DB ............................................................................................................................. 5
2.6.3 ADO (ActiveX Data Objects) ............................................................................................ 6
3 Relational Databases ...................................................................................................................... 7
3.1 Tables....................................................................................................................................... 7
3.2 Unique Keys and Primary Key .................................................................................................. 7
3.3 Foreign Key .............................................................................................................................. 9
3.4 Views ....................................................................................................................................... 9
3.5 Functions ............................................................................................................................... 10
3.6 Stored procedures ................................................................................................................. 10
iv Table of Contents
Tutorial: Database Communication in LabVIEW
3.7 Triggers .................................................................................................................................. 11
4 Structured Query Language (SQL) ................................................................................................ 12
4.1 Queries .................................................................................................................................. 12
4.2 Data manipulation ................................................................................................................. 13
4.3 Data definition ....................................................................................................................... 14
4.4 Data types .............................................................................................................................. 14
4.4.1 Character strings............................................................................................................ 14
4.4.2 Bit strings ....................................................................................................................... 15
4.4.3 Numbers ........................................................................................................................ 15
4.4.4 Date and Time ............................................................................................................... 15
5 Database Modelling ...................................................................................................................... 16
5.1 ER Diagram ............................................................................................................................ 16
5.2 Microsoft Visio ....................................................................................................................... 17
5.3 EXERCISES .............................................................................................................................. 18
6 Microsoft SQL Server .................................................................................................................... 20
6.1 Introduction ........................................................................................................................... 20
6.2 Requirements ........................................................................................................................ 20
6.3 SQL Server Express ................................................................................................................ 20
6.4 AdventureWorks ................................................................................................................... 21
6.5 SQL Server Management Studio ........................................................................................... 21
6.6 Create a new Database ......................................................................................................... 22
6.7 Backup/Restore ..................................................................................................................... 24
6.8 Example Database ................................................................................................................. 25
6.9 Exercises ................................................................................................................................ 27
7 Microsoft Office Access ................................................................................................................ 28
7.1 Introduction ........................................................................................................................... 28
v Table of Contents
Tutorial: Database Communication in LabVIEW
7.2 Example Database ................................................................................................................. 28
7.3 Exercises ................................................................................................................................ 30
8 ODBC ............................................................................................................................................. 32
8.1 What is ODBC?....................................................................................................................... 32
8.2 Create an ODBC Connection in “ODBC Data Source Administrator” .................................... 32
8.3 Get data into Excel using your ODBC Connection ................................................................. 34
9 LabVIEW Database Connectivity Toolkit ....................................................................................... 38
9.1 Connect to the Database ....................................................................................................... 39
9.1.1 DSN ................................................................................................................................ 40
9.1.2 UDL ................................................................................................................................ 41
9.1.3 Connection String .......................................................................................................... 42
9.2 Reading Data from the Database .......................................................................................... 42
9.3 Writing Data to the Database ................................................................................................ 46
9.4 Creating and Dropping Tables ............................................................................................... 48
9.5 Using the Database Connectivity Toolkit Utility VIs .............................................................. 49
9.6 Performing Advanced Database Operations ......................................................................... 50
10 Creating and Using Tables ............................................................................................................ 52
10.1 Exercises ................................................................................................................................ 55
11 Creating and Using Views ............................................................................................................. 56
11.1 Exercises ................................................................................................................................ 59
12 Creating and using Stored Procedures ......................................................................................... 60
12.1 Exercises ................................................................................................................................ 62
13 Creating and Using Triggers .......................................................................................................... 63
13.1 Exercises ................................................................................................................................ 66
14 Creating and using Functions ....................................................................................................... 67
14.1 Exercises ................................................................................................................................ 67
vi Table of Contents
Tutorial: Database Communication in LabVIEW
15 SQL Toolkit .................................................................................................................................... 68
15.1 Installation ............................................................................................................................. 68
gus
 
Mensajes: 104
Registrado: Jue, 29 Mar 2012, 19:33


Re: Estadistica con Labview

Notapor gus » Dom, 15 Abr 2012, 10:48

Overview of Curve Fitting Models and Methods in LabVIEW



http://zone.ni.com/devzone/cda/tut/p/id/6954


Imagen
gus
 
Mensajes: 104
Registrado: Jue, 29 Mar 2012, 19:33


Siguiente

Volver a Labview

¿Quién está conectado?

Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 1 invitado

cron
Review foroingenieria.cajael.com on alexa.com