Transcript design_demo

DataFlow Diagram – Level 0
DDF – Level 1
► Breaks
down each process
► Shows
exactly what each data is and where
it flows
► Six
Processes, Six Different Breakdowns
DDF – Level 1, User Login &
Display Favorites
DDF – Level 1, Produce Favorite
Stocks & Display Stock Quotes
DDF – Level 1, Registration &
Administrator Login
Modules
► These
Level 1 Processes, data flows,
external entities, and data stores are the
basis for what determines the major
modules.
► The objects for the modules can be viewed
here
Web Site Modules – Users
► New
User (register.php)
 Add a new user to database
► Existing
User (logon.php)
 Query database, if user and password is valid
connect to user home page (my_stocks.php)
Web Site Modules – Users
cont.
► User




Home Page
Add Stock
Remove Stock
Search for a Stock
Log out
► Log
Out
 Logs a user out of the website
Web Site Modules Administrators
► Log
On (admin.php)
 Verify administrator Id and password
► Delete
Users (delete.php)
 A query of users to be deleted will show up
once an administrator has successfully logged
on
 Once a user has been deleted the database will
get updated
Phone Application Modules
► Access
given only to existing users
► Log On (login.wml)
 Queries database, if user and password is valid,
connect to user homepage (home.wml)
► Home
Page
 Provides the user to check stored stocks
(mystocks.wml), view market info
(market.wml), search the internet for a stock by
using the stock symbol (search.wml)
Phone Application Modules –
cont.
► Searching
application allows:
 Gives an error message if stock symbol entered
is invalid
 Allows the user to view current market info
 Allows the user to add that stock to their
favorites
► Log
out
 Provide user to exit out of phone application
Database Structure
► Data
Dictionaries can be found here
Technical Overview
► Developing
an application to obtain realtime stock information from your mobile
phone
► Using
PHP, MySQL, HTML, WML, WMLScript
and SQL
► We
will be obtaining the real-time stock
information from Yahoo! Finance CSV files.
Technical Issues : HTML vs. WML
► Modules
will use one set of data to produce
either HTML or WML depending on device
initiating the request
Technical Issues : Network
► If
the network goes down or the Yahoo!
server crashes, we must present the user
with an error message, but will not crash
Fast Stocks
► We
could store old stock quotes, but storing
out of date information is counterproductive
Technical Issues : Network
► PHP
provides built in functionality for
connecting and reading Internet files, so no
additional protocol software needs to be
written
► Sessions
will be initiated each time a user
registers and logs into the system from
either the mobile phone or a web browser
Technical Issues : Database
► MySQL
has no set limit to the number of
concurrent database connections, it
depends on the server configuration
► MySQL
► MySQL
handles record locking natively
handles security by using a
configurable Privilege System
Technical Issues : Database
► PHP
has functionality to work with MySQL
databases
► Administrative
functions will be include to
manage the database
► phpMyAdmin
is installed and will allow
powerful remote database management
Software Used
► Excel
► Microsoft
Word
► Ulead PhotoEditor
► Microsoft Access (for now)
Planning