Alexa Query Assistant

Querying database instance using voice input developed by Amazon Alexa!

Project Description

Contributors:

• Mo Shi
• Zekun Zhang
• Ziqi Wang

Implementation:

• A MySQL InstaCart sample DB instance that contains product-order information (see the schema in .pptx presentation)
• A web interface for users to interact with the DB instance, i.e., accepting the voice input and display the results.
• Alexa skills that mines information from the database by transforming the voice input into dynamic SQL queries

Alexa Skills Introduction

General Query Intent:

General SELECT function to query the database and return the results

• WHERE clause supported
• Single/Multiple/All attributes selection supported
• Basic aggregate functions (SUM/COUNT/MAX/etc.) supported
• Users "speak out" the SQL queries

Product Info Intent:

Given a product's ID, find its corresponding information

• Information includes: 1.department 2.location 3.product name

Find Product Intent:

Find the most/least popular products in the market

• Find the x most/least popular products given an integer x
• Popularity measured by the product's frequency of occurance in all orders
• Results sorted by the product's popularity

Demonstration

See our project demo at: https://www.youtube.com/watch?v=FJ8jGS_ebKs
Also, find more details in our .pptx presentation!