1,640 Hits in 3.3 sec

Characteristics of production database workloads and the TPC benchmarks

W. W. Hsu, A. J. Smith, H. C. Young
2001 IBM Systems Journal  
In this paper, we examine the characteristics of the production database workloads of ten of the world's largest corporations, and we also compare them to TPC-C and TPC-D.  ...  In general, the two TPC benchmarks complement one another in reflecting the characteristics of the production workloads, but some aspects of real workloads are still not represented by either of the benchmarks  ...  In particular, the authors would like to thank Jyh-Herng Chow, Alex Hazlitt, Eric Louie, Amit Somani, and Surrendra Verma for their guidance in designing the trace facility and in setting up the TPC benchmarks  ... 
doi:10.1147/sj.403.0781 fatcat:g5mlj6f7pncnxahhc7d5blsmee

I/O reference behavior of production database workloads and the TPC benchmarks---an analysis at the logical level

Windsor W. Hsu, Alan Jay Smith, Honesty C. Young
2001 ACM Transactions on Database Systems  
While the two TPC benchmarks generally complement one another in reflecting the characteristics of the production workloads, there remain aspects of the real workloads that are not represented by either  ...  We discover that for the most part, the reference behavior of TPC-C and TPC-D fall within the range of behavior exhibited by the production workloads.  ...  In particular, the authors thank Jyh-Herng Chow, Alex Hazlitt, Eric Louie, Amit Somani, and Surrendra Verma for their guidance in designing the trace facility and in setting up the TPC benchmarks.  ... 
doi:10.1145/383734.383737 fatcat:75kyjaq37fhythj37zag7b4zkm

New TPC benchmarks for decision support and web commerce

Meikel Poess, Chris Floyd
2000 SIGMOD record  
Figure 2: TPC-H and TPC-R database schema Workload The workloads in both benchmarks, TPC-H and TPC-R, consist of a database load, the execution of 22 read-only queries in both single and multi-user mode  ...  Implementation Rules In order to implement the two quite different workloads, the reporting workload of TPC-R and the ad-hoc querying workload for TPC-H, the two benchmarks differ in their implementation  ... 
doi:10.1145/369275.369291 fatcat:k3dkqhauz5bateretxklxxhgrq

Data Processing Benchmarks [article]

Jérôme Darmont
2017 arXiv   pre-print
The aim of this article is to present an overview of the major families of state-of-the-art data processing benchmarks, namely transaction processing benchmarks and decision support benchmarks.  ...  We also address the newer trends in cloud benchmarking. Finally, we discuss the issues, tradeoffs and future trends for data processing benchmarks.  ...  Classical TPC benchmarks all share variants of a classical business database (customer-order-product-supplier) and are only parameterized by a scale factor that determines the database size (e.g., from  ... 
arXiv:1701.08634v1 fatcat:22lp2aqhubc7bhya5y52oqsoty

Measuring Database Performance in Online Services: A Trace-Based Approach [chapter]

Swaroop Kavalanekar, Dushyanth Narayanan, Sriram Sankar, Eno Thereska, Kushagra Vaid, Bruce Worthington
2009 Lecture Notes in Computer Science  
We argue that TPC benchmarks do not capture these important characteristics and argue for developing benchmarks that can be parameterized with workload features extracted from live production workload  ...  We show using a range of load metrics that the services differ substantially from each other and from standard TPC benchmarks.  ...  Our analysis shows that real-world workloads have very different characteristics from TPC benchmarks in terms of basic metrics such as IOPS/GB and read/write ratios, as well as in time-varying characteristics  ... 
doi:10.1007/978-3-642-10424-4_10 fatcat:c3dl2l3wtbektob7rldwq7xyey

Characterization of the E-commerce Storage Subsystem Workload

Xi Zhang, Alma Riska, Erik Riedel
2008 2008 Fifth International Conference on Quantitative Evaluation of Systems  
Different from the TPC-W and RUBiS benchmarks, TPC-C generates WRITE-dominated workloads.  ...  This paper characterizes the workload seen at the storage subsystem of an e-commerce system.  ...  Section 4 gives the user-level performance of the benchmarks under different loads and workloads. Section 5 discusses IO workload characteristics under e-commerce applications.  ... 
doi:10.1109/qest.2008.44 dblp:conf/qest/ZhangRR08 fatcat:idrueg7qnzdhlltc6bv5q7g7xy

The mixed workload CH-benCHmark

Richard Cole, Meikel Poess, Kai-Uwe Sattler, Michael Seibold, Eric Simon, Florian Waas, Florian Funke, Leo Giakoumakis, Wey Guy, Alfons Kemper, Stefan Krompass, Harumi Kuno (+2 others)
2011 Proceedings of the Fourth International Workshop on Testing Database Systems - DBTest '11  
= P singleUser * P multiUser DESIGN OF THE CH-benCHmark The CH-benCHmark combines the unmodified TPC-C schema and transactions and an adapted version of the TPC-H queries to form a complex mixed workload  ...  Scaling of the CH-benCHmark Transactions and Queries As illustrated in the overview in Figure 2 , the workload consists of the five TPC-C transactions and 22 queries, adopted and adapted from TPC-H.  ... 
doi:10.1145/1988842.1988850 dblp:conf/sigmod/ColeFGGKKKNNPSSSW11 fatcat:qo7zwd62erb3bo4vwcfhl4a64u

TPC-W: a benchmark for e-commerce

D.A. Menasce
2002 IEEE Internet Computing  
For example, the workload characteristics of an auction site may be much different from that of an online bookstore.  ...  The benchmark has to specify the type of requests submitted to the SUT as well as the intensity of the workload.  ... 
doi:10.1109/mic.2002.1003136 fatcat:wwpl7ssnsvapllcns2xs7l2d2u

Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking

M. B. Ayub, N. Ali
2018 Journal of Internet and Information Systems  
This study provides comparison between in-memory and disk-based performance with impact analysis of concurrent users and parallelism using TPC-C benchmarking.  ...  Database performance throughput is one of the main measurements of the application effectiveness or a system, in terms of speed and delivery.  ...  with different type of workload other than TPC databases are not always faster as compared to diskbased database depending on number of users and workload characteristics.  ... 
doi:10.5897/jiis2018.0106 fatcat:kxde3pvsavgibc33cykxxbbtri

From TPC-C to Big Data Benchmarks: A Functional Workload Model [chapter]

Yanpei Chen, Francois Raab, Randy Katz
2014 Lecture Notes in Computer Science  
In particular, this model describes several components of the targeted workloads: the functional goals that the system must achieve, the representative data access patterns, the scheduling and load variations  ...  Big data systems help organizations store, manipulate, and derive value from vast amounts of data. Relational database and MapReduce are two, arguably competing implementations of such systems.  ...  The TPC selected the DEC benchmark and assigned its author, F. Raab, to lead the creation of the new standard. July 1992 saw the approval and release of the new TPC Benchmark C (TPC-C) [30] .  ... 
doi:10.1007/978-3-642-53974-9_4 fatcat:edf2ntdkdnfopckwlvcfg4pyqy

A detailed comparison of two transaction processing workloads

Stets, Gharachorloo, Barroso
2002 2002 IEEE International Workshop on Workload Characterization  
These studies have typically used a workload based on either the TPC-B or the TPC-C benchmark, with many of them opting for the simpler TPC-B benchmark.  ...  Given that the TPC-B and TPC-C workloads exhibit dramatically different characteristics on certain architectural metrics (such as cycles-per-instruction), it becomes important to find out whether the results  ...  The two OLTP workloads used in this study are modeled after TPC-B and TPC-C. 1 TPC-C is the currently approved OLTP benchmark from TPC, and is the most important benchmark used by vendors of server-class  ... 
doi:10.1109/wwc.2002.1226492 fatcat:b23waf7eivdgvaf2uxyhcpgylm

Benchmarking data warehouse systems in the cloud

Rim Moussa
2013 2013 ACS International Conference on Computer Systems and Applications (AICCSA)  
The most common benchmarks for cloud computing are the Terasort benchmark and the YCSB benchmark.  ...  Then, we argue that TPC-H benchmark -the most prominent benchmark for decision support system, mismatches cloud rationale (scalability, elasticity, pay-per-use, fault-tolerance features) and Customer Relationship  ...  They used the database and workload of the TPC-W benchmark, with which they assessed Amazon, Google, and Microsoft's offerings.  ... 
doi:10.1109/aiccsa.2013.6616442 dblp:conf/aiccsa/Moussa13 fatcat:y4mcf7xk3zdjzgd473dufhpeau

From A to E

Pınar Tözün, Ippokratis Pandis, Cansu Kaynak, Djordje Jevdjic, Anastasia Ailamaki
2013 Proceedings of the 16th International Conference on Extending Database Technology - EDBT '13  
benchmarks of TPC: TPC-B and TPC-C.  ...  Even though TPC-E has already been around for six years, it has not gained the popularity of its predecessor TPC-C: all the published results for TPC-E use a single database vendor's product.  ...  Acknowledgments We would like to thank all the members of the DIAS and PARSA laboratories at EPFL, Islam Atta, and Duygu Ceylan for their support and feedback throughout this work.  ... 
doi:10.1145/2452376.2452380 dblp:conf/edbt/TozunPKJA13 fatcat:eozhhscc6jfkfdpaqrnrngpaue

Developing a characterization of business intelligence workloads for sizing new database systems

Ted J. Wasserman, Patrick Martin, David B. Skillicorn, Haider Rizvi
2004 Proceedings of the 7th ACM international workshop on Data warehousing and OLAP - DOLAP '04  
In this paper, we discuss the sizing process for database management systems and describe an analysis for characterizing business intelligence (BI) workloads, using the TPC-H benchmark as our workload  ...  Our approach for sizing a BI application's database tier quantifies a new BI workload in terms of the response time goals and mix of the different query classes obtained from the characterization analysis  ...  TRADEMARKS IBM, DB2, and DB2 Universal Database are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both.  ... 
doi:10.1145/1031763.1031766 dblp:conf/dolap/WassermanMSR04 fatcat:pridgxmtirbnpj67i4tgwbjpju

Characterizing and optimizing TPC-C workloads on large-scale systems using SSD arrays

Jidong Zhai, Feng Zhang, Qingwen Li, Wenguang Chen, Weimin Zheng
2016 Science China Information Sciences  
By analyzing the characteristics of the TPC-C workload, we propose a series of system-level optimization methods to improve the TPC-C performance.  ...  Due to the complexity of the TPC-C workload, it is a challenging task to obtain optimal performance for TPC-C evaluation on a large-scale high-end computer.  ...  [2] analyzed the characteristics of the production database workloads of 10 of the world's largest corporations and also compared them with TPC-C and TPC-D.  ... 
doi:10.1007/s11432-015-5383-x fatcat:xhffo2d2ojaflazxgce5f67yya
« Previous Showing results 1 — 15 out of 1,640 results