Homework Problems

HW	Laboratory	Problems	Other
1	L1: SQL review, Files, Index	13.27, 13.28, 13.29, 14.15, 14.16	S1
2	L2: Query Optimization	15.13(Q8,Q27), 15.16, 15.22, 17.23, 17.24	S2
3	L3: Transactions	18.25, 19.22, 19.23, 23.22	S3
4	L4: Security, Data Warehouses, Mining	25.21,28.6,27.14, 27.19, 26.9	S4

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

Problems S1 ... S5

• S1: 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:
6. Compare and contrast clustering index (ch. 8 Ramakrishnan or Ch.14.1.2(4th), Ch.6.1.2(3rd) Elmasri/Navathe) described in the textbook with the Oracle cluster data structure (pp. 97-98, supplementary book,)
7. Compare and contrast Oracle indexing methods with those discussed in the textbook (ch. 8-10 Ramakrishnan or ch.14(4th), ch.6(3rd) Elmasri/Navathe).
• S2: Study chapters 4 and 7 of the supplementary book to answer the following:
1. Compare and contrast heuristic query optimization (Ch. 15 Ramakrishnan or Ch.15.7.2(4th), Ch.18.3(3rd) Elmasri/Navathe) with rule-based query optimization (pp. 106, supplementary book).
2. Compare and contrast isolation levels supported in Oracle with those in SQL.
3. Compare and contrast database statistics for cost-based optimization used by Oracle (table 4-1, pp.108, supplementary book) with those discussed in the textbook (Ch. 15 Ramakrishnan or Ch.15(4th), Ch.18(3rd) Elmasri/Navathe)
• S3: Study chapter 7 o the supplementary book to answer the following:
1. Compare and contrast the concurrency control techniques (CCT) used by Oracle (pp. 183-189, supplementary book) with two-phase locking (Ch. 17.1 Ramakrishnan or Ch.18.1.2(4th), Ch.20.1.2(3rd) Elmasri/Navathe).
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, loggin rules
• S4: Study chapters 5 and 9 of the supplementary book to answer the following:
1. Compare and contrast SQL security facilities (Ch. 21 Ramakrishnan or Ch.23.2(4th), Ch.22.2(3rd) Elmasri/Navathe) with those in Oracle (pp. 118-128, supplementary book).
2. List a few Oracle query optimization facilities for data warehouse application.
3. Compare and contrast Oracle database options (pp. 305-308, supplementary book) with enhanced data models (Ch. 23 Ramakrishnan or Ch.24(4th), Ch.23(3rd) Elmasri/Navathe)
• S5: Study chapter 12 of the supplementary book to answer the following:
1. Summarize the object-relational features in Oracle.
2. List a few applications which can benefit from these features in Oracle.
3. Compare the object model in Oracle with that in object oriented programming languages (e.g. Java, C++).