Performance evaluation and benchmarking : First TPC Technology Conference, TPCTC 2009, Lyon, France, August 24-28, 2009 : revised selected papers

This book constitutes the reviewed proceedings of the first Conference on Performance Evaluation and Benchmarking, TPCTC 2009, held in Lyon, France, August 24-28,2009. The 16 full papers and two keynote papers were carefully selected from 34 submissions. This book considers issues such as appliance, business intelligence, cloud computing, complex event processing, database performance optimizations, green computing, data compression, disaster tolerance and recovery, energy and space efficiency, hardware innovations, high speed data generation, hybrid workloads or operational data warehousing, unstructured data management, software management and maintenance, virtualization and very large memory systems Front Matter....Pages - Transaction Processing Performance Council (TPC): Twenty Years Later – A Look Back, a Look Ahead....Pages 1-10 A New Direction for TPC?....Pages 11-17 The Art of Building a Good Benchmark....Pages 18-30 Database Are Not Toasters: A Framework for Comparing Data Warehouse Appliances....Pages 31-51 The State of Energy and Performance Benchmarking for Enterprise Servers....Pages 52-66 From Performance to Dependability Benchmarking: A Mandatory Path....Pages 67-83 Overview of TPC Benchmark E: The Next Generation of OLTP Benchmarks....Pages 84-98 Converting TPC-H Query Templates to Use DSQGEN for Easy Extensibility....Pages 99-115 Generating Shifting Workloads to Benchmark Adaptability in Relational Database Systems....Pages 116-131 Measuring Database Performance in Online Services: A Trace-Based Approach....Pages 132-145 Issues in Benchmark Metric Selection....Pages 146-152 Benchmarking Query Execution Robustness....Pages 153-166 Benchmarking Database Performance in a Virtual Environment....Pages 167-182 Principles for an ETL Benchmark....Pages 183-198 Benchmarking ETL Workflows....Pages 199-220 A Performance Study of Event Processing Systems....Pages 221-236 The Star Schema Benchmark and Augmented Fact Table Indexing....Pages 237-252 An Approach of Performance Evaluation in Authentic Database Applications....Pages 253-266 Back Matter....Pages - First established in August 1988, the Transaction Processing Performance Council (TPC) has shaped the landscape of modern transaction processing and database benchmarks over two decades. Now, the world is in the midst of an extraordinary information explosion led by rapid growth in the use of the Internet and connected devices. Both user-generated data and enterprise data levels continue to grow ex- nentially. With substantial technological breakthroughs, Moore's law will continue for at least a decade, and the data storage capacities and data transfer speeds will continue to increase exponentially. These have challenged industry experts and researchers to develop innovative techniques to evaluate and benchmark both hardware and software technologies. As a result, the TPC held its First Conference on Performance Evaluation and Benchmarking (TPCTC 2009) on August 24 in Lyon, France in conjunction with the 35th International Conference on Very Large Data Bases (VLDB 2009). TPCTC 2009 provided industry experts and researchers with a forum to present and debate novel ideas and methodologies in performance evaluation, measurement and characteri- tion for 2010 and beyond. This book contains the proceedings of this conference, including 16 papers and keynote papers from Michael Stonebraker and Karl Huppler.