DB String Data Extension

Kód výsledku v 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>

Výsledek na webu

<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

—

Jazyk výsledku

angličtina

Název v původním jazyce

DB String Data Extension

Popis výsledku v původním jazyce

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.

Název v anglickém jazyce

DB String Data Extension

Popis výsledku anglicky

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.

Druh

R - Software

CEP obor

—

OECD FORD obor

20202 - Communication engineering and systems

Projekt

—

Návaznosti

I - Institucionalni podpora na dlouhodoby koncepcni rozvoj vyzkumne organizace

Rok uplatnění

2023

Kód důvěrnosti údajů

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

Interní identifikační kód produktu

DBStringDataExtension

Technické parametry

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.

Ekonomické parametry

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í.

IČO vlastníka výsledku

62156489

Název vlastníka

Mendelova univerzita v Brně