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. by Gang 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.

Page produced by wwwfoil on Tue Feb 18 1997