CPSC 4375
Database Concepts II
MW 4:30 PM – 5:45 PM
CLASS POLICIES
ACADEMIC ADVISING: ROSS HALL 406, PHONE: 569-8688
CLASSES BEGIN:
JAN 13,, 2003
LAST DAY TO REGISTER, ADD, OR ADJUST SCHEDULE:
JANUARY 17, BY 5:00 PM
-no refunds for dropped classes after this date
-grade of "W" for dropped classes after this date
-last day to switch from credit to audit or vice-versa
HOLIDAY CLASS CANCELLATIONS:
JANUARY 20
MARCH 24-31, Spring Break
LAST DAY TO DROP AN INDIVIDUAL CLASS
APRIL 11, BY 500PM
LAST DAY TO WITHDRAW FROM THE UNIVERSITY
MAY 1, BY 500PM
LAST DAY OF CLASSES:
MAY 1
TIME: M W 4:30PM-5:45 PM
LOCATION: ETAS 208
FINAL EXAM: 4:00PM –6:00PM, Monday – MAY 5, 2003, ETAS 233
INSTRUCTOR: Dr. William Mitchell
OFFICE: ETAS 202
TELEPHONE: 683-7117
E-MAIL: wmmitchell@ualr.edu
OFFICE HOURS: 10-11 daily
PREREQUISITES: CPSC 3375 or instructor permission.
ATTENDANCE: Regular attendance is expected of all students.
EXAMINATIONS: There will be no makeup on quizzes or exams.
ASSIGNMENTS:.
COLLUSION: Unless otherwise stated Collusion on assignments is strictly prohibited. However, a class listserv will facilitate students sharing information about the assignments. .
DISABLED STUDENT POLICY:
It is the policy of UALR to accommodate students with disabilities, pursuant to federal and state law. Any student with a disability who needs accommodation, for example in seating placement or in arrangements for examinations,
should inform the instructor at the beginning of the course. The chair of the department offering this course is also available to assist with accommodations. Students with disabilities are also encouraged to contact the Office of Disability Support Services, which is located in the Donaghey Student Center, Room 103, telephone 569-3143.
HELP
There is now a help desk in ETAS 308 that is open from 8-6 M-Th, 8-5 on Fridays, and 9-3 on Saturday. Some questions can be answered immediately at the help desk and the rest will be collected and the answers posted within 24 hours. Questions can be posted to http://cyberhelp.cc.ualr.edu
ADVICE
Many students at UALR have families and jobs and other pressures on their time. Often these conflicting responsibilities interfere with course work. Classes may be missed, assignments may be late, lack of study time may result in bad test performance. When students find themselves in a hole, especially during the short summer session, they often think that their only option is to bail out. No matter how deep you think your hole is, do not drop a class or resign from UALR before talking to at least one of the following:
1. Katie Young, Cybercollege Academic Advisor (569-8715)
2. Academic Advising (569-3386)
3. Financial Aid (if you have a loan or grant) (569-3035)
4. Any faculty member in your major department
5. the instructor of the class you propose to bail out of.
Course Credit Distribution:
GRADING: Homework assignments = 30 %
Two exams 40 %
Final exam 30%
Total 100 %
Nominally the usual 10 point scale is used.
90 - 100 A
80 - 89 B
70 - 79 C
60 - 69 D
BELOW 60 F
CPSC 4375
Database Concepts II
Syllabus
Prerequisites
CPSC 3375 or equivalent.
Description
Advanced in-depth study of indexing, security, query processing, transactions; introduction to data warehousing; parallel and distributed databases. Three hours lecture per week. Three credit hours.
Text Database Principles, Programming, and Performance, 2nd Edition
Author Patrick O’Neil and Elizabeth O’Neil
Publisher Morgan Kaufman Publisher
Text ORACLE 8 Programming A Primer
Author Rajshekhar Sunderraman
Publisher Addison-Wesley
Computer Based Training (CBT)
CBT Tutorials at UALR can be found at http://cbt.cs.ualr.edu.
The University of Arkansas at Little Rock has made available Computer Based Training materials free to all UALR students and employee. Simply go to the site above and follow the directions.
Note: Your username is your VAX username in all uppercase letters (i.e. CWFORD). The password field should be left blank initially.
You may change your password by going through the User Preferences navigation and selecting password.
|
Day |
Topic |
Assignment |
|
Jan 13 |
1. Review |
|
|
Jan 15 |
2. Review, Oracle accounts |
|
|
Jan 20 |
Holiday |
|
|
Jan 22 |
3 Definitions, Relational Alg, SQL |
Load CAP |
|
Jan 27 |
4 Finish Chapter 3 |
Run sample queries |
|
Jan 29 |
5 Review CAP queries |
Ex. 3.11 3.12, 3.15 |
|
Feb 3 |
6 Review FD, Normal Forms (6.5-6.8) |
Ex. 6.4, 6.6, 6.12, 6.20, 6.23 |
|
Feb 5 |
7 7.1 Integrity |
Ex 7.1, 7.6, 7.7. 7.8 |
|
Feb 10 |
8 7.2 Views |
Ex 7.9 |
|
Feb 12 |
9 7.3 & 7.4 DBA data |
Ex 7.5 |
|
Feb 17 |
10 Review |
|
|
Feb 19 |
11 Exam #1 |
|
|
Feb 24 |
12 8.1 & 8.2 Disk space |
Ex 8.1, |
|
Feb 26 |
13 8.3 B-tree Index |
Ex 8.4 |
|
Mar 3 |
14 8.4 Clusters |
Ex 8.7 |
|
Mar 5 |
15 8.5 Hash Indexes |
Ex 8.8 |
|
Mar 10 |
16 8.6 Hash tables |
Ex 8.9 |
|
Mar 12 |
17 Query Optimization 9.1 & 9.2 |
Ex 9.1 |
|
Mar 17 |
18 Indexes and Filters 9.3-9.6 |
Ex 9.4, 9.6, 9.8 |
|
Mar 19 |
19 Joins 9.7 |
|
|
Mar 24 |
Spring Break |
|
|
Mar 26 |
Spring Break |
|
|
Mar 31 |
20 Sorting and Performance 9.8-9.11 |
Ex 9.11, 9.11 |
|
Apr 2 |
21 Review |
|
|
Apr 7 |
22 Exam #2 |
|
|
Apr 9 |
23 Transactions: 10.1 |
|
|
Apr 14 |
24 serialization 10.2 &10.3 |
Ex 10.2, 10.6 |
|
Apr 16 |
25 locking and isolation 10.4 & 10.5 |
Ex 10.12 |
|
Apr 21 |
26 recovery 10.6-10.10 |
Ex 10.8 |
|
Apr 23 |
27 Parallel DB architecture 11.1 & 11.2 |
|
|
Apr 28 |
28 Shared-Nothing Arch. 11.3 & 11.4 |
Ex 11.1 |
|
Apr 30 |
29 Review |
|
|
May 5 |
Final Exam |
|