Advanced DBMS Assignment

1. What primary characteristics should an OID possess in object-oriented databases?
2. What is the difference between persistent and transient objects? How Persistence is handled in typical object oriented database systems?
3. What are the differences and similarities between objects and literals in the ODMG Object Model?
4. Discuss the various type constructors. How are they used to create complex object structures?
5. How do regular inheritance, multiple inheritances, and selective inheritance differ?
6. What is meant by the term heuristic optimization? Discuss the main heuristics that ore applied during query optimization.
7. Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done.
8. What is meant by the concurrent execution of database transactions in a multiuser system? Discuss why concurrency control is needed, and give informal examples.

C. Discuss the different types of iransaction iaiiures.
10.Draw a state diagram, and discuss the typical states that a transaction goes through during execution.
1 1. Discuss the atomicity, durability, isolation, and consistency preservation proper- ties of a database transaction.
12.Define the violations caused by each of the following: dirty read, nonrepeatable read, and phantoms.

1. What is a serial schedule? What is a serializable schedule? Why a serial schedule is considered correct? Why is a serializable schedule considered correct?
2. What is the two-phase locking protocol? How does it guarantee serializability!
3. What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?

Answer rating: 100% (QA)

Primary Characteristics of an OID in ObjectOriented Databases An OID Object Identifier in objectoriented databases should possess these primary characteristics Uniqueness Each object should have a uni... View the full answer