National Instruments Corporation
Data model for measurement data storage in databases

Abstract:

A non-transitory computer-readable memory medium may store a first table comprising rows, wherein each row comprises a first data set identification (ID) field which stores a measurement data set identifier value identifying a measurement data set, and one or more fields for storing measurement data metadata associated with the identified data set. The medium may also store a second table comprising rows, wherein each row comprises a second data set identification (ID) field which stores a measurement data set identifier value present in the first data set ID field. The second table may also store a datapoints field for storing individual data set datapoints and a data set index field corresponding to an ordering of the individual data set datapoints. At least a portion of each of the fields of both the first and second tables may be stored in a columnar format in contiguous memory.