Database management and partitioning to improve database processing performance

Abstract

The technologies of searching methods are very important in database management systems, in that they must be a simple and practical way of managing problems in database systems. These methods must allow databases to be more easily deployed with optimal performance. The vertical and horizontal database partitioning are used to improve database performance. The horizontal method is more efficient than the vertical method in a large database, and it will be more efficient if distributed in more than one computer. Redundant Arrays of Inexpensive Disks (RAID) is one of the important technologies used in processing database. The proposed method was implemented to get optimal utilization of RAID level 1, by partitioning vertically the original database before storing them on RAID level 1, in order to get faster database retrieving while at the same time keeping the mirror technique of the RAID level 1 without any changes. © 2010 Macmillan Publishers Ltd.