What is RAID and how it improves the performance of file access?
RAID usage for improving disk I/O and deployment of parallel processing.
Denormalization and clustering work well to minimize the use of time data if the information is used in combination with the program may be placed on a single page of media. A small book, this is certainly possible. However, the data used in combination with, or immediately in a row can be stored on separate pages, in this case, multiple transactions, sequential disk input/output necessary for reading and writing this information. So, denormalization and clustering may not be sufficient to improve significantly the patterns of data read and write.
Two of the inevitable development of information technology is a continuous decline in the cost and size of information technology. These two trends make redundancy of computer components both economically and physically feasible. The ability to use multiple, small computer components also allows for parallel processing of data. One result of the parallel processing of data, for example, four input/output, when carried out in parallel, to last as long as only one of these measures.
The treatment of a parallel database can be done by a designer of the base with the help of hardware and software technology called redundant arrays of inexpensive disks (RAID short). RAID uses a set or array of physical disk drives that appear in the user base and programs as if they form a large logical storage unit. Thus, the RAID does not change the physical or logical structure of application programs or database queries.
To maximize I / S RAID, all units must be occupied. Striping performs load balancing of work on hard drives. The data segments, called bands, cover all disk drives, as shown. Pages logically sequential data is stored in the round-robin on the physical disks. Therefore, hypothetical RAID storage would be possible to read data pages in a logical sequence in parallel.
Most operating systems today multi-user, such as Microsoft, Unix, Linux support some form of RAID. Operating systems, parallel read operations, and begin to concatenate the results into a logical record for the program in demand. These operating systems also enable multithreading, in which parallel input/output operations of the user programs or tasks can be carried out. RAID can also be implemented in hardware using special adapters and the host computer downloads the work to break down the operations of the stages of input and output in parallel.
In short, we can say that RAID is very useful to the deployment of parallel processing of disk I/O and distribute the disk I/O across all available disks. Parallel processing and distributing disk I/O on multiple disks are improving disk throughout and performance enhancement.
Kendba is a sister concern of Dbametrix. Kendra recently launched an exclusive Online Oracle 11g Performance Tuning Course with awesome features like it covers Oracle 11g Tuning, Oracle 10g Tuning, and Oracle 9i Tuning. It also covers live environment scenario-based examples. Single online tuning courses also contain Data Warehousing and OLTP tuning differences.
Dbametrix is a team of experts and offers database administration services with high-quality Oracle support.
Thanks and regards,