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

  Draw object-oriented model for private airport database

Draw an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  Analysis of a simple case study

VSS has an existing software package that controls its high bay systems and wants to rewrite it. The existing system is written in C and uses C-ISAM files to store data.

  Create entity-relationship diagram for bookstore database

Create Entity-Relationship diagram for a bookstore database, that maintains information about books, professional journals, their authors, and publishers.

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Create database of measured meteorological data

You are creating a database of measured meteorological data for use in weather and climate research. Explain a structure type measured_data_t with components site_id_num.

  Write program that models an employee

Write a program that models an employee. An employee has an employee number, a name, an address, and a hire date. A name consists of a first name and a last name.

  Create a set of dependency diagrams for the abs database

Consider a case that is not described above, but could happen in the business of the ABS. Please explain the case and why it might occur and based on the case you proposed, modify your design of the ABS database accordingly.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Design data file grades with records of form

Input names of students from user, terminated by ZZZ, and design the data file GRADES with records of form: student (string), test1 (integer), test2 (integer), test3 (integer).

  How referential integrity constraint prevent data

In physical database design, referential integrity constraints can be defined. What actions does referential integrity constraint prevent from happening when data is inserted in table which contains this constraint?

  A university library database records

A university library database records information about books; for each book, it records the book isbn number (which is unique), and the book name. In addition, it records which books have been checked out

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