Transcript PPT

Cross Platform Web Based
Home Inventory System
Project Team: Jon Garibay, Firas Assaad
Faculty Advisor: Dr. Lawrence Thomas
Presentation Agenda
Background information
 Database
 Web Service
 Web Site
 Android Application

Background
Shopping for home consumables is a very
time consuming task
 In order to make informed decisions
while in the store, individuals must know
what items they currently have
 Needed a solution that was robust and
mobile

Background
Designed a home inventory system that is
available via web page or Android
application
 Design effort included Database, API, web
application, web service, and Android
application

High Level Architecture
High Level Application Architecture
Database
Server
Database API
Web Service
Website
Internet
Android Application
Client Browsers
Database
Microsoft SQL Server 2008
 Table Relationships and Indexing

Web Service
Custom-tailored
 TCP Communication
 XML Technology
 Unified Database Communication

Web Service Flow
Web Site

Admin Side
◦ Manage System
◦ Manage Admin Users
◦ Manage Houses

Client Side
◦ Manage House
◦ Perform Inventory
◦ SMS alerts for low items

Tablet Side
◦ Perform Inventory
Web Site Flow
Android Application Goals
The Android application needed to
recreate the functionality of the web
application but optimized for the Android
smart phone platform.
 Needed to be able to scan objects into
the inventory for quick data entry

Android Program Flow
Viewing Inventory
Scanning Items (Add Scan)
Search for
Product
name
No
In Database?
Yes
Increment Item
Communications
Android application uses TCP connection
to connect to web service
 Communicates using XML messages
 Single class handles web service
communication

Future Plans
Move server to a Virtual Private Server
(VPS)
 Create shopping list prediction engine using
product usage data
 Rework UI of web site to show a more
visual representation of a house and allow
for drag and drop interaction.
 Creation of a discrete bar code scanner and
tablet combination for use in high traffic
areas
 Geo Reminders
