“One size fits all” database architectures do not work for DSS
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
A simple guide to five normal forms in relational database theory
Communications of the ACM
Database Administration: Practices and Procedures
Database Administration: Practices and Procedures
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Teaching an OLTP Database Kernel Advanced Data Warehousing Techniques
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Proceedings of the International Symposium on Database Systems of the 90s
Denormalization guidelines for base and transaction tables
ACM SIGCSE Bulletin
Reconsidering Multi-Dimensional schemas
ACM SIGMOD Record
AutoPart: Automating Schema Design for Large Scientific Databases Using Data Partitioning
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
Database in Depth: Relational Theory for Practitioners
Database in Depth: Relational Theory for Practitioners
DB2 design advisor: integrated automatic physical database design
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A common database approach for OLTP and OLAP using an in-memory column database
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Normalized data base structure: a brief tutorial
SIGFIDET '71 Proceedings of the 1971 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control
A case for online mixed workload processing
Proceedings of the Third International Workshop on Testing Database Systems
HYRISE: a main memory hybrid storage engine
Proceedings of the VLDB Endowment
Transaction performance vs. Moore's law: a trend analysis
TPCTC'10 Proceedings of the Second TPC technology conference on Performance evaluation, measurement and characterization of complex systems
Benchmarking database design for mixed OLTP and OLAP workloads
Proceedings of the 2nd ACM/SPEC International Conference on Performance engineering
A mixed transaction processing and operational reporting benchmark
Information Systems Frontiers
HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots
ICDE '11 Proceedings of the 2011 IEEE 27th International Conference on Data Engineering
Interactive performance monitoring of a composite OLTP and OLAP workload
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
Hi-index | 0.00 |
The 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 far, with the addition of in-memory data storage are adapted to accommodate OLTP as well, thus paving the way for mixed OLTP and OLAP processing. To assess mixed workload systems benchmarking has to evolve along with the database technology. Especially in mixed workload scenarios the question arises of how to layout the database. In this paper, we present a case study on the impact of database design focusing on normalization with respect to various workload mixes and database implementations. We use a novel benchmark methodology that provides mixed OLTP and OLAP workloads based on a real scenario.