The Book house, SBH has decided to purchase RAID arrays to store the database sh

ID: 3606029 • Letter: T

Question

The Book house, SBH has decided to purchase RAID arrays to store the database shown in Figure 1. Which levels of RAID would you advise them to use and why?

Branch Publisher Em ployee EmployeeID CHAR(8) BranchID INT Branch Name VARCHAR(45) Branch Address VARCHAR … ONumberOfEmployees INT PublisherID CHAR(3) PublisherName VARCHAR(45) PublisherCity VARCHAR (30) Publish&Contactio; AR(10) EmployeeName VARCHAR(45) EmployeeType VARCHAR(20) Supervisor-EmployeeID CH Indexes Indexes Inventory DutyRoster EmployeeID CHAR(8) BranchID INT t Branch_BranchID INT Book_BookID INT AvailableQuantity INT Indexes t WorkingShiftID INT Book BookID INT WorkingShift WorkingShiftID INT workingShiftWeekDay VARCHAR (15) workingShiftStartTime TIME(6) WorkingShiftEndTim e TIME(6) dutyType VARAR(20) Indexes BookTitle VARCHAR(45) BookType VARCHAR (45) Book Price DECIMAL (8,2) 1sPaperback VARCHAR(3) Writes Author_AuthorID INT Book_BookID INT Author AuthorID INT AuthorName VARCHAR(45) AuthorE mail Address V ARCHAR (45) Indexes sequenceNumber INT Publisher, Publisher!D CHAR(3) Indexes Figure 1 : Relational Data Model

Explanation / Answer

Dear frnd,

I have tried to find your solution

Solution

For your database structure I will prefer to purchase RAID level 10 is best suited for this problem

For our easiness I tried prepare a table including pros and cons of every RAID level.

RAID Level

Pros

Cons

Is suitable for this problem

0 or disk striping

improves read and write performance of data

Lacking of fault tolerance feature

1 or disk mirroring

1)-provides fault tolerance

2)- improves read performance

degrade write performance(due to mirroring of data)

Provide parity check

Little Improvement than Level-1

Provide parity check for only one disk

Little Improvement than Level-2

Generally not used

5 or striping with parity

1)-Most popular RAID level

2)- gives users full redundancy of all the data

3)- useful if a single disk happens to fail

4)- disk can be easily replaced without downgrading performance

5)- provide users with higher reliability and faster recovery

read performance is decreased(when a stripe member is missing)

10 or mirroring with striping

Best performance of all the levels

Expensive

Yes

dear frnd please don't hasitate to ask me if you have any doubt regarding this solution

Thanks