HELP! * BLUE=global GREY=local Global HTML version of Foils prepared July 23,1995
Foil 104 File Striping in Oracle
From Full Relational Database HPDC-4 Presentation HPDC-4 Tutorial/CPS616 Spring95 -- August 1, Pentagon City Virginia. byGang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE
Automatic file striping and disk partitions by the operating system on nCUBE2
General OS and server level, less flexible, but relatively transparent to DBA
data skew is less possible, due to the Gigacache
Manually file striping at database table level on IBM SP2
Application-specific, flexible, but difficult to handle with large number of files and impossible to determine optimal striping length
data skew is highly possible
Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.