ABSTRACT
Current database benchmarks are either focusing on online transaction processing (OLTP) or on online analytical pro- cessing (OLAP) systems. This traditional separation has to be reevaluated to reflect current trends in the design of database systems. We see a need for a realistic benchmark workload taking both aspects into account. Therefore, we defined a mixed workload and illustrate ways to apply our workload to evaluate the influence of database design on system performance.
- S. A. Becker. Developing Quality Complex Database Systems: Practices, Techniques, and Technologies. Idea Group, Inc., 2001. Google ScholarDigital Library
- A. Bog, H. Plattner, and A. Zeier. A mixed transaction processing and operational reporting benchmark. Information Systems Frontiers Journal, Springer, 2010. Google ScholarDigital Library
- C. French. "One Size Fits All" Database Architectures Do Not Work for DSS. In SIGMOD, 1995. Google ScholarDigital Library
- J. Gray, editor. The Benchmark Handbook for Database and Transaction Systems. Morgan Kaufmann, 1993. Google ScholarDigital Library
- A. Hinze, K. Sachs, and A. Buchmann. Event-Based Applications and Enabling Technologies. In DEBS, 2009. Google ScholarDigital Library
- S. S. Lightstone, T. J. Teorey, and T. Nadeau. Physical Database Design. Morgan Kaufmann Publishers, 2007.Google Scholar
- D. A. Menasce. TPC-W: A Benchmark for E-Commerce. IEEE Internet Computing, 6, 2002. Google ScholarDigital Library
- H. Plattner. A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database. In Proc. of the 35th SIGMOD, 2009. Google ScholarDigital Library
- J. Rossberg and R. Redler. Pro Scalable .NET 2.0 Application Designs. Apress, 2005. Google ScholarDigital Library
Index Terms
- Benchmarking database design for mixed OLTP and OLAP workloads
Recommendations
Benchmarking OLTP/web databases in the cloud: the OLTP-bench framework
CloudDB '12: Proceedings of the fourth international workshop on Cloud data managementBenchmarking is a key activity in building and tuning data management systems, but the lack of reference workloads and a common platform makes it a time consuming and painful task. The need for such a tool is heightened with the advent of cloud ...
Benchmarking data warehouses
Database benchmarks can either help users in comparing the performances of different systems, or help engineers in testing the effect of various design choices. In the field of data warehouses, the Transaction Processing Performance Council's standard ...
Normalization in a mixed OLTP and OLAP workload scenario
TPCTC'11: Proceedings of the Third TPC Technology conference on Topics in Performance Evaluation, Measurement and CharacterizationThe historically introduced separation of online analytical processing (OLAP) from online transaction processing (OLTP) is in question considering the current developments of databases. Column-oriented databases mainly used in the OLAP environment so ...
Comments