Get 20M+ Full-Text Papers For Less Than $1.50/day. Start a 14-Day Trial for You or Your Team.

Learn More →

DeepDyve requires Javascript to function. Please enable Javascript on your browser to continue.

Benchmarking Transaction and Analytical Processing Systems

Part of the In-Memory Data Management Research Book Series

DOI: 10.1007/978-3-642-38070-9

ISBN: 978-3-642-38069-3

Publisher: Springer Berlin Heidelberg - Springer Journals

May 24, 2013

Available

Introduction

Bog, Anja

Pages: 1 –12

[A wider usage of computers in the business setting started in the 1960s [185, Chap. 1]. The first task companies used computers for was the automation of simple routine tasks like payroll amount calculation. More business areas such as financial accounting, order entry, and billing soon...
Available

Enterprise Data Management for Transaction and Analytical Processing

Bog, Anja

Pages: 15 –43

[Enterprise data management has to support all business processes of a company from storing and providing data during daily operations, for example, sales, purchasing, and payroll accounting, to analyzing data for strategic decision making. Daily operations are supported by transaction processing...
Available

Benchmarks for Transaction and Analytical Processing Systems

Bog, Anja

Pages: 45 –62

[As presented in Chap. 1, the goal of this thesis is to analyze and compare the behavior of databases in mixed workload scenarios as a basis to evaluate logical database design decisions. Benchmarks provide a method for this. A benchmark is “a standardized problem or test that serves as a basis...
Available

Combined Transaction Processing and Reporting Benchmark

Bog, Anja

Pages: 65 –91

[Only limited statements can be made concerning the ability of existing data management systems to handle a mixed OLTP and OLAP workload since they have so far been treated as separate domains and separate benchmarks were created. Existing benchmarks could be applied to a combined architecture...
Available

Database Schema Variants for Mixed OLTP and OLAP

Bog, Anja

Pages: 93 –107

[As discussed in Sect. 2.2, a database design optimized for OLAP degrades the performance of OLTP queries and vice versa. If OLTP and OLAP workloads are to be consolidated onto one system, the question of how to design the database arises. Optimizations of the dedicated OLTP and OLAP systems that...
Available

The CBTR Tool Chain

Bog, Anja

Pages: 111 –119

[The tool chain to assess database systems according to mixed workloads is composed of three parts. Figure 6.1 provides an overview of these parts. The first comprises database specific scripts to create the database schema (tables and indexes) and to load the benchmark base data into the...
Available

Evaluation of Mixing the Workload and Variation of the Database Schema

Bog, Anja

Pages: 121 –131

[Three fundamental techniques for performance analysis are listed by Lilja [129], Chap. 1. These are simulation, analytical modeling, and measurements of existing systems. While the last provides the most precise results, it is the most difficult and time-consuming of the three techniques in...
Available

Conclusion

Bog, Anja

Pages: 133 –138

[Benchmarks are the standard method to evaluate, compare, and support the development of database systems. With the unification of transaction and analytical processing systems and the development of new database systems, benchmarking has to evolve as well. On the one hand, existing benchmarks...

results per page

Prev
1
Next

Browse All eBooks