ADVANCED DATABASE TECHNOLOGY

PART -A

  1. Define database recover. Write two recovery techniques.
  2. Why we need normalization?
  3. Mention any four features of distributed database system.
  4. What is an important two phase commit protocol?
  5. Expand ODMG. When it is necessary?
    6. Click here to join us on Social Media for getting instant update on every notice
  6. Write any two limitation of JASMINE.
  7. Define mobile database with an example.
  8. List the markup languages which are suitable for web databases.
  9. Write two examples of multimedia databases and multimedia structure.
  10. Define spatial database.

PART- B

  1. (a) What is query optimization? Explain any two Optimization techniques in detail with suitable example.

                                                                       OR

 (ii)Draw an ER model for university which will published examinations results of all colleges which  is affiliated to it and individual results for each college.

  1. (a) Explain the architecture of distributed database in detail.

                                                         OR

 (ii) List and explain the features of DDB.

  1. (a) (i) Explain the different approaches used for object oriented databases.

(ii)Write detail note on ODMG model.            

    (b)Discuss in detail about structure and various operation of object oriented query language.

  1. (a) Briefly discuss client/server model with suitable example.

                                                         OR

 (ii)Explain the major role of Xml in web databases.

  1. (a) (i) Explain how to identify an active and deductive databases with an example.

(ii)Write detail note data mining with its various techniques.

                                                         OR

     (b)Write note on

(i) Spatial database

(ii)Query language for multimedia (iii)Multimedia databases                   

1. Write an SQL query to retrieve employee name and I'd from a table employee?

2.

What is Concurrency Control?

Differentiate intra query parallelism from inter query parallelism. Differentiate distributed database and normal database. 4.

3.

5.

How transaction is performed in Object oriented database?

6. What is versioning in terms of object oriented databases?

7. List the advantages of XML. over HTML.

8. Specify the advantages of Data warehousing. 9. How spatial databases are more helpful than active database?

10. What is deductive database?

PART B (5 x 1680 marks)

11. (a) (i) Illustrate and discuss the steps involved in processing neat diagram.

a query with (12)

(ii) Discuss briefly on database tuning.

(4)

Or

(b) Explain the following with an example in relation model

(i) Transaction Processing

(16)

(i) Query Optimization.

12. (a)

(i)

Explain with a neat diagram the architecture of databases also mention its uses.

distributed (8)

(ii) example.

Discuss the ACID properties of a transaction with relevant

(8)

Or

Explain the Distributed transactions Processing with suitable example.

(b) (i)

(10)

(1) Explain the role of recovery subsystem in a distributed

environment.

13. (a)

(1) Explain the object oriented database and its approaches. (ii) Explain the component of the ODMG model with example.

(8)

(8)

Or

Discuss the transaction states in object oriented databases.

(8)

(b) (i)

(ii) What is POSTGRES? Explain it in detail.

(6)

(8)

14. (a)

15.

811

147

410

(1) How XML are processed and stored in web database? Explain with

(ii)

(8) Explain the process of mobile database and its advantages over

an example.

other database.

(8)

Or

(8)

(8)

(b) (1) Explain the steps involved in constructing a data warehouse.

(ii) Explain about the decision trees in the process of data mining.

(a)(1)

Describe the active and deductive database and compare with each other.

(8)

GD

Explain the role and use of multimedia database for current (8)

technologies.

(b) Elaborate of the following with an example

(16)

(i) Spatial databases (ii) Multimedia query with complex types.