HELP! * BLUE=global GREY=local Global HTML version of Foils prepared July 23,1995
Foil 111 TPC-D - a Decision Support Benchmark? Nature of Queries
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
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.