Question Bank

A Distributed Database Management System (DDBMS) is software that manages a distributed database, ensuring data storage, retrieval, and updates across multiple locations while maintaining consistency and coordination. It provides users with a unified view of the database, handles transactions, and ensures data integrity, security, and fault tolerance in a distributed environment. In a Distributed Database … Read more

A distributed database is a database system where data is stored across multiple physical locations or servers, which may be in different geographical areas. These databases are interconnected through a network, allowing users to access and manage data as if it were stored in a single location. Distributed databases improve scalability, fault tolerance, and performance … Read more

1. Data Fragmentation and DistributionChallenge: Views often need to aggregate or join data from multiple fragments distributed acrossdifferent nodes.Impact: This increases query complexity and communication overhead, as data must be fetched frommultiple locations. 2. Consistency MaintenanceChallenge: Ensuring that views reflect the most up-to-date data from underlying base tables, especiallywhen data is updated at different nodes.Impact: … Read more

1. Autonomy in DDB Systems: Autonomy refers to the degree of independence each database site has interms of control over its own data, transaction management, and query execution. Types of Autonomy:i. Design Autonomy: Each site can define its schema and constraints independently.ii. Execution Autonomy: Each site can decide how to execute queries and transactions.iii. Communication … Read more

Fragmentation in Distributed Databases Fragmentation is the process of breaking a large database into smaller parts, called fragments, which are stored across different locations. These fragments ensure that data can be efficiently managed and accessed while maintaining the ability to rebuild the original database without losing any information. For example, if a table T is … Read more

A distributed database is a database that is not stored at a single location but is distributed across multiple physical sites or servers. These sites may be located in different geographical locations, and the data is partitioned or replicated across these locations. Each site or node in a distributed database system can independently process transactions, … Read more

Software Project Management (SPM) is a proper way of planning and leading software projects. It is a part of project management in which software projects are planned, implemented, monitored, and controlled. Level Master Program MCIS Semester Fall/Spring Year 2022/2023 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Software Project Management- 2022/2023 … Read more

Software Project Management (SPM) is a proper way of planning and leading software projects. It is a part of project management in which software projects are planned, implemented, monitored, and controlled. Level Master Program MCIS Semester Spring Year 2022 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Software Project Management – … Read more

Query decomposition is a critical step in distributed query processing where a complex SQL query is broken down into simpler, smaller sub-queries that can be executed across different sites or nodes in a distributed database system. The goal of this process is to ensure that each sub-query can be processed locally, reducing the overhead of … Read more

SPM is a proper way of planning and leading software projects. It is a part of project management in which software projects are planned, implemented, monitored, and controlled. Level Master Program MCIS Semester Fall Year 2021 Full Marks 100 Pass Marks 60 Time 4 hrs Software Project Management – 2021, Fall Candidates are required to give … Read more