web-based query & reporting system for software user consultant
DESCRIPTION
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 - PowerPoint PPT PresentationTRANSCRIPT
Web-based Query & Reporting System for Software User Consultant
Richard KnowlesRutgers UniversityElectrical & Computer Engineering
Mentors: Amy Chen & Elizabeth Rye Section 388: Instrument Software and Science Data Systems
Outline
Introduction Problem Project Goals Design Demo Milestones Future Work Questions
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
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
Problem
Spreadsheet video
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
Project Goals
Relate to Google Search Engine
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
Design
Database Schema 7 Tables
Contact Info Contributor Document Review License Members NTR (New Technological Report) Project
DesignDatabase Schema
NTR (New Technological Report)
DesignDatabase Schema
DesignDatabase Schema
Design
Contributor
Database Schema
DesignDatabase Schema
DesignDatabase Schema
Design
Members
Database Schema
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
Design
Client-Server Model
Design
Centralized Location
Design
Use Case Diagram
Milestones
Complete Web Service Authentication Queries and Data Retrieval Friendly User Interface
Future Work
Make system more dynamic Port to the Multi-mission Instrument Processing
Laboratory (MIPL) server Backup/Recovery
Acknowledgements
Amy Chen Elizabeth Rye Elias Sayfi Alex Leung Janet Fung Jenny Tieu
