the database must store an employee table consisting of 500 000records each of which 4946137

February 11, 2021/in Business Homework Help Online /by Joseph

The database must store an employee table consisting of 500,000records each of which is 400 bytes long. A SSD has storage capacityof 1 TB, read bandwidth of 1 GB/sec., and a block size of 4096bytes. Answer these questions:
a) What is the total capacity of RAID 0 with 6drives?
(0.5 marks)
b) What is the total capacity of RAID 5 with 10drives?
(0.5 marks)
c) How many records can be stored per block(
blocking factor) using spanned and unspannedconfigurations?
(2 marks)
d) What is the utilization for the unspannedconfiguration?
(1 mark)
e) Assume the data is stored sequentially. Howlong does it take to read all records in the
unspannedconfiguration?
(1 mark)
f) Assume the file is physically ordered on key
K, what is the average time to retrieve a record using key
K in the
spanned configuration?
(2marks)
g) The database designer wants to add a largedescription field of 1,000 bytes to each employee record. However,this field will only have data in it 20% of the time and is onlyaccessed in 25% of the queries. The goal is to find the best recordlayout.
(3 marks) For this question calculate: The average time to read the whole table when using spanned,fixed records and no splitting. The average time to read the whole table when using spanned,variable records. The average time to read the whole table when using spannedrecords and splitting. Assume a variable length record requires 20 bytes of overhead tostore record information in addition to record data and a splitrecord also requires 20 bytes of overhead. Also, the only layoutwhose performance will change depending on the queries is the splitconfiguration as in that case the new field will be only accessed25% of the time. For the other two configurations, the entirerecord is read for all queries. . . .

Here are the five steps that we follow for you to receive the promised high-quality paper.

1. Place your order
You begin by filling our simple order form followed by the payment procedure. Once you are done, our supervisors assign your paper to the most suitable writer in your field of study. For urgent delivery of between 3 to 48 hours, the paper is automatically passed to the available writer fitting your area of specialization to avoid late delivery of your paper.

Always remember to provide us with all the necessary information required for your paper in the order form. You can also upload any file that you deem to be important during the writing process. You can also communicate with your writer directly through our messaging system.

2. Research Process

Our writers ensure that they do thorough research before starting working on your paper. They locate the best and recently updated sources for your topic to avoid personal opinions and assumptions unless the instructions indicate otherwise.

We advise that you leave a large timeframe before the time you place your order and delivery given that research can take quite a while sometimes. The more time for your paper the better the results. The same goes to the details of the order the more and clear your instructions are the more accurate the final product becomes.

3. The writing processes

Once the research is done, our excellent writers begin working on your paper. During this process, you are allowed to communicate with either our support representatives or your writer in regards to the paper’s progress. However, your writer may not be online at the specific moment you want to talk to them so it is wise to give them some time to answer. If the writer takes too long to respond to our customer care representative will take initiative to contact the writer on your behalf. We also recommend that you keep checking your account regularly in an event there is clarification needed for your paper.

4. Editing process.

Once the writer is done with the assignment, it is sent to the editing department where it is proofread by a specialist. Editors ensure that your paper is error-free, followed the instructions and has a flow of ideas. They also ensure that your paper has passed through anti-plagiarism software for authenticity. Thus, with u you are ensured that your paper is not a duplicate and does not have copied parts.

5. log in to your account to download your completed paper.

After the editors are done with your paper, it is marked as completed where you receive an email notification. You download your paper and read through to see if your requirements were fulfilled. In an event your paper did not meet your expectations, you are entitled to a free revision. However, the revision request should be placed within 48 hours after order delivery.