Reference no: EM13509504
1.What main conclusions can you draw from the discussion of the ?ve basic ?le organizations discussed in Section 8.4? Which of the ?ve organizations would you choose for a ?le where the most frequent operations are as follows?
1. Search for records based on a range of field values.
2. Perform inserts and scans, where the order of records does not matter.
3. Search for a record based on a particular ?eld value.
2.Consider the following relations:
Emp(eid: integer, ename: varchar, sal: integer, age: integer, did: integer) Dept(did: integer, budget: integer, ?oor: integer, mgr eid: integer)
Salaries range from $10,000 to $100,000, ages vary from 20 to 80, each department has about ?ve employees on average, there are 10 ?oors, and budgets vary from $10,000 to $1 million. You can assume uniform distributions of values.
For each of the following queries, which of the listed index choices would you choose to speed up the query? If your database system does not consider index-only plans (i.e., data records are always retrieved even if enough information is available in the index entry), how would your answer change? Explain brie?y.
1. Query: Print ename, age, and sal for all employees.
(a) Clustered hash index on ename,age,sal_ ?elds of Emp.
(b) Unclustered hash index on ename,age,sal_ ?elds of Emp. (c) Clustered B+ tree index on ename,age,sal_ ?elds of Emp.
(d) Unclustered hash index on eid,did_ ?elds of Emp.
(e) No index.
2. Query: Find the dids of departments that are on the 10th ?oor and have a budget of less than $15,000.
(a) Clustered hash index on the floor ?eld of Dept.
(b) Unclustered hash index on the floor ?eld of Dept.
(c) Clustered B+ tree index on floor,budget_ ?elds of Dept.
(d) Clustered B+ tree index on the budget ?eld of Dept.
(e) No index.
|
How to change a tire-the federal budge
: Write the name of the organizational pattern best suited to a speech on each of the following topics. In addition to listing the organizational pattern, give three main points that might be used to develop the topic.
|
|
What is the time required to read a ?le containing 100000
: What is the time required to read a ?le containing 100,000 records of 100 bytes each in a random order? To read a record, the block containing the record has to be fetched from disk. Assume that each block request incurs the average seek time and rot..
|
|
How many cylinders does the disk have
: Consider a disk with a sector size of 512 bytes, 2000 tracks per surface, 50 sectors per track, ?ve double-sided platters, and average seek time of 10 msec.
|
|
Give an example of an update that is definitely slowed
: The title of the ?rst record in the previous set, and the primary key of the ?rst record in the previous set.
|
|
Search for a record based on a particular field value
: For each of the following queries, which of the listed index choices would you choose to speed up the query? If your database system does not consider index-only plans (i.e., data records are always retrieved even if enough information is available i..
|
|
Prepare a new contribution format segmented income statement
: Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional information provided.
|
|
Obtain the magnitude of the force
: Two blocks, each with weightw, are held in place on a frictionless incline in terms ofwand the angleaof the incline. Calculate the magnitude of the force that the incline exerts on each block in N
|
|
Vivians medical expenses paid by the johnsons
: Can you report on Schedule A Vivian's medical expenses paid by the Johnsons - Are expenses to prepare you for a new trade or business deductible?
|
|
Clustered versus unclustered indexes
: Choice of search key for the index. What is a composite search key, and what considerations are made in choosing composite search keys? What are index-only plans, and what is the in?uence of potential index-only evaluation plans on the choice of sear..
|