HELP! * BLUE=global GREY=local Global HTML version of Foils prepared July 23,1995

Foil 110 TPC-D - a Decision Support Benchmark?
Nature of Benchmark Examples

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
TPC-D definition requires that either one (power test) or many (scale-up test) query streams are run and timed against at least three sizes of a predefined database, with sizes growing exponentially (e.g., 1G, 10GB, 100GB sequence)
Query stream consists of 17 complex queries plus two concurrently running update operations
No extensive database tuning in allowed - optimizer hints are explicitly forbidden
timings for individual queries are not part of the TPC-D metric
Database structure well represents most common DSS DBs in applications, i.e. one largest table takes ~70% of the total DB size.
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