Coach: Dr. Joe Wilson Members: Rahul Alavalapati Danton Harrylal

1
Coach Dr. Joe WilsonMembers Rahul
AlavalapatiDanton Harrylal Meme ThaiJuli
LimJanuary Realista
CAE Liaisons Tara Cady Kevin Cahill Terry
Hung Mike Pacitti Jeff Torres
2
Introduction

• CAE designs flight simulators.
• These flight simulators uses IOS pages to control
  practice and flight conditions.
• Our project design a database to store
  information to create IOS pages.

3
Customer Needs

• Need system to reduce cost and time to develop
  IOS
• Database store past and future information,
  define inputs and outputs needed by each
  simulation system, connection of IOS controls
  with system variables
• Need platform independent method to access and
  modify information within the DB multiple
  locations

4
Purpose

• Design and implement database to store and
  retrieve information about IOS page
• - Layout of page
• - Min/max value of each control
• - Re-name variables
• - Callback functions
• Use information in database to auto-generate IOS
  pages
• Create web-interface to update and replicate IOS
  pages

5
Purpose

• Increase reuse of the IOS pages and GUI objects
  
• - Decrease errors
• - Reduce cost and schedule

6
Database Specifications

• Compatible with SQL Server 2000, Oracle 8i or
  higher
• DSN connection with IIS web-server
• Use naming conventions provided by the CAE

7
ER-Diagram
8
Business Case

• Database will increase the companys efficiencies
  in the process of creating simulation systems.
• Increase re-usability of IOS GUI Objects/Pages
• Provide efficient tracking of changes on projects
• Automate page creation and changes
• Eliminate repetitive manual work by systems
  engineers.

9
(No Transcript)
10
(No Transcript)
11
Installation Considerations

• IIS Web Server 4.0 or higher provides basic Web
  server to serve Web pages.
• SQL Server 2000 or Oracle 8i relational
  database architecture for high transaction web
  sites.
• Internet Explorer 5.0 or higher and Netscape 6.0
  or higher supports XML and XSL

12
Software Architecture

• Four Components
• Presentation Component the client application.
• Data Component the database.
• VBScript Application Component.
• ASP
• DSN Connection to Database
• XML and associated Stylesheets, XML Component

13
Four-Tier Application
14
Software Interface Specifications

• ASP (Active Server Page) create by IIS when a
  browser requests document. Contents can vary
  from one request to another.
• XML (eXtesible Markup Language) cousin of
  HTML, form of sharing data among different
  applications.
• DTD (Document Type Definition) validates XML
  documents.
• XSL (Extensible Stylesheet Language)
  application of XML, allows creation of special
  stylesheets for formatting XML files.

15

• DOM (Document Object Model) set of interfaces
  that allows programmers to load XML documents
  into a tree structure and operate on them.
  Common tasks
• - Document loading and validation - Tree
  traversal
• - Content Creation
• ODBC (Open Database Connectivity) open standard
  method of accessing data.
• DSN (Data Source Name) where the data is kept.
  Typically a database on a Database Management
  System.

16
Data Flow Diagram
17
Prototype Plan

• A database implemented in Microsoft Access
• All of the common database functions which
  include inserts, updates, deletes, and searches
• The database populated with sample data
• A friendly web-based user interface using
  VBScript/ASP, XML, and XSL

18
Gantt Chart - Fall
19
Gantt Chart - Spring
20
Issues and Concerns

• Obtaining IIS Server
• Access to IIS Server
• SLGMS Runtime Environment
• Access Database