MU Information Technology (Semester 5)
Advanced Database Management Systems
December 2014
Total marks: --
Total time: --
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary

1 (a) Explain Factless Fact Table.
5 M
1 (b) Compare OLTP vs OLAP.
5 M
1 (c) How does multilevel indexing improve the efficiency of searchingand index file?
5 M
1 (d) Explain different types of transparencies in distributed database.
5 M

2 (a) What are Triggers? Give an example.
10 M
2 (b) Explain Concurrency control in distributed database.
10 M

3 (a) Draw and Explain Data Warehouse architecture.
10 M
3 (b) Describe the three phases of the ARIES recovery method.
10 M

4 (a) Find out the data transfer cost of distributed query processing for following queries "For each employee, retrieve the employee name & name of the department for which the employee works."

Site1: Employee

Fname Minit Laname SSn Bdate Address Sex Salary SSSn Dno

10000 records each record is 100 bytes long.

SSn field is 9 bytes, Fname filed is 15 bytes, Dn field is 4 bytes, Lname is 15 bytes.

Site 2: Department

Dname Dnumber Mgrssn Mgrstartdate

100 records each record is 35 bytes long, Dnuber field is 4 bytes, Dname field is 10 bytes, Mgrssn field is 9 bytes. Query is submitted to result site 3. Consider different strategies for executing this query and find which strategy is best using natural join and semijoin.

10 M
4 (b) Explain with suitable example object identity, object structure and type constructors in OODBs.
10 M

5 (a) Explain Data loading and its types.
10 M
5 (b) Explain the Operations on files.
10 M

6 (a) Consider a data warehouse for a hospital, where there are three dimensions:
i) Doctor
ii) Patient and
iii) Time
and two measures:
i) Count and
ii) Charge,
Usin the above example describe the following OLAP operations
i) Slice
ii) Dice
iii) Rollup
iv) Drilldown
v) Pivot
10 M
6 (b) What are the different types of SQL injection attacks.
10 M

More question papers from Advanced Database Management Systems