december 5, 2005 1 remote monitoring system ein systems environmental intelligence network systems...

December 5, 2005 1Remote Monitoring System EIN Systems

Environmental Intelligence Environmental Intelligence Network SystemsNetwork Systems

Remote Monitoring SystemRemote Monitoring System- Preliminary Design -- Preliminary Design -

WelcomeWelcome Mr. Ken Swarner Dr. Tim Mr. Ken Swarner Dr. Tim

LedermanLederman

Systems Administrator Systems Administrator ProfessorProfessor


EIN Systems OrganizationEIN Systems Organization

Team StructureTeam Structure

Ybelka Brito Ybelka Brito LibrarianLibrarian

Michael DevanandanMichael Devanandan Team LeaderTeam Leader

Joseph HalveyJoseph Halvey Software Developer Software Developer

Michael Jakubowski Michael Jakubowski Project Project EngineerEngineer

Vernell Mitchell Vernell Mitchell WebmasterWebmaster

Anthony RuotoloAnthony Ruotolo Systems AnalystSystems Analyst


Preliminary Design Preliminary Design PresentationPresentation

Roger Bacon 328Roger Bacon 328December 5, 2005December 5, 2005

Michael Devanandan:Michael Devanandan: Introduction & Introduction & ConclusionConclusion

Anthony Ruotolo:Anthony Ruotolo: Use Cases Use CasesJoseph Halvey:Joseph Halvey: Data Flow Diagrams Data Flow DiagramsMichael Devanandan:Michael Devanandan: Functional Requirements Functional RequirementsVernell Mitchell:Vernell Mitchell: Environments & Testing Environments & TestingMichael Jakubowski:Michael Jakubowski: Prototypes Prototypes


Use Case - Sensored UserUse Case - Sensored User

Sensored User – Registered User at a Sensored User – Registered User at a monitored locationmonitored location

Able to check any sensored location dataAble to check any sensored location data Able to delete the sensored user accountAble to delete the sensored user account Able to add and delete “read only” user Able to add and delete “read only” user

accountsaccounts Able to delete the current monitored locationAble to delete the current monitored location Able to add or delete a sensorAble to add or delete a sensor Able to change both system and personal Able to change both system and personal

preferencespreferences


Use Case - Remote UserUse Case - Remote User

Remote User – Registered User at an Remote User – Registered User at an unmonitored locationunmonitored location

Able to check any sensored location dataAble to check any sensored location data Able to check logsAble to check logs Able to change the current, Able to change the current,

unregistered location to a registered, unregistered location to a registered, monitored location if an acceptable monitored location if an acceptable device has been installed (becoming a device has been installed (becoming a sensored user).sensored user).


Use Case - “Read Only” Use Case - “Read Only” UserUser

Read Only User – Guest AccountRead Only User – Guest Account Able to check any sensored location Able to check any sensored location

datadata Unable to change any settingsUnable to change any settings Unable to add or delete sensors, Unable to add or delete sensors,

locations, or accountslocations, or accounts Associated with a Regular User Associated with a Regular User

account that created itaccount that created it


Use Case - Website Use Case - Website AdministratorAdministrator

Has ability to make visual changes Has ability to make visual changes to the siteto the site

Can add users or otherwise make Can add users or otherwise make any changes if problems occurany changes if problems occur

Has complete control of everything Has complete control of everything our program controls except the our program controls except the installation and setup of the installation and setup of the software on the serversoftware on the server


Data Flow DiagramsData Flow Diagrams


Logical Data StoreLogical Data Store

A logical data store is a description A logical data store is a description of the fields in the tables of a of the fields in the tables of a database.database.

It is used to help plan the schema of It is used to help plan the schema of a database.a database.

This logical data store will be used This logical data store will be used in the creation of the User Database in the creation of the User Database for the Environmental Monitoring for the Environmental Monitoring System.System.


Personal DataPersonal Data

Account ID – A unique ID number for the user’s Account ID – A unique ID number for the user’s account. NUMBERaccount. NUMBER

E-mail Address – the e-mail address of the user, E-mail Address – the e-mail address of the user, used to identify the user at login. VARCHAR (50)used to identify the user at login. VARCHAR (50)

Password – The user’s password supplied at Password – The user’s password supplied at login to give access to the system. Must be login to give access to the system. Must be between 6 and 12 characters long, including at between 6 and 12 characters long, including at least one upper case, one lower case, and at least one upper case, one lower case, and at least one of the following characters: $, *, #, &, least one of the following characters: $, *, #, &, ^, |, =, %. VARCHAR (13)^, |, =, %. VARCHAR (13)

First Name – The user’s first name. VARCHAR First Name – The user’s first name. VARCHAR (30)(30)

Last Name – The user’s last name. VARCHAR Last Name – The user’s last name. VARCHAR (30)(30)


Sensor InformationSensor Information

Device ID – A unique ID number for the sensor. NUMBERDevice ID – A unique ID number for the sensor. NUMBER Location – The location of the device. VARCHAR (20)Location – The location of the device. VARCHAR (20) Reading – The last reading received from the device. Reading – The last reading received from the device.

NUMBERNUMBER Type of Sensor – The type of the sensor, including Type of Sensor – The type of the sensor, including

temperature, motion, and water level. VARCHAR (25)temperature, motion, and water level. VARCHAR (25) Acceptable Range – The acceptable range for a device. If Acceptable Range – The acceptable range for a device. If

the device leaves this range, it will trigger an alert. the device leaves this range, it will trigger an alert. VARCHAR (7)VARCHAR (7)

Alert Status – The alert status of the device. A 1 Alert Status – The alert status of the device. A 1 indicates an alert, while a 0 indicates everything is indicates an alert, while a 0 indicates everything is normal. BOOLEANnormal. BOOLEAN

Time Since Last Alert – The time elapsed since the last Time Since Last Alert – The time elapsed since the last alert was triggered. VARCHAR2 (9)alert was triggered. VARCHAR2 (9)


Functional RequirementsFunctional Requirements

Create a database to store user Create a database to store user informationinformation

Have a web-based application that Have a web-based application that will interface with the databasewill interface with the database

Allow users to create accounts and Allow users to create accounts and register a sensor deviceregister a sensor device

Allow users to view and manage Allow users to view and manage their monitoring devicestheir monitoring devices


Sensored UserSensored User

A sensored user’s Web browser is set A sensored user’s Web browser is set to the EIN Homepage by default.to the EIN Homepage by default.

Username is the user’s E-mail.Username is the user’s E-mail. Password consists of 6-12 characters, Password consists of 6-12 characters,

and includes at least one number, one and includes at least one number, one uppercase letter, one lowercase letter, uppercase letter, one lowercase letter, and at least one of eight recognized and at least one of eight recognized special characters shown here within special characters shown here within double quotes “#$%^|&*=”.double quotes “#$%^|&*=”.



After authentication, a welcome After authentication, a welcome message informs the user is at a message informs the user is at a recognized, monitored location.recognized, monitored location.

The user home page shows The user home page shows registered locations with the current registered locations with the current location highlighted, and the devices location highlighted, and the devices and status associated with each and status associated with each location.location.



The top of the screen has a The top of the screen has a navigation bar that leads to other navigation bar that leads to other functions available to the sensored functions available to the sensored user.user.

The User Settings button allows the The User Settings button allows the sensored user to delete the user’s sensored user to delete the user’s own account, change the settings, as own account, change the settings, as well as add or delete a “read-only” well as add or delete a “read-only” account.account.



The Device button allows the The Device button allows the sensored user to add, delete, or sensored user to add, delete, or change the settings of the devices change the settings of the devices which are associated with the which are associated with the current location. current location.

The Logs button navigates the The Logs button navigates the sensored user to a page that displays sensored user to a page that displays all the alert and event logs in each all the alert and event logs in each device’s history.device’s history.


Remote UserRemote User

A remote user must open a web browser A remote user must open a web browser and navigate to the EIN homepage.and navigate to the EIN homepage.

A remote user’s username is the user’s E-A remote user’s username is the user’s E-mail.mail.

Password consists of 6-12 characters, and Password consists of 6-12 characters, and includes at least one number, one includes at least one number, one uppercase letter, one lowercase letter, uppercase letter, one lowercase letter, and at least one of eight recognized and at least one of eight recognized special characters shown here within special characters shown here within double quotes “#$%^|&*=”.double quotes “#$%^|&*=”.



After authentication, a welcome After authentication, a welcome message informs that the remote message informs that the remote user is at an unrecognized, non-user is at an unrecognized, non-monitored location.monitored location.

The user home page screen shows The user home page screen shows the remote user’s registered the remote user’s registered locations and the devices and status locations and the devices and status associated with each location.associated with each location.



The top of the screen has a The top of the screen has a navigation bar that leads to other navigation bar that leads to other functions available to the remote functions available to the remote user.user.

The User Settings and Device buttons The User Settings and Device buttons are not usable by the remote user.are not usable by the remote user.

The Logs button navigates the remote The Logs button navigates the remote user to a page that allows the remote user to a page that allows the remote user to view the readings received by user to view the readings received by each device since the last alert.each device since the last alert.



The Add a New Location Link is shown The Add a New Location Link is shown on the home page, allowing the remote on the home page, allowing the remote user to navigate to a page which will user to navigate to a page which will allow the remote user to add a new allow the remote user to add a new location.location.

At this New Location page, the remote At this New Location page, the remote user must go through a registration user must go through a registration process, which after completion will process, which after completion will turn the remote user into a sensored turn the remote user into a sensored user.user.


““Read-only” UserRead-only” User

A Read-only user must open a web browser A Read-only user must open a web browser and navigate to the EIN homepage.and navigate to the EIN homepage.

A "read-only" user’s username is the user’s A "read-only" user’s username is the user’s E-mail.E-mail.

A "read-only" user’s password consists of 6-A "read-only" user’s password consists of 6-12 characters, and includes at least one 12 characters, and includes at least one number, one uppercase letter, one number, one uppercase letter, one lowercase letter, and at least one of eight lowercase letter, and at least one of eight recognized special characters shown here recognized special characters shown here within double quotes “#$%^|&*=”.within double quotes “#$%^|&*=”.


““Read-only” UserRead-only” User

After authentication, a welcome After authentication, a welcome message informs the "read-only" user is message informs the "read-only" user is at a recognized location if applicable.at a recognized location if applicable.

The User Home screen shows the The User Home screen shows the "read-only" user’s registered locations "read-only" user’s registered locations with the current location highlighted, with the current location highlighted, and the devices and status associated and the devices and status associated with each location if applicable.with each location if applicable.

The User Settings, Device, and Log The User Settings, Device, and Log buttons are all disabled.buttons are all disabled.


Website AdministratorWebsite Administrator

The website administrator opens a Web The website administrator opens a Web browser which has the EIN webpage as its browser which has the EIN webpage as its homepage.homepage.

The website administrator enters the site The website administrator enters the site administrator’s email address for the usernameadministrator’s email address for the username

The website administrator also enters the site The website administrator also enters the site administrator password which is between 6-12 administrator password which is between 6-12 characters long, features at least one number, characters long, features at least one number, one capital letter, one lowercase letter, and at one capital letter, one lowercase letter, and at least one of eight recognized special least one of eight recognized special characters shown here within double quotes characters shown here within double quotes “#$%^|&*=”.“#$%^|&*=”.



The website administrator page is The website administrator page is displayed, including a welcome displayed, including a welcome statement and a message informing the statement and a message informing the site administrator of the current location.site administrator of the current location.

The website administrator page also The website administrator page also displays the last 10 lines of recent displays the last 10 lines of recent account events by the different users, as account events by the different users, as well as, the last 10 alerts, with each well as, the last 10 alerts, with each displayed with the most recent at the displayed with the most recent at the top.top.



The bottom of the website administrator page The bottom of the website administrator page has a navigation bar which allows the site has a navigation bar which allows the site administrator to move to a complete list of administrator to move to a complete list of sensored users or devices or alerts. sensored users or devices or alerts.

The website administrator can click on the The website administrator can click on the User button and arrive at a page where the User button and arrive at a page where the site administrator can select a sensored site administrator can select a sensored user’s account and see the sensored user’s user’s account and see the sensored user’s information.information.

The website administrator can disable user The website administrator can disable user accounts or devices as necessary via the User accounts or devices as necessary via the User Information pages. Information pages.



The Devices button navigates to a page The Devices button navigates to a page where the site administrator can filter the where the site administrator can filter the devices by either sensored user’s that have devices by either sensored user’s that have the devices or by the names of the devices.the devices or by the names of the devices.

The Alerts button navigates to a page where The Alerts button navigates to a page where the site administrator can view all of the the site administrator can view all of the alerts reported for any sensored user to the alerts reported for any sensored user to the EMS with most recent displayed at the top.EMS with most recent displayed at the top.

The website administrator can filter the The website administrator can filter the alerts by sensored user location, or alerts by sensored user location, or sensored user device. sensored user device.


Development Environment Development Environment Oraserv is part of both our development and production Oraserv is part of both our development and production

environments (described later).environments (described later).

- Intel Pentium 4 CPU - Intel Pentium 4 CPU

- 1,300 MHz- 1,300 MHz

- 128 MB of RAM- 128 MB of RAM

Microsoft Windows NT Microsoft Windows NT 2000 Professional 2000 Professional

- Service Pack 3- Service Pack 3

HARDWAREHARDWARE- Intel Pentium 4 CPU - Intel Pentium 4 CPU

- 1.80 GHz- 1.80 GHz


OSOSMicrosoft Windows XP Microsoft Windows XP Professional Professional

- Version 2002- Version 2002


- Intel Pentium 4 CPU - Intel Pentium 4 CPU

- 2.40 GHz- 2.40 GHz


Microsoft Windows XP Microsoft Windows XP ProfessionalProfessional

- Version 2002- Version 2002



Development Environment Development Environment

Developer SoftwareDeveloper SoftwareApache – 2.046Apache – 2.046Internet Explorer – 6.0.2900.2180 w/ SP2 Internet Explorer – 6.0.2900.2180 w/ SP2 Macromedia Dreamweaver MX – 6.0.1722.0 Macromedia Dreamweaver MX – 6.0.1722.0 Macromedia Fireworks MX – 6.0.0.273Macromedia Fireworks MX – 6.0.0.273Microsoft Excel – 11.0.6355.0Microsoft Excel – 11.0.6355.0Microsoft Paint – 6.0.2900.2180 Microsoft Paint – 6.0.2900.2180 Microsoft PowerPoint – 11.0.6361.0Microsoft PowerPoint – 11.0.6361.0Microsoft Project – 9.0.2001.0219 SR-1Microsoft Project – 9.0.2001.0219 SR-1Microsoft Word –11.0.6359.0Microsoft Word –11.0.6359.0


Development Environment Development Environment

Developer SoftwareDeveloper SoftwareMozilla Firefox – 1.0.0Mozilla Firefox – 1.0.0mySQL – 4.1.14mySQL – 4.1.14Netscape – 7.1 Netscape – 7.1 Oracle – 10 gOracle – 10 gPHP – 4.3.11PHP – 4.3.11Putty - 0.53b Putty - 0.53b Visible Analyst Workshop - 7.5.5 Visible Analyst Workshop - 7.5.5

WinSCP - 3.1.0.165WinSCP - 3.1.0.165


Production EnvironmentProduction Environment

Oraserv’s operating system is Red Oraserv’s operating system is Red Hat Enterprise Linux ES release 3. Hat Enterprise Linux ES release 3.

ApacheApache mySQLmySQL Oracle Oracle PHPPHP


TestingTesting

Unit TestingUnit Testing

Integration TestingIntegration Testing

System TestingSystem Testing

Acceptance TestingAcceptance Testing


Acceptance TestAcceptance Test

Sensored UserSensored UserLogin pageLogin page

Can enter e-mail for usernameCan enter e-mail for username Can enter password, 6-12 characters long, Can enter password, 6-12 characters long,

at least one number, capital letter, at least one number, capital letter, lowercase letter, and one of eight lowercase letter, and one of eight recognized special characters shown here recognized special characters shown here within double quotes “# $ % ^ | & * =”within double quotes “# $ % ^ | & * =”

Submit button works and submits the Submit button works and submits the information within the e-mail and information within the e-mail and password fieldspassword fields


Acceptance TestAcceptance Test

Sensored UserSensored UserLogin pageLogin page

Submit button sends the sensored user to Submit button sends the sensored user to the logged-in screen which is a user the logged-in screen which is a user homepage with a welcome message, as well homepage with a welcome message, as well as a message informing the sensored user as a message informing the sensored user that the user is at a recognized, monitored that the user is at a recognized, monitored location.location.

The forgotten password link works and The forgotten password link works and guides the sensored user with instruction guides the sensored user with instruction on getting a working passwordon getting a working password

The FAQ link worksThe FAQ link works The new registration link worksThe new registration link works


Unit TestUnit Test


New User-EIN Home New User-EIN Home PagePage


New User-RegistrationNew User-Registration


Sensored User-Login EIN Sensored User-Login EIN HomeHome


Sensored User-HomeSensored User-Home


Sensored User-AlertsSensored User-Alerts


Sensored User-Device Sensored User-Device MGMTMGMT


Sensored User-User Sensored User-User SettingsSettings


Sensored User-LogsSensored User-Logs


Remote User-LoginRemote User-Login


Remote User-HomeRemote User-Home


Remote User-LogsRemote User-Logs


Site Administrator-LoginSite Administrator-Login


Site Administrator-HomeSite Administrator-Home


Site Administrator-Site Administrator-Home(Cont)Home(Cont)


Site Administrator-Alert Site Administrator-Alert FilterFilter


Read Only User-HomeRead Only User-Home


Gantt ChartGantt Chart

Development PlanDevelopment Plan

TestsTests


Classic Waterfall ModelClassic Waterfall Model

Step 3: Preliminary DesignStep 3: Preliminary Design


Classic Waterfall ModelClassic Waterfall Model

Step 4: Detailed DesignStep 4: Detailed Design


What’s Next?What’s Next?

Tentative DatesTentative Dates

Detailed Design – February 15Detailed Design – February 15thth, 2006, 2006

Acceptance Test – April 25Acceptance Test – April 25thth, 2006, 2006


Summary & QuestionsSummary & Questions

Any Questions?Any Questions?

december 5, 2005 1 remote monitoring system ein systems environmental intelligence network systems...

Documents

user accounts able

sensored user account

sensored location data

unmonitored location

user guest account able

user use case

logs able

sensor able