Reference no: EM131093768
1. Suppose you need to sort a relation of 40 gigabytes, with 4 kilobyte blocks, using a memory size of 40 megabytes. Suppose the cost of a seek is 5 milliseconds, while the disk transfer rate is 40 megabytes per second.
a. Find the cost of sorting the relation, in seconds, with bb = 1 and with bb = 100.
b. In each case, how many merge passes are required?
c. Suppose a flash storage device is used instead of a disk, and it has a seek time of 1 microsecond, and a transfer rate of 40 megabytes per second. Recompute the cost of sorting the relation, in seconds, with bb = 1 andwith bb = 100, in this setting.
2. Consider the following extended relational-algebra operators. Describe how to implement each operation using sorting, and using hashing.
a. Semijoin (): r s is defined as R(r s), where R is the set of attributes in the schema of r ; that it it selects those tuples ri in r for which there is a tuple s j in s such that ri and s j satisfy predicate.
b. Anti-semijoin (¯ ): r¯ s is defined as r-R(r s); that it it selects those tuples ri in r for which there is no tuple s j in s such that ri and s j satisfy predicate.
What is the consumer surplus in this market
: A monopolist of a new computer software is facing demand: P = 100 -2 Q (where P is the unit price for this software and Q is its quantity) and MC = 20. What is the consumer surplus in this market
|
Explain how spirituality and faith in both works
: Choose two religion-focused works from literature, theatre, music, or art (such as painting and sculpture) How do they call a religion into question?
|
The tri-city office equipment corporation sells
: Refer to Copier maintenance Problem 1.20. The observations are listed in time order. Assume that regression model (12.1) is appropriate. Test whether or not positive autocorrelation is present: use α = .01. State the alternatives, decision rule, ..
|
What ways do you relate to diversity
: Considering your increased understanding of diversity, in what ways, if any, would you want to modify any or all of the three professional goals which you articulated in the Reflection Assignment of Week1?
|
Describe how to implement each operation using sorting
: Consider the following extended relational-algebra operators. Describe how to implement each operation using sorting, and using hashing.
|
Tests concerning the autocorrelation parameter
: For each of the following tests concerning the autocorrelation parameter ρ in regression model (12.2) with three predictor variables. state the appropriate decision rule based on the
|
Calculate the cost of credit
: Purpose: The Using Consumer Credit Worksheet is designed to test a student’s understanding of credit card interest rates and how to use credit calculations for various purchases.
|
What range of output is marginal cost decreasing
: Verify that the two alternative methods of figuring ATC (TC/Q and AVC + AFC) give the same answer. Over what range of output is marginal cost (i) decreasing? (ii) increasing
|
A student writing a term paper used ordinary least squares
: A student writing a term paper used ordinary least squares in fitting a simple linear regression; model to some time series data containing positively auto correlated errors, and found that the· 90 percent confidence interval for ß1 was too wide t..
|