Podcast
Questions and Answers
What is the primary reason for evaluating a large number of query trees in distributed query optimization?
What is the primary reason for evaluating a large number of query trees in distributed query optimization?
What is the main target in distributed query optimization?
What is the main target in distributed query optimization?
What are the main issues for distributed query optimization?
What are the main issues for distributed query optimization?
Which approach involves running the operation at the site where the data is stored and not at the client site?
Which approach involves running the operation at the site where the data is stored and not at the client site?
Signup and view all the answers
What type of operations is appropriate for operation shipping?
What type of operations is appropriate for operation shipping?
Signup and view all the answers
What is the purpose of data shipping in distributed query optimization?
What is the purpose of data shipping in distributed query optimization?
Signup and view all the answers
What is the scientific term for a collection of databases scattered across multiple sites over a network?
What is the scientific term for a collection of databases scattered across multiple sites over a network?
Signup and view all the answers
Which scientific term describes the intelligent distribution of data fragments to improve database performance and data availability for end-users?
Which scientific term describes the intelligent distribution of data fragments to improve database performance and data availability for end-users?
Signup and view all the answers
What is the scientific term for dividing a database into various sub-tables and sub-relations so that data can be distributed and stored efficiently?
What is the scientific term for dividing a database into various sub-tables and sub-relations so that data can be distributed and stored efficiently?
Signup and view all the answers
What is the scientific term for the process that involves reducing the solution space of a query to minimize the cost of query and data transfer?
What is the scientific term for the process that involves reducing the solution space of a query to minimize the cost of query and data transfer?
Signup and view all the answers
Which scientific term describes the algorithm in distributed database systems where the controlling/client site for a query is called the buyer and the sites where the local queries execute are called sellers?
Which scientific term describes the algorithm in distributed database systems where the controlling/client site for a query is called the buyer and the sites where the local queries execute are called sellers?
Signup and view all the answers
What is the scientific term for the approach that combines data and operation shipping in a distributed system?
What is the scientific term for the approach that combines data and operation shipping in a distributed system?
Signup and view all the answers
Which scientific term describes the operation that involves transfer of fragmented data to high-speed processors, where the operation runs, and then sending back the results to the client site?
Which scientific term describes the operation that involves transfer of fragmented data to high-speed processors, where the operation runs, and then sending back the results to the client site?
Signup and view all the answers
What is the scientific term for the process of merging common leaves and sub-trees in a distributed query tree?
What is the scientific term for the process of merging common leaves and sub-trees in a distributed query tree?
Signup and view all the answers
Which scientific term describes an operation used to qualify tuples that are to be joined, reducing the amount of data transfer and communication cost?
Which scientific term describes an operation used to qualify tuples that are to be joined, reducing the amount of data transfer and communication cost?
Signup and view all the answers
What is the scientific term for an approach that involves reduction of solution space in distributed database systems by performing selection and projection operations as early as possible?
What is the scientific term for an approach that involves reduction of solution space in distributed database systems by performing selection and projection operations as early as possible?
Signup and view all the answers
