Prototype TLD Application TLD WorkerBee Mentor: Austin Sanders - - PowerPoint PPT Presentation

▶
prototype tld application
SMART_READER_LITE
LIVE PREVIEW

Prototype TLD Application TLD WorkerBee Mentor: Austin Sanders - - PowerPoint PPT Presentation

May 12, 2023 142 likes •496 views

Prototype TLD Application TLD WorkerBee Mentor: Austin Sanders Austen Christensen Morgan Lovato Wei Song 1 Harlan Mitchell Graduated from NAU in 1997 with a degree in Computer Science Systems Technical Manager at Honeywell 2

slide-1
SLIDE 1

Prototype TLD Application

TLD WorkerBee Mentor: Austin Sanders Austen Christensen Morgan Lovato Wei Song

1

slide-2
SLIDE 2

Harlan Mitchell

2

  • Graduated from NAU in 1997 with a degree

in Computer Science

  • Systems Technical Manager at Honeywell
slide-3
SLIDE 3

Introduction

  • Time Limited Dispatch

○ Engine Control Unit ○ Data Dump

  • Preventative Maintenance

3

slide-4
SLIDE 4

Current Process

4

slide-5
SLIDE 5

Problems

  • Too Physical
  • Time Consuming
  • Costly
  • Outdated Software
  • No current way of viewing data in cloud

5

slide-6
SLIDE 6

Proposed Solution

6

slide-7
SLIDE 7

Solution Continued

Problems

  • Time Consuming
  • Costly
  • Outdated Software
  • Can’t view data in cloud

7

Solutions

  • Convenient Access to Data
  • Fast Access to Data
  • Web App Based Software
  • Web App Data Viewing Tool
slide-8
SLIDE 8

Requirements

[P-SYS3] The web viewer tool shall create a MD5 hash value based on the data after receiving it from the cloud. [P-SYS4] The web viewer tool shall validate the data by comparing MD5 hash values [F-SYS1] The web viewer tool shall download the raw data file from the cloud to the user’s computer upon user’s request.

8

slide-9
SLIDE 9

Architectural Overview

9

Model View Presenter:

  • Database Layer

(Model)

  • Service Layer

(Presenter)

  • Presentation Layer

(View)

slide-10
SLIDE 10

Database Layer

10

TLD Data Metadata Plane User

slide-11
SLIDE 11

Service Layer

11

Cloud Raw Data Parsing Tool request() Urllib3 TLD Database RegExp SSL/TLS

slide-12
SLIDE 12

Presentation Layer

12

Django Administrator Table View Chart View TLD Database MD5 Verification

slide-13
SLIDE 13

Demo

13

slide-14
SLIDE 14

14

slide-15
SLIDE 15

15

slide-16
SLIDE 16

16

slide-17
SLIDE 17

17

slide-18
SLIDE 18

18

slide-19
SLIDE 19

19

slide-20
SLIDE 20

20

slide-21
SLIDE 21

21

slide-22
SLIDE 22

22

slide-23
SLIDE 23

23

slide-24
SLIDE 24

24

slide-25
SLIDE 25

25

slide-26
SLIDE 26

26

slide-27
SLIDE 27

27

slide-28
SLIDE 28

Challenges and Resolutions

  • Cloud and database failure

○ Introduce a backup mechanism ○ Medium severity

  • Network connectivity

○ Keep using the current EEI solution as a backup plan ○ High severity

  • Network security

○ Techniques to avoid SQL injections ○ Medium severity

28

slide-29
SLIDE 29

Unit Testing Plan

  • Sign in & Sign up
  • getAircraft(String Aircraft_ID)
  • getChartView(String Aircraft_ID, String

Search_Field)

  • getTableViewData(String Aircraft_ID)
  • MD5Generator(String TLD_Data)
  • MD5Checker(String localMD5, String

cloudMD5)

  • parsingTool(File RawDataFile.txt)

29

Test Framework Test Units (8 units & 47 test cases)

slide-30
SLIDE 30

Integration Testing Plan

  • Travis CI to provide continuous integration and testing environment
  • Use Pytest with Travis CI to automate our tests
  • Test interactions between modules

30

slide-31
SLIDE 31

Usability Testing Plan

  • Group of Certified Aircraft Technicians

○ Categorical Acceptance ○ Live Usability

31

slide-32
SLIDE 32

Team Schedule

32

slide-33
SLIDE 33

Future Work

  • Back-up Database/Files
  • Automatic Refresh
  • Specific Graph View
  • CRC values

33

slide-34
SLIDE 34

Conclusion

34 34 34

  • Project Overview

○ Current process - slow and inefficient ○ Proposed solution - fast and secure

  • Solution Overview

○ Database Layer - AWS Cloud Container and Databases ○ Service Layer - Parsing and Verification Tools ○ Presentation Layer - Web App Data Viewing Tool

  • Poster Session: 2 pm - 4 pm at Location 10C