Reference no: EM131210908
Briefly answer the following questions:
1. Consider the three basic techniques, iteration, indexing, and partitioning, and the relational algebra operators selection, projection, and join. For each technique-operator pair, describe an algorithm based on the technique for evaluating the operator.
2. Define the term most selective access path for a query.
3. Describe conjunctive normal form, and explain why it is important in the context of relational query evaluation.
4. When does a general selection condition match an index? What is a primary term in a selection condition with respect to a given index?
5. How does hybrid hash join improve upon the basic hash join algorithm?
6. Discuss the pros and cons of hash join, sort-merge join, and block nested loops join.
7. If the join condition is not equality, can you use sort-merge join? Can you use hash join? Can you use index nested loops join? Can you use block nested loops join?
8. Describe how to evaluate a grouping query with aggregation operator MAX using a sortingbased approach.
9. Suppose that you are building a DBMS and want to add a new aggregate operator called SECOND LARGEST, which is a variation of the MAX operator. Describe how you would implement it.
10. Give an example of how buffer replacement policies can affect the performance of a join algorithm.
Estimate the number of days
: If daily water demand is approximately normally distributed with a mean of 5 ml and a standard deviation of 1.25ml: Estimate the number of days in a (365 day) year on which daily consumption is:
|
Approximately normal with equal variances
: Construct a 95 % confidence interval for μ1-μ2 with the sample statistics for mean calorie content of twobakeries' specialty pies and confidence interval construction formula below. Assume the populations are approximately normal with equal varia..
|
Create a thread job that runs the job routine
: Create a thread job that runs the job() routine, and three threads CPU-1, CPU-2, and CPU-3 each runs the cpu() routine. Each CPU thread blocks when the ready queue is empty, and job thread blocks when the queue is full
|
What is the purpose served by foundations
: What is the purpose served by foundations? What is a column? What kinds of forces are a column subjected? What is a beam? What building elements typically support beams?
|
Define the term most selective access path for a query
: Suppose that you are building a DBMS and want to add a new aggregate operator called SECOND LARGEST, which is a variation of the MAX operator. Describe how you would implement it.
|
Sampling distribution of the sample
: Suppose the population proportion is 0.60. If the sample size is equal to 20, what is the sampling distribution of the sample proportion, 'p-hat'?
|
Compute the mean and standard deviation
: Compute the mean and standard deviation of the hourly wages.
|
What happens to the volume of trade
: Show that country can gain from trade even if country does not change its production point.- What happens to the volume of trade as the country's position shifts from that shown in part a to that shown in part b ?
|
What is the worstcase cost for an equality search
: If the hash function distributes data entries over the space of bucket numbers in a very skewed (non-uniform) way, what can you say about the space utilization in data pages?
|