Dell PowerEdge R940xa GPU Database Acceleration on - Page 14

Performance comparison of Brytlyt 4.2 4.3 Background on TPC-H Benchmarking [1] TPC-H is a decision support benchmark and for relational databases with business-oriented ad-hoc queries and data modifications. The data and queries are designed to have broad industry-wide relevance to perform comparative analysis on decision support systems. Large volumes of data are examined to give answers to business critical questions using complex queries and high levels of concurrency. The TPC-H performance metric is called the Composite Query-per-Hour (QphH@Size) and reflects the database size and the query processing power of the system while the TPC-H Price/Performance metric is expressed as $/QphH@Size. Importance of TPC-H for Ad-Hoc Business Decision Making Activities TPC-H is often referred to as the ad-hoc Decision Support (DS) benchmark and is an OLAP workload that measures query analytics in a 'data warehouse' context. The Decision Support Systems (DSS) are systems that support business and organizational decision-making activities like:  Business and operational performance indicators and statistics  Comparison of Sales Figures by time, location and product  Predicating revenue figures based on sales assumptions  Evaluating the consequences of different decision alternatives Decision Support (DS) queries tend to be far more complex, deal with larger volume of data and are therefore far more demanding and long running than transactional workloads like Online Transaction Processing (OLTP). Because Decision Support (DS) are so complex, it can be extremely challenging for a database designer to plan accordingly and optimize performance and therefore this kind of query may end up running for hours and even days. 14 GPU Database Acceleration on PowerEdge R940xa