Data Management

ADO Database Connectivity

User Rating:  / 0

EvaluMation, LLC has experience creating, designing, deploying, querying, and writing to relational databases.  Some of the databases that we have experience with include MySQL, MS SQL, Oracle, MS Access, etc.  Some database configurations require the use of a text file to write to tables within the database.  While this is a good way to log data in an environment where multiple programs are accessing the database, it does not allow the program to query, create, and delete tables within the database.  Using ADO database connectivity, we can connect directly to the database and perform these complicated tasks all within the LabVIEW of TestStand programming environment.

When a program requires the storage of large amounts of data, a database is an easy solution to inevitable memory issues.  This can occur in data acquisition environments where large amounts of data are continually logged.  For extremely large amounts of data, even storing the data in a binary file can cause problems.  Microsoft Excel only allows for 256 columns and about 6,500 rows of data.  Binary files have to be opened and searched for relevant data, and this could slow down a program if the data is too large.  A database has been designed to hold large amounts of data and return data to the user by utilizing queries to limit the amount of data returned to a program.  If a relational database has been designed well, the time to run a query on a large database is very fast in comparison to binary files.

With ADO Database Connectivity, programs can easily connect to the database, create, read, write, and delete tables within the database, and perform complicated queries on the data within the database. There is even a way to create certain types of databases programmatically.  An example of an Access database created using ADO Database Connectivity is shown below...