Compare horizontal and vertical fragmentation in distributed databases. Provide examples toillustrate how each technique optimizes query performance.

by

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

Explain the basic concepts of distributed databases and why they are necessary in modern computingenvironments.

by

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- 2022/2023

by

Level Master Program MCIS Semester Fall/Spring Year 2022/2023 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Attempt all the questions.

Software Project Management – 2022, Spring

by

Level Master Program MCIS Semester Spring Year 2022 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicates full marks Attempt all the questions

Define beneficial semi join. How do you choose best join order in System R algorithm? Explain with example. Descibe hill climbing algorithm to find the initial feasible solution.

by

A beneficial semi join is a type of join optimization technique used in distributed databases, especially when performing joins across sites in a distributed system. The goal is to reduce the amount of data transferred between sites by using a “semi join” approach. A semi join involves sending only the keys (or attributes) from one … Read more

Explain query decomposition layer in distributed query processing with examples.

by

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

Software Project Management – 2021, Fall

by

Level Master Program MCIS Semester Fall Year 2021 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicates full marks Attempt all the questions

Software Project Management – 2018, Spring

by

Level Master Program MCIS Semester Spring Year 2018 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable.The figures in the margin indicate full marks. Attempt any ten questions:

Explain distributed integrity constraints. “Enforcing distributed integrity assertions is more complex than needed in centralized DBMS, even with global transaction management support” elaborate this sentence with proper constraints and examples.

by

Distributed Integrity Constraints are rules that ensure data consistency, accuracy, and reliability across multiple sites in a Distributed Database Management System (DDBMS). These constraints help maintain data integrity even when data is stored at different locations and accessed by multiple users simultaneously. The types of distributed integrity constraints are as follows: i. Primary Key Constraint: … Read more

Software Project Management – 2018, Fall

by

Level Master Program MCIS Semester Spring Year 2018 Course Software Project Management Full Marks 100 Pass Marks 60 Time 4 hrs Candidates are required to give their answers in their own words as far as practicable.The figures in the margin indicaté full marks. Attempt all the questions Activity A B C D E F G … Read more