Welcome to CUA ECommerce

1
Welcome to CUA E-Commerce

• Senior Design Project
• Joshua R. Schellhammer
• Roselene K. Gomes
• Kieran S. Fitzpatrick
• SeniorDesignTeamA

2
CUA-Commerce Big Picture
3
MySQL

• MySQL my Structured Query Language
• Free, open source database available for many
  computing platforms.
• Database Management System (DBMS) for relational
  databases ?MySQL is RDBMS
• Manages databases

4
Features of MySQL

• Increased Speed
• Direct use of InnoDB tables
• Secure transactions via SSL
• Many column types signed/unsigned integers 1, 2,
  3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR,
  VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME,
  TIMESTAMP, YEAR, SET, and ENUM types.
• Handles large databases
• MySQL is a client/server system that consists of
  a multi-threaded SQL server that supports
  different backends, several different client
  programs and libraries, administrative tools, and
  a programming interface.

5
Database Security

• Three concepts
• Establish proper users and privileges
• Safely store and protect user and password
  information
• Validate submitted data before storing it in a
  database

6
Examples of MySQL Privileges
7
CUA-Commerce Tables
8
Database Fields and Tables
9
Web-to-Database Middleware

• Server-side extension
• Interacts directly with Web server and Database
• Handles program specific requests.
• Coldfusion (.cfm)
• PHP Hypertext Preprocessor (.php)

10
Web Server Interfaces

• Application Programming Interface (API)
• Functions that are provided to work with a
  component, application, or operating system.
• Open Database Connectivity (ODBC)
• API developed by Microsoft.
• Provides driver between Windows Applications.
• MySQL Connector/ODBC
• Connects to Coldfusion to MySQL database.

11
ColdFusion MX

• Web application server
• Flexibility Windows, Unix, MS Access, Oracle,
  MySQL.
• Divisions
• Coldfusion Markup Language (CFML)
• Server-side markup language within HTML.
• Define Functionalities
• Coldfusion Application Server (CFAS)
• Processes Coldfusion Script Pages
• Runs on Web Server

12
How ColdFusion Works

• Client requests Coldfusion Script page (.cfm)
• Request goes to Web Server
• ColdFusion application server executes .cfm
  script
• Data transmitting or retrieval from database.
• Coldfusion sends resulting output in HTML format
  to the Web Server.
• Web server sends to client browser.

13
How ColdFusion Works (cont.)
14
Data Security

• User Confidence
• No security, No customers
• Secure transactions using encryption
• Coldfusion Protocols
• Provides basic security
• Well designed security system needed
• Secure Socket Layers (SSL)
• Program Layer
• HTTPS Protocol
• Encryption Complexity
• Popularly used, and supported.
• Internet Explorer, Netscape.
• Oracle, MS Access, MySQL, etc.

15
JavaScript, HTML, DHTML, miscellaneous acronyms

• HTML
• Hyper Text Markup Language
• DHTML
• Dynamic Hyper Text Markup Language
• JavaScript
• Dynamic Page Links and miscellaneous
• Coldfusion .cfm pages
• Funtional data directions facilitating transfer
  between MySQL database and information transer
  from page to page.
• CSS Page Design
• Cascading Style Spreadsheets.
• New Way to add levels of abstraction to Design

16
Web Design

• NotePad
• Initial web page editing software.
• Simple, but no help.
• Textpad
• Moving into editing software that recognizes
  syntax and semantics of the used language.
• Very useful in coding.
• Dreamweaver
• Highly stylized web design software. Much of
  what is to be written is done for the user.
• This option is still up in the air.

17
Web Design (cont.)
The most important aspect
To tie all three sections of the CUA-Commerce
Design Project. Into one smoothly running
web-application package. There are entire sites
devoted to the sales of this product as a
package, often charging monthly for licensing
fees.
18
Front-End User Interaction

• The most difficult and confusing variable that a
  computer scientist will ever have to deal with is
  the end user of a system. They are fickle, often
  uneducated, and do not know how to express what
  they want in the correct terminology. But in the
  end, the user is the only thing that matters.
• Users tend to quit their visit to a site after
  waiting for 8-15 seconds for a response
• Gruhn, Volker and Mocker, Martin and Schope,
  Lothar 2002, Development of an Electronic
  Commerce Portal System using a Specific Software
  Development Process. Research and Practice in
  Inforation Technology, Vol. 10, 93-101.
• Even if the data remains mostly unchanged, its
  presentation is subject to change over time.
• Dickinson, Kate 1998, Keeping An Electronic
  Commerce Shop. Standardview 6, 3 106-109.

19
E-Commerce Examples

• What not to Do
• efollett.com
• What to Do
• Amazon.com
• Barnesandnoble.com
• And Now, To the Web