Export (0) Print
Expand All

Tuning Tools Database Tables

Speech Server 2007

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Name Description

Annotations

Contains fields for user data and calculated values that are related to an occurrence of a session, task, or turn. Data is added through Analytics and Tuning Studio to individual instances of a session, task, or turn.

ApplicationData

Contains the data logged by instances of the ApplicationDataEvent class.

Applications

Contains application type, name, and version information.

ApplicationTasks

Contains the names of tasks.

ApplicationTurns

Contains the names of turns.

CommandTypes

Contains the types of commands used in turns.

Cultures

Describes the language of a turn instance.

Databases

Stores the identity of the database holding the data. This table is used for Business Intelligence import scenarios.

Dates

A reference table holding dates.

Devices

Describes the calling device and the called device (phone numbers).

DtmfInstanceRequests

Reference table for each instance of a dual tone multi-frequency (DTMF) request.

DtmfRecognitions

Contains the properties of a DTMF input result.

EngineRecoAudio

Contains the properties of the audio recorded by the recognition engine for an input turn.

EngineRecoAudioData

Contains the audio data recorded by the recognition engine.

EventTypes

Contains the names of different Speech Server event types as imported into the database.

GrammarData

Stores binary grammar streams associated with an audio record.

Grammars

Contains the properties of grammars logged for recognitions.

ImportFiles

Reference and fingerprint table for trace file data previously imported into the database.

ImportSessions

Tracks the history of each import session or batch. As multiple trace logs might be imported for any given session and trace logs might be reimported under certain scenarios, there is a many-to-many relationship between this table and the ImportFiles table.

ImportTokens

Intersection table for the many-to-many relationship between the ImportFiles and ImportSessions tables. It provides an audit mechanism for associating tuning data with the trace log from which it originated.

The possible values for TimeZoneOffset are between 0 to 12 and 244 to 255. This is because this value is calculated from a signed BYTE. It stores time zone offsets in term of hour differences; that is +12 to -12.

Instances

Reference table for prompt instance requests.

Messages

Contains the data from Speech Server events or messages imported into the database.

NonEngineRecoAudio

Contains the properties of the audio recorded when Recognizer is not active. This data is used for session playback.

NonEngineRecoAudioData

Contains the audio data recorded when the recognition engine is not active. This data is used for session playback.

PromptAudio

Contains the properties of the output audio of a prompt. This data is used for session playback.

PromptAudioData

Contains the audio data recorded for a prompt. This data is used for session playback.

PromptData

Contains the plain text and markup of prompt content.

PromptInstanceRequests

Reference table for prompt instance requests.

Prompts

Describes the execution of a prompt request.

RecognitionData

Contains binary data associated with a speech recognition request.

RecognitionGroups

Holds properties of speech recognition cycles, both original and Re-recognition cycles.

RecognitionResults

Holds properties of speech recognition results.

RecognitionWords

Contains words and transcription comparison information for individual recognition results.

ResponseTypes

Contains the characterization of the user responses for a turn; typically Answered, Confirmed, Corrected, or Denied.

Runtime

Contains the type and version of the Speech Server runtime from which the data is generated.

SemanticAnswers

Details the state changes of a semantic item as occurring within a turn.

SemanticItems

Reference table for semantic items.

Servers

Reference table for servers running Speech Server.

SessionAggregate

An aggregation holding the latest session time stamp in the data.

SessionErrorCounts

Contains counts of any errors for each session.

SessionErrors

Contains the list of error types.

Sessions

Contains the properties associated with a session, including called and calling parties, time stamps, ending status, and other information.

SpeechGrammarUsage

Contains references to the grammars used for speech recognitions.

SpeechInstanceRequests

Reference table for speech recognition instance requests.

SpeechRecognitions

Contains the properties of individual speech recognitions, including configuration information and ending status.

SpeechTranscriptions

Contains the transcription for a given turn, as entered in Analytics and Tuning Studio.

Subtasks

Reference table for subtask information held by sessions and tasks.

Tasks

Contains the properties of task instances, including name reference, ending status, duration, and turn count.

Times

A reference table holding times of day.

Turns

Contains the properties associated with turns, including name reference, ending status, and duration.

TurnTypes

Contains the purposes of a turn, if known; typically Ask, Confirm, or Statement.

UserEvents

Contains the data logged by instances of the SessionLabelEvent event and used for reporting with an application-specific custom filter.

UserEventTypes

Reference table for SessionLabelEvent types.

Community Additions

ADD
Show:
© 2014 Microsoft