Homework Problems

HW	Laboratory	Problems	Other
0			S0
1	L1: SQL review, Files, Index	13.27, 13.28, 13.29, 14.14(a,b,c), 14.15	S1
2	L2: Query Optimization	15.13(Q1,Q27), 15.16, 15.22, 17.23, 17.24	S2
3	L3: Transactions	18.25, 19.21, 19.23, 23.24	S3
4	L4: Security, Data Warehouses, Mining	25.21,28.6,27.14, 27.19	S4

Problems S0 ... S4 are described at the end of this document. Rest of the problems refer to the textbook.

Links to sections of Oracle10g document which might be useful in answering questions in S0...S4 are provided at the end of each section. You would require a user_id and password to view these documents; the account can be created for free from the Oracle website.

Problems S0 ... S4

• S0: Answer the following questions towards background survey and team formation:
1. Major: Csci, Comp.Eng., IT, other
2. Status: undergraduate student, M.S. student, Ph. D. student, other
3. Circle course taken: Csci 5707, Csci 4707, Csci 3322
4. Team Member's name, id, email address
5. Choice of topic for the last week of semester:
• S1
1. Compare and contrast clustering index Ch.14.1.2 described in the textbook with the Oracle cluster data structure
2. Compare and contrast Oracle indexing methods with those discussed in the textbook (ch.14).
Link to Overview of Clusters
Link to Overview of Hash Clusters
Link to Overview of Indexes

• S2:
1. Compare and contrast isolation levels supported in Oracle with those in SQL.
2. Compare and contrast database statistics for cost-based optimization used by Oracle with those discussed in the textbook (Ch.15)
Link to Oracle Isolation Levels
Link to Overview of Optimizer
Link to Query Optimizer

• S3:
1. Compare and contrast the concurrency control techniques (CCT) used by Oracle with two-phase locking (Ch.18.1.2).
2. Compare the recovery techniques used in Oracle with those described in the textbook.
3. Compare and contrast the following facilities in Oracle and textbook.
- Lock escalation
- Buffer management
- Log structure, logging rules
Link to Data Concurrency & Consistency
Link to Lock Escalation (You would need to scroll up by about 90 lines).
Link to Back up and Recovery
Link to Restore & Recovery
Link to Buffer Management
Link to Redo logs

• S4:
1. Compare and contrast Oracle security facilities with those discussed in the text book.
2. List a few Oracle query optimization facilities for data warehouse application.
3. Compare and contrast Oracle database options with enhanced data models discussed in the text book (Ch 24)
Link to Database Security
Link to Overview of Oracle Spatial
Link to Spatial Concepts
Link to Overview of Oracle interMedia
Link to Oveview of Oracle Text