1 / 25

Web-based Query & Reporting System for Software User Consultant

Web-based Query & Reporting System for Software User Consultant. Richard Knowles Rutgers University Electrical & Computer Engineering Mentors: Amy Chen & Elizabeth Rye Section 388: Instrument Software and Science Data Systems. Outline. Introduction Problem Project Goals Design Demo

chaka
Download Presentation

Web-based Query & Reporting System for Software User Consultant

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web-based Query & Reporting System for Software User Consultant Richard Knowles Rutgers University Electrical & Computer Engineering Mentors: Amy Chen & Elizabeth Rye Section 388: Instrument Software and Science Data Systems

  2. Outline • Introduction • Problem • Project Goals • Design • Demo • Milestones • Future Work • Questions

  3. Introduction • Multimission Ground System Services (MGSS) • Software dissemination and documentation for Instrument Operations Subsystem (IOS) • Manages the Advancement Multi-Mission Operations Systems (AMMOS) • Provides enhanced tools and services to consumers on NASA’s space missions • Software User Consultants • Provide single point of contact to coordinate, manage and maintain all software dissemination and documentation

  4. Problem • Software dissemination is tracked • Done manually • Data is stored in Microsoft Excel spreadsheets • Accessible to a single person at a time • Difficult to search and retrieve • Manually intensive to update and maintain

  5. Problem • Spreadsheet video

  6. Project Goals • Make Software User Consultant’s job easier • Easy access to data • Easy to search and retrieve data • Easy to maintain the data • More organized

  7. Project Goals • Relate to Google Search Engine

  8. Design • Migrated data from Excel spreadsheets into a relational (MySQL) database • MySQL Server • Accessible via web-based user interface • Developed a Software Web Application • Access to the MySQL database • PHP programming • Enhance security • Add features to the system • Improve the user-interface

  9. Design • Database Schema • 7 Tables • Contact Info • Contributor • Document Review • License • Members • NTR (New Technological Report) • Project

  10. Design Database Schema NTR (New Technological Report)

  11. Design Database Schema

  12. Design Database Schema

  13. Design Database Schema Contributor

  14. Design Database Schema

  15. Design Database Schema

  16. Design Database Schema Members

  17. Design • Web Services • Used to create a software web application on a server • Allows clients to access the web application on the network • Apache • Web server • MySQL • Database server • PHP, HTML • Allow interactions between the database and the server

  18. Design Client-Server Model

  19. Design Centralized Location

  20. Design Use Case Diagram

  21. Demo • `Excel Spreadsheets • http://localhost/~knowles/

  22. Milestones • Complete Web Service • Authentication • Queries and Data Retrieval • Friendly User Interface

  23. Future Work • Make system more dynamic • Port to the Multi-mission Instrument Processing Laboratory (MIPL) server • Backup/Recovery

  24. Acknowledgements • Amy Chen • Elizabeth Rye • Elias Sayfi • Alex Leung • Janet Fung • Jenny Tieu

  25. Thank You • Questions? Email: Knowles3@Eden.Rutgers.edu

More Related