offline data analysis .

[parvataneni]

Hai Everyone,

                           How do I create Database using LAB View and retrieve this data for offline analysis.I am new to database design and labview.I am working on acoustic emission signal data obtained during machining of ceramic tile.My aim is to collect this data, store into a database and retrieve for offline analysis making it user friendly. Please suggest the DB tool that would be more compatable for the work and also the method of retreving it for better graphing capabilities.Thanks in advance....

[JQ]

you may try LabSQL out... to use it efficiently, you may need to know the basics of SQL (there are a few examples included)... of course you need to have sql installed in your com first... to define the connection, go to Control Panel -> Administrative Tools -> ODBC Data Sources...

basic command text you may need is:

INSERT INTO tablename VALUES data;

SELECT columnname FROM tablename WHERE condition;

for more information about SQL, you may go google and search about it...

hope this helps...

[Lorielle P]

You may benefit from the LabVIEW Database Connectivity Toolkit. Please post back with any additional questions you may have that the tutorial does not cover.

[Vellore]

Hai,

        Thanks for ur prompt reply.Can U tell me the difference between NI Data finder,DIAdem,Data base connectivity tool kit packages.Can u tell me which would be more compatable for my apllication.Can u please tell me how would i use the data retreived from data base for analysis.

            with regards

Rohit

[Patrick_P.]

Hey Rohit,

Hopefully I can clear things up a little bit.  First of all NI DataFinder is part of DIAdem, so DIAdem and DataFinder are included in a single package. The DataFinder is a utility provided with DIAdem that will allow you to search through data files on your computer based on properties that are stored within the file. It is similar to using a database, but without any of the overhead of initially having to set up the database. DIAdem is a software package that includes many tools to load, analyze, and present your data. Finally, the LabVIEW data base connectivity toolkit is a set of VIs that help you to communicate with databases.  You would still have to set up your own database to begin storing and querying data. To get more in depth information about each I would recommend checking the links I have listed below.

Test Data Management for the Enterprise

DIAdem main page