DB String Data Extension

Result code in IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F62156489%3A43210%2F23%3A43924165" target="_blank" >RIV/62156489:43210/23:43924165 - isvavai.cz</a>

Result on the web

<a href="https://www.ni.com/en/support/downloads/tools-network/download.db-string-data-extension.html#494734" target="_blank" >https://www.ni.com/en/support/downloads/tools-network/download.db-string-data-extension.html#494734</a>

DOI - Digital Object Identifier

—

Result language

angličtina

Original language name

DB String Data Extension

Original language description

This software represents an add-on for the development system NI LabView. Moreover, this extension specifically modifies utilization of the original LV Database Connectivity Toolkit by modifying the basic CRUD operations, even deeper by converting 2D database data from the RecordSet object. While the original Toolkit converts this object data to the Variant data type and then to a custom cluster structure. This extension significantly simplifies the output data structure to a 2D string array. This string data table is supplemented with information about data types of individual columns for the RecordSet object. The goal of modifying the data types used is to simplify the creation of program code and namely its maintainability. The advantage becomes apparent especially namely when tables or queries in the DB are expanded or modified. By the original Toolkit, it is necessary to change the cluster structures corresponding to the relevant query or table. Further, it is required to modify the code in all Vis; where the cluster type definition is used. In the case of this Extension, general 2D string array type brings an advantage in possibility to keep connectors between VIs without modifications. Thus, the code of a maintained application can be easily implemented throughout the application structure without modification of these VI codes. At the same time, the operations entail the need to know the data types of the database table columns during Insert and Update operations in the RDBMS. Therefore, the extension is robust in terms of columns information operations and rigorously checks the conversion of data types before inserting them into the RDBMS.

Czech name

—

Czech description

—

Type

R - Software

CEP classification

—

OECD FORD branch

20202 - Communication engineering and systems

Project

—

Continuities

I - Institucionalni podpora na dlouhodoby koncepcni rozvoj vyzkumne organizace

Publication year

2023

Confidentiality

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů

Internal product ID

DBStringDataExtension

Technical parameters

Pro případné jednání je k dispozici doc. Ing. Martin Fajman, Ph.D., e-mail martin.fajman@mendelu.cz, tel. č. +420 545 133 327.

Economical parameters

Produkt je nabízen prostřednictvím licenční smlouvy v programu firmy IN – NI Tools Network v jejich portálu. Je nabízen za cenu 0 USD, tedy k přímému stažení.

Owner IČO

62156489

Owner name

Mendelova univerzita v Brně