Consider a relation that is fragmented horizontally

Assignment Help Basic Computer Science

Reference no: EM13843469

Consider a relation that is fragmented horizontally by location (plant-number):

Employee (name, address, salary, plant-number)

Assume each fragment has two replicas: one stored at the Los Angeles site and one stored locally at the plant site. Describe a good processing strategy (in outline, not SQL) for the following queries entered at the Baltimore site and say why you think it is a good processing strategy.

Find all employees at the San Diego plant.
Find the average salary of all employees.
Find the highest-paid employee at each of the following sites: Omaha, Chicago, Seattle, Richmond.
Find the lowest-paid employee in the comp

Reference no: EM13843469

Questions Cloud

Problems between economic growth and environmental health : Cradle to Cradle (C2C) refers to solving problems between economic growth and environmental health includes concepts like

Explain how atp powers muscle contraction : Explain how ATP powers muscle contraction. Why is it accurate to think of each human being as the owner of a library of ancient information

Communities working with corporations to fix human problem : Examples of communities working with corporations to fix human problems such as those seen in Kouvola, Finland's paper and pulp plant is a good example of

Particular economy needs human capital-financial capital : According to the text, a particular economy needs human capital, financial capital, manufactured capital and

Consider a relation that is fragmented horizontally : Assume each fragment has two replicas: one stored at the Los Angeles site and one stored locally at the plant site. Describe a good processing strategy (in outline, not SQL) for the following queries entered at the Baltimore site and say why you thin..

Inexpensive renewable source of electricity generation : The most inexpensive renewable source of electricity generation is

Geothermal heat pumps are becoming common for commercial : Geothermal heat pumps are becoming common for commercial use because

Trend of continuing outsourcing : A call center company has decided to close a call center in the US and move the operations to Honduras. The reason is that workers in Honduras will work in a call center atmosphere for less salary than a US college graduate. What steps would you take..

Competence and commitment key factors : Chapter 5 mentions that follower competence and commitment key factors to consider as a leader. Have you experineced a situation where one of these two factors were over/underestimated

User Account

All Pages