Design of High Speed Relational Database Based on Labview TDMS Format

Abstract

In this paper, a new database design idea based on TDMS format of Labview is proposed that has been successfully programmed and practiced. Firstly, the paper will discuss the respective characteristics and differences between the using of third-party database and the using of file IO operations when the Labview program needs to meet the requirement of the storage of data. Then the paper will discuss how to uses TDMS format to design a database based on TDMS, and the characteristics and basic ideas of this kind of native high-speed TDMS database supported by Labview. Next, in the part of the research and implementation methods, the paper will present how to use the make the TDMS database to support the basic operations of CRUD in relationship database. Following, a data processing interpreter whose core is the conversion between the TDMS format data and two-dimensional array is proposed, which has made the more complex operations of TDMS data realized. Subsequently, this paper shows how to add native SQL language support to the TDMS database. Finally, a comprehensive analysis and summary of database design using TDMS data format is made.