SpEAK:Spring 2012 SDD


 * Home
 * Semesters
 * Spring 2012
 * Documents
 * [System Design Document]

=Introduction=

Overview
The objective of our project is to have a complete functioning prototype. This will require a functional database that will be utilized through a front end website. The website will be able to write/read/delete from the database to show its role and capabilities.

Reliability
SpEAK will be constructed by CIS students. The expectation of its development is that there will be a functioning prototype by the end of the semester that is bug(mfu) free.

Robustness
Primary functionality resides in searching functionality. Based on system infrastructure all actors should be able to use their roles in accordance to specification.

Performance: Response Time/Throughput
Relatively fast, the final project will reside on campus. The server this will be stored on is the benchmark for any ultimate timings and/or limitations of performance.

Supportability/Modifiability/Extensibility
Future CIS students will be able to work on this project. Notes will be updated in the code so the learning curve should not be drastic.

Operation and Development Costs
There will be a requirement that every member of each team spends some team every week working. This means that there will be a decent amount of free time spent on this project at little to no cost.

Security
Access to SpEAK will ultimately be limited to the UNH Manchester campus.

=System Infrastructure=

User Table
Table Name:

USER_ID

Description:

This table stores the user information for all users that access the SpEAK system.

Sample Data: +---+--+---++-+---+---+ +---+--+---++-+---+---+ +---+--+---++-+---+---+
 * User_Name | Password    | Last_Name | First_Name | Middle_Name | Other | Role          |
 * bdole    | president    | Dole      | Bob        | NULL        | NULL  | Author        |
 * boxaur   | test         | Woodbury  | Cedric     | NULL        | NULL  | author        |
 * cconn    | mysql        | Connors   | Chad       | NULL        | NULL  | Author        |
 * Dortiz   | 12345678     | David     | Ortiz      | NULL        | NULL  | Administrator |
 * jsmith   | 123456       | Smith     | Jane       | NULL        | NULL  | Author        |
 * KGarnett | password     | Kevin     | Garnett    | NULL        | NULL  | Administrator |
 * Ljames   | password     | Labron    | James      | NULL        | NULL  | Author        |
 * mmertz   | 12345        | Mertz     | Melissa    | NULL        | NULL  | Author        |
 * Podongo  | 1234         | Odongo    | Paskale    | NULL        | NULL  | Author        |
 * Tom      | 1234password | Tom       | Brady      | NULL        | NULL  | Viewer        |

Description of Fields:

Security Table
Table Name:

SECURITY

Description:

This table stores the different security roles used by SpEAK.

Sample Data: +---+-+ +---+-+ +---+-+
 * Role         | Role_Desc                   |
 * administrator | administrator security role |
 * author       | author security role        |
 * viewer       | viewer security role        |

Description of Fields:

Experiment Table
Table Name:

EXPERIMENT

Description:

This table stores information related to each experiment.

Sample Data: ++---++-+---+ ++---++-+---+ ++---++-+---+
 * Exp_ID | Description              | Keywords       | Create_Date | Title         |
 * 1 | Cedrics first experiment | Cedric, first  | 2012-04-17  | Cedric Exp #1 |
 * 2 | Cedrics second experiment | Cedric, second | 2012-04-18 | Cedric Exp #2 |
 * 3 | Cedrics third experiment | Cedric, third  | 2012-04-19  | Cedric Exp #3 |
 * 4 | Cedrics fourth experiment | Cedric, fourth | 2012-04-19 | Cedric Exp #4 |
 * 5 | Expiriment 1             | cconn1         | 2004-02-25  | Connors 1     |
 * 6 | Expiriment 2             | cconn2         | 2006-01-10  | Connors 2     |
 * 7 | Expiriment 3             | cconn3         | 2010-05-06  | Connors 3     |
 * 8 | Expiriment 4             | cconn4         | 2012-04-19  | Connors 4     |
 * 9 | Expiriment 5             | bdole5         | 2004-02-25  | Dole 5        |
 * 10 | Expiriment 6             | bdole6         | 2006-01-10  | Dole 6        |
 * 11 | Expiriment 7             | bdole7         | 2010-05-06  | Dole 7        |
 * 12 | Expiriment 8             | bdole8         | 2012-04-19  | Dole 8        |
 * 13 | Experiment 1             | Podongo1       | 2012-04-25  | Podongo1      |
 * 14 | Experiment 2             | Podongo2       | 2010-07-15  | Podongo2      |
 * 15 | Experiment 3             | Podongo3       | 2009-08-23  | Podongo3      |
 * 16 | Experiment 4             | Podongo4       | 2001-01-01  | Podongo4      |
 * 17 | 12345                    | mmertz12345    | 2012-04-22  | mmertz12345   |
 * 18 | 67890                    | mmertz67890    | 1989-09-15  | mmertz667890  |
 * 19 | 13579                    | jsmith13579    | 2007-05-13  | mmertz13579   |
 * 20 | 24680                    | jsmith24680    | 2009-12-15  | mmertz24680   |

Description of Fields:

Author Table
Table Name:

AUTHOR

Description:

This table holds the user names of the authors that created or are allowed to modify an experiment. This allows more than one user to be attached to an experiment as an author.

Sample Data: +++---+ +++---+ +++---+
 * Rec_ID | Exp_ID | User_Name |
 * 1 |     1 | boxaur    |
 * 2 |     2 | boxaur    |
 * 3 |     3 | boxaur    |
 * 4 |     4 | boxaur    |
 * 5 |     5 | cconn     |
 * 6 |     6 | cconn     |
 * 7 |     7 | cconn     |
 * 8 |     8 | cconn     |
 * 9 |     9 | bdole     |
 * 10 |    10 | bdole     |
 * 11 |    11 | bdole     |
 * 12 |    12 | bdole     |
 * 13 |    13 | Podongo   |
 * 14 |    14 | Podongo   |
 * 15 |    15 | Podongo   |
 * 16 |    16 | Podongo   |
 * 17 |    17 | mmertz    |
 * 18 |    18 | mmertz    |
 * 19 |    19 | jsmith    |
 * 20 |    20 | jsmith    |

Description of Fields: