HELP! * GREY=local LOCAL HTML version of Foils prepared July 6,1995

Foil 51 TPC-D - a Decision Support Benchmark?
Relevance to Real Applications

From Explicit Examples in Parallel Relational Databases CPS600 Spring Semester -- April 1995. by Gang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE

For DS applications, query stream execution time is largely irrelevant. It is far more important to understand performance and scalability of elementary SQL operations and of typical queries encountered in customer application.
Loading and indexing may take a large portion of the overall time in preparing a large DB. Both parallel loading and indexing become important functionality of a parallel RDBMS. Their performance for large DSS databases should be defined and benchmarked, together with the query benchmarks. Currently none of them is defined or mentioned in the TPC-D specification.



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