Tuning Database
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.
Analysis and tuning of speech applications in Speech Server rely on a data analysis tool called Analytics and Tuning Studio, which is integrated in Microsoft Visual Studio 2005, and a Microsoft SQL??Server database, which manages the content of Speech Server trace log files.
Create the Tuning Database
Create the tuning database using Microsoft SQL??Server 2005 or Microsoft SQL??Server 2005 Express Edition (SQL??Server Express):
- For information about using SQL??Server 2005 to create the tuning database, see Creating a New SQL Server Database in Server Explorer.
- For information about using SQL??Server 2005 Express to create the tuning database, see Use SQL Server Express to Create a Tuning Database.
When the tuning database is created, use the command-line tool MssLogToDatabase.exe to import speech application trace log files into the tuning database. This tool creates the tuning database schema as part of the import process. For more information, see Import Log Files into the Tuning Database.
Database Roles
Use database roles to regulate access to the tuning database. Roles can simplify security administration in databases with a large number of users or a complex security system. With database roles, the database administrator can improve the security of applications by granting the minimum required permission to the identity that connects to the tuning database.
For more information, see Database-Level Roles.
Tuning User Roles
In Microsoft SQL??Server 2005, use database roles like the ones described in the following table to assign access privileges to users according to their analytical roles. Tuning user roles like Speech Operator and Speech Analyst are created by MSSLogToDatabase after the schema is created. The first import of log files to an empty database might require Database Owner rights on the empty database.
| Level | Description |
|---|---|
Database Owner |
SQL??Server Database administrator access, with rights to create new databases and tables. In other words, full control. |
Speech Operator |
Write access to existing tables of the tuning database, for example, import and pruning. In other words, Speech Analyst plus data population and pruning rights. |
Speech Analyst |
Privileges to read all, but write only to certain extensible fields of the database, for example, the transcription field and annotation field. In other words, Speech RO plus limited write access. |
Speech RO |
Read-only access to the tuning database. Appropriate for users who want to perform read-only analysis of speech data and access non-editable reports as well as list and details views. |
See Also
Other Resources
Speech Application Analysis and Tuning
Management of Tuning Data