Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
System R: relational approach to database management
ACM Transactions on Database Systems (TODS)
Data mining: concepts and techniques
Data mining: concepts and techniques
A relational model of data for large shared data banks
Communications of the ACM
TPC-DS, taking decision support benchmarking to the next level
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Building the Operational Data Store
Building the Operational Data Store
Teaching an OLTP Database Kernel Advanced Data Warehousing Techniques
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Analysis of the Characteristics of Production Database Workloads and
Analysis of the Characteristics of Production Database Workloads and
Logical Data Modeling: What It Is And How To Do It (Integrated Series in Information Systems)
Logical Data Modeling: What It Is And How To Do It (Integrated Series in Information Systems)
C-store: a column-oriented DBMS
VLDB '05 Proceedings of the 31st international conference on Very large data bases
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
A dependability benchmark for OLTP application environments
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Why you should run TPC-DS: a workload analysis
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Incrementally parallelizing database transactions with thread-level speculation
ACM Transactions on Computer Systems (TOCS)
Middleware-based database replication: the gaps between theory and practice
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Managing operational business intelligence workloads
ACM SIGOPS Operating Systems Review
Benchmarking database design for mixed OLTP and OLAP workloads
Proceedings of the 2nd ACM/SPEC International Conference on Performance engineering
Global IT and IT-enabled services
Information Systems Frontiers
Interactive performance monitoring of a composite OLTP and OLAP workload
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
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 Characterization
Hi-index | 0.00 |
The importance of reporting is ever increasing in today's fast-paced market environments and the availability of up-to-date information for reporting has become indispensable. Current reporting systems are separated from the online transaction processing systems (OLTP) with periodic updates pushed in. A pre-defined and aggregated subset of the OLTP data, however, does not provide the flexibility, detail, and timeliness needed for today's operational reporting. As technology advances, this separation has to be re-evaluated and means to study and evaluate new trends in data storage management have to be provided. This article proposes a benchmark for combined OLTP and operational reporting, providing means to evaluate the performance of enterprise data management systems for mixed workloads of OLTP and operational reporting queries. Such systems offer up-to-date information and the flexibility of the entire data set for reporting. We describe how the benchmark provokes the conflicts that are the reason for separating the two workloads on different systems. In this article, we introduce the concepts, logical data schema, transactions and queries of the benchmark, which are entirely based on the original data sets and real workloads of existing, globally operating enterprises.