tblLVST_AnswerUsed

Table Description:

Identifies the answers used in a particular application. To some degree this is application dependent; the ASR will generally mark the AnswerID (if there is only one, it is automatically marked as the answer), but the application will have to make a determination as to which n-Best, semantic result, and semantic object was chosen as the right answer. The relationships are unfortunately complex. The default rules: Identifying the Answer used: 1. If there is only one answer, then that answer is always chosen as the answer used. 2. If there is more than one answer, the application should indicate one. If no indication is made, then the first answer in the log will be used. Identifying the n-Best used: 1. If there is only one n-best result for chosen answer, then that n-best result is the n-best used. 2. If there is more than one n-best answer, the application should indicate one. If no indication is made, than the first n-best answer for that answer is used. Identifying the Semantic Result used: 1. If there is only one semantic result, then that semantic result for the n-best and answer is chosen. 2. If there is more than one semantic result for the n-best and answer, then the application must indicate the semantic result. If no indication is present, no precise automatic semantic evaluation can be accomplished. Identifying Semantic Object used: 1. The choice of which semantic object is used requires the application to indicate which object was correct. 2. If this field is -1, and the semantic result is not -1 or 0, then the entire semantic result is assumed to be correct.

Table structure:

Column Name Data Type Data Length Default Value See Also

AnswerUsedID

INTEGER

N/A

N/A

N/A

AnswerID

INTEGER

N/A

N/A

tblLVST_Answers

NBestID

INTEGER

N/A

N/A

tblLVST_NBest_Answers

SemanticResultID

INTEGER

N/A

-1

tblLVST_SemanticResults

SemanticObjectID

INTEGER

N/A

-1

tblLVST_SemanticObjects

Primary Keys:

AnswerUsedID

Foreign keys relationships:

Foreign key Reference table Reference key
AnswerID

tblLVST_Answers

AnswerID

 
Foreign key Reference table Reference key
NBestID

tblLVST_NBest_answers

NBestID

 
Foreign key Reference table Reference key
SemanticResultID

tblLVST_SematicResults

SemanticResultID

 
Foreign key Reference table Reference key
SemanticObjectID

tblLVST_SemanticObjects

SOID

 

Column Descriptions and Constraints:

AnswerUsedID

Description:
Autoincrementing primary key
Constraint Name:
N/A
Constraint Description:
N/A

AnswerID

Description:
Identifies the answer response chosen as 'best' by the ASR. Foreign key to tblLVST_Anwers.
Constraint Name:N/A
Constraint Description:N/A


NBestID

Description:
Identifies the best NBest answer by the ASR or application. Foreign key to tblLVST_NBest_Answers.
Constraint Name:N/A
Constraint Description:N/A


SemanticResultID

Description:
Identifies the best semantic result by the ASR or application. Foreign key to tblLVST_SemanticResults.
Constraint Name:N/A
Constraint Description:N/A


SemanticObjectID

Description:
Identifies the semantic object was used by the ASR or application. Foreign key to tblLVST_SemanticObjects.
Constraint Name:SemanticObjectID constraint
Constraint Description:SemanticObectID can only be positive if SemanticResultID is positive
 

Table Constraints:

Constraint Name:SemanticObjectID depends on SemanticResultID
Constraint Description:SemanticObjectID cannot be positive when SemanticResultID is not positive
Columns related:SemanticResultID, SemanticObjectID