Mobile Clemson Football Information Retrieval Jason Mikell Cpsc

Mobile Clemson Football Information Retrieval Jason Mikell Cpsc 463 Summer 2004 8/4/2004

Overview n n Features Project Design n n n Database Tables Technology Used Demo Conclusions Future Works Acknowledgements Q&A 8/4/2004

Features From a cell phone: n n n Fans can view players’ profiles See what their favorite players look like Manually and automatically retrieve current weather conditions before, during, and after the game 8/4/2004

DCIT Web Server Mobile phones contains WML & connect to the PHP files Clemson Web Server that can be accessed externally Project Design PHP files sends and receives data to and from Hogwarts DB queries, inserts, updates, take place MS SQL Hogwarts ASP. Net (C# files) MFootball. Web. aspx Register. aspx View. Image 1. aspx Message. Sender. cs Weather web service is consumed by the. Net files Weather Web Service http: //jarvelo. brinkster. ne t/websvcs/v 1. 0/weather. asmx 8/4/2004

Database Tables n Fans n n n Cell_Phone Context Provider Fname Lname City State Zip Send Interval Email_Zipcode 8/4/2004 n Players: n n n n ID Position Number Fname Lname Height Weight Classification n Images n n Img_id Img_path Player_id Player_num

Technology Used n n n . Net Architecture MS SQL C# PHP WML 8/4/2004

Project Demo n n Searching for player’s information Viewing player images Retrieving current weather conditions Setting up automatic weather updates 8/4/2004

Conclusions n PHP was an easy alternative to using SOAP and it works well with WML n Do not put images in the database. Use the path to the image n Carefully think about your database design and project so you don’t have to keep changing your database to incorporate your project ideas 8/4/2004

Future Works n n Expand the database to include more player and coach information View scores from around NCAA ( updated scoreboards ) n n Automatically sent to phone or manually retrieved Include Audio of players and coaches interviews, talks, etc. Video clips of plays Player Comparison from other teams 8/4/2004

Acknowledgements n n n He Zheng Rashmy Appaneravanda All my other 463/663 classmates Amanda Mikell Dr. Pargas 8/4/2004

Q&A 8/4/2004