Benchmarks Suites (Cont.) TPC benchmarks (cont.) TPC-D:complex decision support application Superceded by TPC-H and TPC-R TPC-H:(H for ad hoc)based on TPC-D with some extra queries Models ad hoc queries which are not known beforehand Total of 22 queries with emphasis on aggregation prohibits materialized views permits indices only on primary and foreign keys TPC-R:(R for reporting)same as TPC-H,but without any restrictions on materialized views and indices TPC-W:(W for Web)End-to-end Web service benchmark modeling a Web bookstore,with combination of static and dynamically generated pages Database System Concepts-7th Edition 25.16 ©Silberscha乜，Korth and SudarshanDatabase System Concepts - 7 25.16 ©Silberschatz, Korth and Sudarshan th Edition Benchmarks Suites (Cont.) ▪ TPC benchmarks (cont.) • TPC-D: complex decision support application ▪ Superceded by TPC-H and TPC-R • TPC-H:(H for ad hoc) based on TPC-D with some extra queries ▪ Models ad hoc queries which are not known beforehand • Total of 22 queries with emphasis on aggregation ▪ prohibits materialized views ▪ permits indices only on primary and foreign keys • TPC-R:(R for reporting) same as TPC-H, but without any restrictions on materialized views and indices • TPC-W: (W for Web) End-to-end Web service benchmark modeling a Web bookstore, with combination of static and dynamically generated pages