Demo Specifics

• TPC-D database

  • scale factors of 0.1 (100MB), 0.3 (300MB)

• Statistics

  • user selects either 2%, 5%, 10%, or 20% statistics
  • 95% confidence in the results
  • Compare base samples vs. join synopses
  • Compare standard samples vs. congressional samples on group-by queries

• Queries

  • non-nested queries derived from the TPC-D benchmark
  • mostly aggregate queries

Previous slide

Next slide

Back to first slide

View graphic version