web-based query & reporting system for software user consultant

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

Demo

`Excel Spreadsheets http://localhost/~knowles/

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

Thank You

Questions?

Email: Knowles3@Eden.Rutgers.edu