JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech IV DISTRIBUTED DATABASES Previous Question Paper (January/February - 2023 - R18)
Note: i) Question paper consists of Part A, Part B. ii) Part A is compulsory, which carries 25 marks. In Part A, Answer all questions. iii) In Part B, Answer any one question from each unit. Each question carries 10 marks and may have a, b as sub questions.
Part A
What is a distributed database management system?
Answer
A Distributed Database Management System (DDBMS) is a software system that manages a distributed database while making the distribution transparent to the user. It enables the management of data stored across multiple physically dispersed sites connected by a computer network, ensuring that the collection of data appears as a single, logically integrated database to the end-user or application.
What is network transparency?
Answer
Network transparency, also known as distribution transparency, is a property of a distributed database system that allows users and applications to operate on data without needing to know the physical location of the data or the network topology of the system. It ensures that the distributed nature of the database is hidden from the end-user.
Key aspects include:
- Location transparency: Users can access data using a logical name without specifying the node or site where the data resides.
- Naming transparency: A unique global name is provided for all data objects, ensuring that the same name refers to the same object regardless of the user's location.
- Communication transparency: The system automatically handles the complexities of network protocols and data transmission between sites, making the network infrastructure invisible to the user.
State the need for Query decomposition.
Answer
Sign in to view the complete answer paper.
What are the objectives of query processing?
Answer
Sign in to view the complete answer paper.
Define a wait-free graph.
Answer
Sign in to view the complete answer paper.
Differentiate between basic TO and Multiversion TO algorithm.
Answer
Sign in to view the complete answer paper.
Define abort and commit commands.
Answer
Sign in to view the complete answer paper.
What are the two rules that govern the global termination of a transaction?
Answer
Sign in to view the complete answer paper.
Define the term Composition and give an example with respect to DDBMS.
Answer
Sign in to view the complete answer paper.
Discuss about sub classing and inheritance in DDBMS.
Answer
Sign in to view the complete answer paper.
Part B
Explain the components of a Distributed DBMS with a neat diagram.
Answer
Sign in to view the complete answer paper.
Discuss the design issues of Distribute Databases.
Answer
Sign in to view the complete answer paper.
Present a formal algorithm for horizontal fragmentation with an illustrative example.
Answer
Sign in to view the complete answer paper.
Illustrate the query processing problem considering an example engineering database schema.
Answer
Sign in to view the complete answer paper.
Explain in detail about localization of distributed data with relevant diagrams.
Answer
Sign in to view the complete answer paper.
Provide an overview of types of the transaction models.
Answer
Sign in to view the complete answer paper.
Explain distributed 2PL algorithm with an example.
Answer
Sign in to view the complete answer paper.
Write down the algorithm for basic Time Stamp Ordering algorithm and explain in brief.
Answer
Sign in to view the complete answer paper.
Explain about distributed deadlock detection algorithm in brief.
Answer
Sign in to view the complete answer paper.
Discuss the reasons for failures in distributed systems and explain the types of failures in distributed DBMS.
Answer
Sign in to view the complete answer paper.
Give an overview of distributed reliability protocols.
Answer
Sign in to view the complete answer paper.
Explain the following terms with respect to Distributed Object Database Management:
Horizontal Class Partitioning
Answer
Sign in to view the complete answer paper.
Vertical Class Partitioning.
Answer
Sign in to view the complete answer paper.
Compare OODBMS and ORDBMS.
Answer
Sign in to view the complete answer paper.
Outline Persistent Programming languages in details.
Answer
Sign in to view the complete answer paper.