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

  Review of object oriented software development methodologies

Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

  Root cause of problem if databse doesn-t give information

Company's databases do not give them with information required for market planning, lead generation, and account management. What does author say is root cause of this problem?

  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.

  Write functional dependencies in table concerns invoicing

Write the functional dependencies in the following table that concerns invoicing (an application Premiere Products in considering adding to its database), subject to the specified conditions.

  Prepare a database design specification

Understand and interpret a set of business rules for a database and create an Enhanced Entity Relationship Diagram that models the requirements accurately

  Explain database models-hierarchical and relational

Explain each of three database models, hierarchical, relational, and object-oriented, and provide specific referenced example of each of these model types implemented in a functioning database

  Traditional file systems and modern database environment

Write down the difference between traditional file systems Vs modern database environment. Describe the following: Physical data independence Vs logical data independence

  Importance have button that takes you back to main page

What is the importance to have a button that takes you back to the main page on each web page? How does dead end or orphan pages affect the continuity of a website?

  Explain the security mechanisms available for a database

Use technology and information resources to research issues in database systems. Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  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).

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