Transcript Note 01

CS 3630
Database Design and Implementation
Dr. Qi Yang
213 Ullrich
My Home Page:
http://people.uwplatt.edu/~yangq/
The Class Page:
http://people.uwplatt.edu/~yangq/CS363/
CS 3630
Database Design and Implementation
Prerequisites:
CS 2430 and
MATH1630 or MATH 2730
Oracle Programming
Not a programming course
Basic theory and concepts
Required for CS and SE
2
Course Work
•
•
•
•
•
Assignments
Quizzes
Tests
Project
Final
• Total
100
100
120
80
100
500
3
Grading
Grade
A
AB+
B
BC+
C
CD+
D
F
Total Points
460 - 500
445 - 459
435 - 444
410 - 434
395 - 409
385 - 394
360 - 384
345 - 359
335 - 344
300 - 334
Below 300
Percentage
92%
89%
87%
82%
79%
77%
72%
69%
67%
60%
Grade Points
4.0
3.7
3.3
3.0
2.7
2.3
2.0
1.7
1.3
1.0
0.0
4
Final Exam
• Group #10
• Wednesday, May 11
• 7:00 – 8:52 PM
5
Graduating Seniors
Course Grade
A
AB+
B
BC+
C
C-
Points
376 - 400
364 - 375
356 - 363
336 - 355
324 - 335
316 - 323
296 - 315
284 - 295
Percentage (%)
94%
91%
89%
84%
81%
79%
74%
71%
6
Notes
•
•
•
•
Attend class
Check UWP email
Academic misconduct
The right to miss class for
religious observances
• Disability
7
Any Questions?
Let me know when you have any issues!
8
What is a computer?
Network
Input
CPU
Output
MEMORY
Storage
9
File Systems
Users
Programs
Files
10
Issues in File Systems
• Program-Data Dependence
Physical structure is defined in application code
• Separation and Isolation of Data
Information is stored in separate files
• Duplication of Data and Data Inconsistency
The same data may be stored in different departments
• Incompatible File Formats
Files from C++ and COBOL may be different
11
Issues in File Systems
• Fixed Queries
New queries requires new/modified programs
• Access Control and Security
Who can and cannot access files, fields…
Access different portions of a file
• Recovery
• …
12
Database Systems
DBMS: Database Management system
Users
Programs
D
B
M
S
Files
13
Advantages of Database
• Data Independence
– Physical structure is unknown to application code
• Data Relationship
– Primary key and Foreign key
•
•
•
•
•
Limited Duplication of Data and Data Consistency
Query Processing
Access Control
Security
Recovery
14
Disadvantages of Database
•
•
•
•
Complexity
Cost
Performance
Higher Impact of Failure
15
Database:
Underlying Framework of CIS
• Most IS are based on databases
• Fundamentally changed the way many
organizations operate
• Business without database?
16
Database:
One Important Development in
Software Engineering
•
•
•
•
•
•
Query Processing
Access Control
Transactions
Distributed computing
Networking
…
17
Roles in Database Environment
(People)
•
•
•
•
•
DA (Data Administrator)
DBA (Database Administrator)
Database Designers
Application Developers
End-Users
18
Database Management Systems
• First generation
Hierarchical
Network
• Second generation
Relational
• Third generation
OODB
GIS
Fuzzy DB
…
• Post-Relational
Google’s BigTable
Amazon's Dynamo
19
Database Security
The mechanisms to protect the database
against unauthorized access, either
intentional or accidental.
20
Threats to Database Systems
Any event or situation , whether
intentional or accidental, that may
adversely affect a database system
and consequently the organization.
21
Threats to Database Systems
• Using another person’s means of access
• Inadequate policies and procedures that allow a
mix of confidential and normal output
• Giving greater access than normal
• Inadequate staff training
• Viewing or disclosing unauthorized data
• Fire (electrical fault, lighting strike, arson)
• ...
22
Database Security: Related Issues
•
•
•
•
•
Theft and fraud
Loss of confidentiality
Loss of privacy
Loss of integrity
Loss of availability
23
Database Security
• DA
• DBA
24
Highest Academic Award in
Computer Science?
• Turing Award
• Nobel Prize of Computing
• http://en.wikipedia.org/wiki/Turing_Award
• 1981:
Dr. E.F. Codd
Relational Database Model
25
What is a computer?
Turing Machine
Network
Input
CPU
Output
MEMORY
Storage
26
Chapter 1
27