Transcript CST 221: Database Systems - WCU Computer Science

CST 221: Database Systems
Dr. Zhen Jiang
Computer Science Department
West Chester University
Class information

Website
www.cs.wcupa.edu/~zjiang/cst221index.htm
Motivation

Why computer minor/certificate?
◦ 6 among top 10 are computer related!
(http://www.washingtonpost.com/business/economy/the-10-bestand-worst-jobs-of-2013/2013/05/03/fccd6a8e-b1ab-11e2-bbf2-
a6f9e9d79e19_gallery.html#photo=1)

Why this section?
◦ Job hunting
 WCU graduated
vs.
 UPenn, Temple, Drexel, …
◦ Something help you to stand out!
◦ How can I introduce you?
Tell you what I see at Temple
◦
◦
◦
◦
Knowledge?
Communication?
Abstraction & critical thinking
Passion and motivation
 I just need 3 credits
 How much I need to do for getting an ‘A’
 I need to care my GPA
◦ http://www.youtube.com/watch?v=lYtxA_IfQMk

Critical thinking, abstraction, motivation
◦ How can I obtain all these
◦ How can I prepare myself
◦ How can I prove myself
◦ Research project
 Critical thinking, communication, etc.
 Real competition, deadline, pressure
 More realistic system, complex programming, for instance,
http://www.cis.temple.edu/~jiang/RSU_van.pptx.
◦ Student opportunities:
http://www.cs.wcupa.edu/~zjiang/student_info.htm
◦ Sponsorship
 http://www.cs.wcupa.edu/~zjiang/ISC2013.pptx.
 NSF, NSA, etc
 Industry interns
◦ No pain, no gain
◦ Happy ending
 Need to handle those things coming from pressure:
frustration, upset, madness, etc.
 Looking for solution, not excuse.
 Deadline!
Deadline of assignment
 Class website (including ppt)+ google
search
 Hands-on experience
 Group discussion


Topics and schedule
◦ See syllabus
Integration
Administration
Security &
encryption
 Privacy & inference
 Transaction &
injection
 Sketching & hashing






Know how simply the system works, rather
than memorizing all those in the manual.
Use those generally supported phases,
statements, or rules, rather than focusing on
trick plays (For instance, no join operator!)
Use class design to better organize the data
relationship, reducing the data vulnerability
while fully maintaining all the query
requirements.

ACCESS -> SQL
◦ How this GUI interface works?

Advanced SQL (nested SQL)
◦ Who can have the control of table?

Normalization
◦ Easy to do
◦ Ambiguous in use for real application

Class design (UML) – alternative design
◦ Use case
◦ Class diagram
◦ Multiple layer

Indirect Database
◦ Server – MySQL
◦ Client – JDBC
API
integration
Databases

Relational DB
◦ The dependency relation among data

Non-relational DB
◦ Without such a relation

NonSQL DB
◦ More complicate relation structure






e.g., Kobo, Playtika (mobile service)
Fast third-party data aggregation
Globally distributed data repository
E-commerce and internet burstness
Game (data intensive applications)
Ad targeting (social networks)
Data information

Share the experience of data processing:
Word, Power point, Excel, IE, and etc.
Word

<Insert>
◦ <Symbol>
 ≥
 

<Copy> & <Paste>
◦ <Ctrl> <c>  <Ctrl> <v>
◦ <PrtSc> & <Alt> <PrtSc>  <Ctrl> <v>

<Ctrl><p>
Summer Training on Computer Science,
WCU
Power Point

<Insert>
◦ <Date and Time>
Summer Training on Computer Science,
WCU

<Slide Show>
◦ <Custom Animation>, <Add Effect>,
<Motion Path>
Summer Training on Computer Science,
WCU
Excel
Document resource:
www.cs.wcupa.edu/~zjiang/summer07_student_gra
de_sample.xls.
=average(c6:c28)
Another well used
function: SUM
Summer Training on Computer Science,
WCU

<Insert>
◦ <Chart>
Summer Training on Computer Science,
WCU
<view> <freeze panes>
 B2, $b$2


Data input
Advanced techniques (resorting to
other tools, not discussed here)
Conditional formatting table, for single
table data query
 Templates, for multiple tables
 SmartArt and Images
 Macros and Visual Basic

IE
Summer Training on Computer Science,
WCU
Summer Training on Computer Science,
WCU
Summer Training on Computer Science,
WCU
Information stored in word, Excel,
Powerpoint, PDF, txt (plain text), etc
 Share/exchange information
 PrimoPDF
http://www.primopdf.com/index.aspx

Problem

How to manage and locate the wanted
information?
Directory & files
 Multiple descriptors/requirements 
single name, single index, single data entity

Database Systems & Access
Shelly, Cashman, Pratt, “Microsoft Office
Access 2007 Comprehensive Concepts
and Techniques”, Course Technology
 Page: AC14
 Page: AC44
 Exercise 1:
http://www.cs.wcupa.edu/~zjiang/cst221_l
ab1.doc

Access

<Start>  <All program>  … 
<Microsoft Office Access 2007>

Creating a report
◦ Report wizard, page AC50-AC56
◦ Split form, page AC57-AC59

Input & Output
◦ Page AC211

Assignment 1 (see at class website)