I also wanted to use relational database functions. My requirements were simple. I had to generate a report that needed data from two channels. There was a one to many relationship between the channels. One channel was parameters and there are several sets of these. Each set of parameters has multiple tests. I gave each record an ID number (handled the auto indexing the ID with LabView). Then I wrote some LabView code to handle getting the data needed from the two channels.
These data files are small enough to have all the data in memory at one time and this may not scale well to large datasets. The coding was not as simple as using a relational database but it wasn’t all that bad.
TDMS has become my favorite file format for all but the simplest data files.
