490 likes | 626 Views
Center for Advanced Vehicular Systems Information System and Management Tool. Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai. About CAVS.
E N D
Center for Advanced Vehicular SystemsInformation System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai
About CAVS • Focused on developing superior computational, engineering, manufacturing, design, and information technologies relevant to Mississippi industries • Approximately 200 employees • Ranging from undergrad to faculty • 10 research teams operating quasi-independently
Issues • Lack of a marketable website • Must be easy to update • Must be easy to use • Unorganized data • Multiple data sources • Lack of data integrity
Solution • Website Redesign using MySQL and PHP • Website draws data from database • Database is updated by functionality built into the intranet part of the website
New Issue • CAVS Employees are not using the website • Due to: • Lack of Awareness • Lack of time • Lack of incentive
Solution • Build quarterly reports and other useful reports using information gathered through website interface
Analysis • Interview • What reports are needed • Example Documents • Quarterly Report • User feedback • Interface questions • Improvements
Report Types • Management wanted ability to query all activities at CAVS • Organize information by research team, date, and type • Build employee reports
Report Requirements • Current Modules • Publication • Employee • Projects and funding information • CAVS affiliates
Report Requirements (cont.) • Needed modules • Proposals and proposal funding • Employee Activities • Employee Tours and tour members • Ability to update proposal information • Need to integrate old modules with new modules
Feasibility • Technologically • MySQL powerful free database software • PHP server already in place • Economically • Free tools • Save money in long run • Operationally • Goal to make interfaces as intuitive and easy to use as possible
Security • Intranet login • Defined rights for different user groups • Items are giving public or private status depending on type and sensitivity • Robot.txt file disallows robot access to intranet and proposal directory
ERD ERD Edited Tables Added Tables
Implementation • Website • Plunge • Website modules • Phased
Maintenance • Work out bugs that couldn’t be predicted • Enhance user interface and usability
Future Goals • Add modules to increase functionality • Create more reports as needs arise • Add more data checking features to decrease amount of fraudulent data
Conclusion • Improves efficiency • Provides instant report capabilities • Centralized repository decreasing redundant out-of-date data