Question: You take a new job as a database administrator at an organization that has a globally distributed database. You are asked to analyze the performance

You take a new job as a database administrator at an organization that has a globally distributed database. You are asked to analyze the performance of the database, and as part of your analysis, you discover that all of the processing for regional monthly sales reports is being conducted at the corporate headquarters location. Operations are categorized by five regions: Eastern United States, Western United States, Canada, South America, and Mexico. Data for each region are kept on a server located at the regional headquarters. What would you try to improve the time needed to create the monthly sales reports?

Step by Step Solution

★★★★★

3.29 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Optimal solutions to this situation will depend on a more detailed understanding of the exact situat... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (2056).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

What concerns would you have if you accept a job as a database administrator and discover that the database users are entering one common password to log on to the database each morning when they...

What job functions does a database administrator perform? Explain.

What job functions does a database administrator perform?

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

I could not link the case since they are protected so I copied the entire case study in pictures. I have included the links just in case...

In your analysis discuss and present your perspective on these: Start with the basic premise of the case. Briefly present the interpersonal dynamics of the interviewing committee - what is your...

Hello, Please refer to the attached document, its an assignment question consisting five question. You just have to do question 7.0,Section 1 ? To be completed by the ?Chief Executive Officer? of the...

You are the accounting manager of Banana Supermarket. One day, the CEO of the supermarket told you "Our supermarket needs internal controls because we cannot trust our employees." Required: Do you...

What is the conceptual framework of accounting?

The owner of an electronic store wants to conduct a survey to measure customer satisfaction for four different brands of washing machine purchased from his store over the past 12 months. His records...

Provide three examples of scarcity that illustrate why even the 1,210 billionaires in the world face scarcity.

Provide a users requirements specification for each of these user views.

Create local conceptual data models for each of the user views. State any assumptions necessary to support your design.

Identify important factors in the success of logical database design.

943. Jeremy was watching the news, and one of the stories was about the suspected malicious practises occurring in Jeremy's favourite shopping mall. When he wanted to share the news to his friend, he...

Oregon Transportation Inc. (OTI) just signed a contract to purchase light rail cars from a manufacturer in Germany or 2,500.000. The purchase was made in June with payment due six months later in...

Sachin has asked his flat mate Jason for a $450 loan to cover a portion of his rent and utility costs. Sachin proposes repaying the loan with $375 from each of his next two financial aid...