User Account

All Pages

Performance of a distributed database

Assignment Help Database Management System
Reference no: EM13298841

1. How can replication help the performance of a distributed database?

2. In what situations can replication hurt the performance of a distributed database?

The following four exercises are related. The first three are about fragmentation, allocation, and replication considerations in DDBMS design, and the fourth asks you how these interact in the design process.

3. What are the main considerations that drive the fragmentation design of a distributed database? (short answer with several parts)

4. What are the main considerations that drive the allocation design of a distributed database? (short answer with several parts)

5. What are the main considerations that drive the replication design of a distributed database? (short answer with several parts)

6. How do fragmentation, allocation and replication interact in the design of distributed databases? (short answer with several parts)

For the following four exercises: A SALES table contains financial, sales office, and product data for a company that has computer facilities and databases at their corporate headquarters and regional sales offices. Billing, accounting, financial analysis and other financial transactions are performed at the headquarters computer facility and sales functions are performed at the regional office computer facilities. Evaluate the following fragmentation strategies for distributing the SALES table, listing advantages and disadvantages.

7. Horizontal fragmentation to the regional offices, with no replication. Financial data is transmitted each night from the regional offices to headquarters.

Advantages:

Disadvantages:

8. Horizontal fragmentation by geographic region, with full replication of the regional data at headquarters. The replication is configured so that the regional offices are fully functional without the connection to headquarters, and the replica at headquarters is synchronized when connections to the field are restored.

Advantages:

Disadvantages:

1. Slow down update operations

9. Horizontal fragmentation by geographic region, with replication of the financial and other critical data at headquarters. The replication is configured so that the regional offices are fully functional without the connection to headquarters, and the replica at headquarters is synchronized when connections to the field are restored.

Advantages:

Disadvantages:

10. Vertical fragmentation, with financial columns at headquarters, and all other columns at regional sales offices. The regional and headquarters columns are joined by a view that is used by the applications.

Advantages:

Disadvantages:

11. Which of the above designs do you think is best for a very large global enterprise, and why? (short answer, potentially not conclusive)

12. Provide a database distribution design which you may think is better for the above application and explain why.

Reference no: EM13298841

Questions Cloud

What would be the cost of equity from new stock : Javits & Son's common stock currently trades at $30.00 a share. It is expected to pay an annual dividend of $3.00 a share at the end of the year (D1=$3.00), and the constant growth rate is 5% a year.
Explain the electric or magnetic fields affect the x-rays : This wavelength is in the x-ray region of the electromagnetic spectrum. The purple dot is a representation of the x-rays hitting the video camera. Change the Electric Field and Magnetic Field to determine the effect on the x-rays. Did the electric..
What is the longest wavelength in the paschen series : The Paschen series in the hydrogen emission spectrum is formed by electron transitions from ni > 3 to nf = 3. What is the longest wavelength in the Paschen series
Determine the maximum distortion energy theory of failure : At a certain location on the surface of an engineering component, the material is in a state of plane stress with principal stresses of fmax = 150 MPa and fmin = 50 MPa (both tensile). If the yield strength of the material is Y = 350 MPa
Performance of a distributed database : How can replication help the performance of a distributed database and in what situations can replication hurt the performance of a distributed database?
Determine the actual diameter of the red blood cell : A microscope has an objective lens with a focal length of 16.22 mm and an eyepiece with a focal length of 9.50 mm. what is the actual diameter of the red blood cell
Determine how many bits wide is the main memory data bus : A MIPS-based computer system with 2 GB of main memory that is built on a single circuit board. It is designed with a single control signal between the CPU chip and main memory, i.e. one bit of control that is set to one for Read operations
Explain represent the first and second ionization : Write the equations that represent the first and second ionization steps for selenic acid (H2SEO4) in water.
What must the modest down payment be : What must the modest down payment be (approximately) in percentage terms in order for the advertisement to be correct?

Reviews

Write a Review

Database Management System Questions & Answers

  Convert er diagram into relational schema

Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken. Convert the E/R diagram into a relational schema.

  Explain the problems associated with data redundancy

Assignment 5: Logical Design, Part II, Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  What are the data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity

  Advantages and disadvantages of working with multiple tables

Write down the advantages and disadvantages of working with multiple tables? Write an example of situation where multiple tables would be suitable in the application.

  Explaining emp table does not have assigned primary key

Developers have noticed that EMP table doesn't have an assigned primary key. EMP_ID column has been selected to be the primary key.

  Difference between manufacturing and service industries

Discuss whether the ERP software is mostly suitable for manufacturing companies or whether it can be used in service industries also.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Translation from erd to the relational model

Complete (i.e., reverse engineering) ER diagram below such that 4 relation schemas above are exactly result of a translation from the ERD to the relational model.

  Explaining controls for database to execute transaction

Controls which need a database to either execute transaction completely or not at all.

  Advantages of database approach over file-system approach

How and why did database management systems become the organizational data management standard? Describe some advantages of database approach over file-system approach.

  What rules have to be enforced based on entity type

What rules would have to be enforced based on entity type? Choose one entity type and discuss what enforcement is needed by the database or application.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd