the tables structure
Previous Top Next

An example of table structure

Here is a summary of the features, as they appear in in a raw features table, including neuronal features (in red):
feature
description
 time     
time elapsed since midnight in 0.1ms units
 file_index
an index to the wave file (lined to the birds file table
 amplitude
the momentary sound amplitude in Db
 mean_frequency_amp
the amplitude at the 500Hz range around mean frequency
 pitch
the momentary pitch
 mean_frequency
the center of gravity of the power spectrum
 FM 
frequency modulation (0-90 degrees)
 am 
amplutude modulation
 goodness
the goodness of pitch (cepstrum peak value)
 entropy
Wiener entropy
 principal_frequency
The longest frequency contour
 slope
The mean slope of contours
 continuity_t
continuity of contours over time
 continuity_f
continuity of contours over frequency
 s1_amplitude
The squared amplitude of the neural signal
 s1_entropy
The Wiener entropy of the neuronal power spectrum
 s1_PeakFr
The peak frequency of the neural power spectrum
 s1_PeakFr_power
The power at peach frequency (500-8000Hz)
 s1_highpass_power
The amplitude of the high-passed ( 500-8000Hz)
…..
……
 s4_highpass_power
 
SAP2 can perform several different tasks and our database structure is shared across those tasks.
  

Created using Helpmatic Pro HTML