Listening to Recipe Part 1: User verification

1
The Mortar and Pestles Group
Project Tell Me The Recipes Phase II
Presentation
Lucy Xie Danny Diaz Robb Samuell John
Frushour October 14, 2002
CS 499
2
(No Transcript)
3
(No Transcript)
4
(No Transcript)
5
1
Delete All
File
Exit
Insert
Update
Edit
Delete Selected
Logout
Add new user
6
(No Transcript)
7
Listening to RecipePart 1 User verification
Pharmacist (Voice User)
TellMe IVR
Voice/Dial
Pharmacist supplies login ID and password via
voice or dial input
8
Listening to RecipePart 2 Recipe Retrieval
Pharmacist (Voice User)
TellMe IVR
Voice/Dial
Pharmacist supplies the drug name of interest
via voice input
9
Listening to RecipePart 2 Recipe Retrieval
TellMe IVR
Perl DBI script
OracleDatabase
Text
SQL query
- IVR translates speech to text. - Text drug
name is sent to Perl DBI. - Perl DBI will send a
SQL query to Oracle DB.
10
Listening to RecipePart 2 Recipe Retrieval
TellMe IVR
Perl DBI script
OracleDatabase
Text
SQL result
- Oracle DB executes query on drug name. - SQL
result is returned to the Perl script. - Text of
drug recipe is returned to TellMe.
11
Viewing the RecipePart 2 Recipe Retrieval
Pharmacist (Voice User)
Web Site
HTTP
Pharmacist select the drug name of interest from
list of drug recipes.
12
Viewing the RecipePart 2 Recipe Retrieval
Web Site
Perl DBI script
OracleDatabase
Text
SQL query
- Text drug name is sent to Perl DBI. - Perl
DBI will send a SQL query to Oracle DB.
13
Viewing the RecipePart 2 Recipe Retrieval
Web Site
Perl DBI script
OracleDatabase
Text
SQL result
- Oracle DB executes query on drug name. - SQL
result is returned to Perl script. - Text of
drug recipe is returned to Web Site.
14
Editing the RecipePart 3 Recipe Update
Pharmacist (Voice User)
Web Site
HTTP

• Select the drug name of interest from list.
• From Edit menu, select Update to edit the
  recipe in a new window. Submit when finished.

15
Editing the RecipePart 3 Recipe Update
Web Site
Perl DBI script
OracleDatabase
Text
SQL update
- New recipe is sent to Perl DBI. - Perl DBI
will send a SQL query to Oracle DB.
16
Editing the RecipePart 3 Recipe Update
Web Site
Perl DBI script
OracleDatabase
Text
SQL result
- Oracle DB executes update on SQL record. -
SQL result is returned to Perl script. - SQL
update status is returned to Web Site.
17
Data Dictionary

• Front-end
• Web Interface
• The internet website, where the user interacts
  with the program
• IVR Interface
• Interactive Voice Response interface, where the
  user accesses the system using a telephone

18
Data Dictionary Front End2

• Front-end
• Login Page
• The internet page, where the user enters his
  user-id and password
• Recipe Page
• The internet page, where the user retrieves
  recipe data

19
Data Dictionary Front End3

• Front-end
• Admin Page
• The internet page, where the user with
  Administrative role updates user and/or recipe
  information

20
Data Dictionary Back End1

• Back-end
• Common Gateway Interface (CGI)
• A cgi is an executable program that runs on the
  host machine allowing direct interaction with
  external information with internal servers, i.e.,
  oracle database
• CGI with Perl
• We will be using Perl Scripts as our tool to CGI.

21
Data Dictionary Back End2

• Back-end
• Perl DBI
• A Perl Module that sends a query to DBD module
  that knows which database to interact with, e.g.,
  DBDOracle will interact with Oracle, execute
  the query and return the result to the DBI module

22
Data Dictionary Back End3

• Back-end
• Oracle
• A database management system that allows create
  different database tables populated with data,
  which a user can retrieve using SQL queries
• SQL
• Structured Query Language that defines how to
  access a particular database

23
Data Dictionary Back End4

• Back-end
• VoiceXML
• A derivative of the Extensible Markup Language
  (XML) for building IVR applications. VXML has
  the following capabilities
• Playing audio
• Recognizing speech and touch tone input
• Controlling a call flow

24
Data Dictionary Back End5

• Back-end
• VoiceXML Grammar
• A set of rules that validates the users Voice
  Input. For example, when an application requires
  a yes input, a specified grammar can set the
  following as valid
• Yup gt returns yes
• Sure gt returns yes
• Groovy Baby gt returns yes
• Thats right gt returns yes

25
Test Plan

• User name validation check
• Web Interface
• The user types his/her ID and password. Either
  an incorrect ID or an incorrect password result
  an error. The system prompts the user to try
  again.
• TellMe IVR
• The user speaks or dials his/her ID and
  password. Either an incorrect ID or an incorrect
  password result an error. The access to the
  system is denied and the user is asked to try
  again later.

26
Test Plan

• Input Recognition
• Web Interface
• All inputs should be fine, since input is
  restricted to a list of drug names with defined
  recipes.
• TellMe IVR
• Voice input from users with different accents
  should be recognized in the voice recognition
  process. Drugs that are unrecognized will cause
  an error message to be spoken back.

27
Test Plan

• Output correctness check
• Web Interface
• The user selects from the listed drug names and
  inputs the quantity desired. The system displays
  on the screen the corresponding ingredients and
  weights.
• Tell Me IVR
• The user speaks recognizable drug name and the
  quantity desired. The corresponding information
  is spoken over the phone to the user.