Download Exam Information for MS322 Advanced Database Technologies (2011/2012) and more Exams Database Management Systems (DBMS) in PDF only on Docsity!
Semester I Examinations 2011/ 2012
Exam Code(s) 3BF Exam(s) 3 rd^ Business Information Systems
Module Code(s) MS Module(s) Advanced Database Technologies
Paper No. 1 Repeat Paper
External Examiner(s) Dr. Danail Ivanov Internal Examiner(s) Dr. Michael Lang Dr. Anatoli Nachev
Instructions: Answer any three questions. All questions carry equal marks.
Duration 2hrs No. of Pages 3 (incl. cover) Discipline(s) Business Information Systems Course Co-ordinator(s)
Requirements : MCQ Release to Library: Yes No Handout Statistical/ Log Tables Cambridge Tables Graph Paper Log Graph Paper Other Materials
PTO
3 rd^ YEAR BUSINESS INFORMATION SYSTEMS
MS322 ADVANCED DATABASE TECHNOLOGIES
Time Allowed: TWO hours
Answer any THREE questions. All questions carry equal marks.
Q1. A distributed database management system (DDBMS) governs the
storage and processing of logically related data over interconnected
computer systems in which both data and processing functions are
distributed among several sites.
(a) A DDBMS requires functional characteristics that can be grouped and described as transparency features. With regards to transaction transparency , distinguish between remote request, remote transaction, distributed transaction, and distributed request. Use diagrams and examples to support your answer. (25 Marks)
(b) A two-phase commit (2PC) protocol is used for implementing distributed transactions. Explain the need for the 2PC protocol and describe the two phases. (8 Marks)
Q2. World Wide Web provides a global market for products and services. From a technological perspective, this requires a superb database connectivity facilitated by proper Web interface.
Briefly outline current approaches to integrate Web and databases.
(33 marks)
Q3. A data warehouse (DW) is a copy of transaction data specifically structured for querying and reporting.
(a) Identify and briefly outline major components of a DW environment. (18 Marks)
(b) According to Bill Inmon, “A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process.” Outline the major characteristics of a DW and compare them to those of the operational databases. (15 Marks)
