TPC Performance Measures Two types of tests for TPC-H and TPC-R Power test:runs queries and updates sequentially,then takes mean to find queries per hour Throughput test:runs queries and updates concurrently multiple streams running in parallel each generates queries,with one parallel update stream Composite query per hour metric:square root of product of power and throughput metrics Composite price/performance metric Database System Concepts-7th Edition 25.18 ©Silberscha乜，Korth and SudarshanDatabase System Concepts - 7 25.18 ©Silberschatz, Korth and Sudarshan th Edition TPC Performance Measures ▪ Two types of tests for TPC-H and TPC-R • Power test: runs queries and updates sequentially, then takes mean to find queries per hour • Throughput test: runs queries and updates concurrently ▪ multiple streams running in parallel each generates queries, with one parallel update stream • Composite query per hour metric: square root of product of power and throughput metrics • Composite price/performance metric