Exploring SAP2011 tables

< PREVIOUS: SAP2011 Data structure > NEXT: Parameter settings & features scale

SAP2011 can auto-generate all the tables if they are not found in the database.
You can access the tables via Matlab or via Excel, but the native table-browser is the mySQL WorkBench, which you can download from the mySQL website.
Once you set up the workbench, click the local instance to open this window:
Then double-click on a table you want to view or export, e.g., try recs0:
and use the save button to export the table (or a query from the table) into a CSV file, that you can then open in Excel or in Matlab.
If you do not like the workbench, an alternative, free product is mySQL query browser. When opening Workbench for the first time you will need to start a new session (just give it a name keeping all the default settings) and then you can “connect” and observe the databases. Double click the SAP database to observe the tables:
The Table Structure

An example of table structureHere is a summary of the features, as they appear in in a raw features table:

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
peak_frequency The frequency of highest power
DAS Duration of acoustic state (ms)
continuity_t continuity of contours over time
continuity_f continuity of contours over frequency

SAP2011 can perform several different tasks and our database structure is shared across those tasks.