Question
To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application information:
To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application information:
App1 at location NEW YORK : Compute payment = HOURS * PAY_RATE for every employee working in a NEW YORK project.
App2 at location PARIS : Compute payment for every employee working in a PARIS project.
App3 at location ROME : Compute payment for every employee working in a ROME project.
App4 at location TOKYO : Compute payment every employee working in a TOKYO project.
App5 at NEW YORK : Find the basic salaries of mangers of departments that have projects in NEW YORK or TOKYO.
App6 at TOKYO : Find the salaries of mangers of departments that have projects in PARIS and TOKYO.
App7 at PARIS : Find the salaries of employees working in departments in PARIS with monthly basic salary
App8 at NEW YORK: Find the names of employees in HEAD_OFFICE department.
a) Define a set of simple predicates?
b) Define a set of minterm predicates.?
c) Define fragments at each site using SQL.?
d) Define fragments using relational algebra?
Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE FNAME LNAME EMP_ID BDATE ADDRESS SALARY MGR_ID DNO DEPARTMENT DNAME DNO MGR ID MGR STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PNAME PNO PLOCATION DNUM WORKS ON EMPD PNO HOURS PAY_RATE To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application information: Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE FNAME LNAME EMP_ID BDATE ADDRESS SALARY MGR_ID DNO DEPARTMENT DNAME DNO MGR ID MGR STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PNAME PNO PLOCATION DNUM WORKS ON EMPD PNO HOURS PAY_RATE To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application informationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started