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

Foil 48 TPC-D - a Decision Support Benchmark? Nature of Queries

From Explicit Examples in Parallel Relational Databases CPS600 Spring Semester -- April 1995. by Gang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE
model complex queries against a relatively large and complex database
All currently parallelizable relational operators (Oracle 7 Server) are used, including:
  • Aggregate (Group by) - Q2, Q6, Q11, Q14, Q15
  • Merge Join - Q8
  • Nested Loops - All except Q1
  • Sort (Group by) - All except Q2
  • Sort (Join) - Q8, Q12
  • Sort (Order by) - Q3, Q5, Q10, Q11, Q16
  • Sort (Unique) - Q4
  • Table Access (Full) - All

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