Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abolhassani, M.: Business Objects and Enterprise Applications. In: Managing Information Technology in a Global Environment, IRMA 2001, pp. 240–242. Idea Group Publishing, Hershey (2001)
Bock, D.B., Schrage, J.F.: Denormalization Guidelines for Base and Transaction Tables. ACM SIGCSE Bulletin 34(4), 129–133 (2002)
Bog, A., Plattner, H., Zeier, A.: A mixed transaction processing and operational reporting benchmark. Information Systems Frontiers 13, 321–335 (2010), http://dx.doi.org/10.1007/s10796-010-9283-8
Bog, A., Sachs, K., Zeier, A.: Benchmarking database design for mixed oltp and olap workloads. In: Proceeding of the Second Joint WOSP/SIPEW International Conference on Performance Engineering, ICPE 2011, pp. 417–418. ACM, New York (2011)
Chaudhuri, S., Narasayya, V.R.: An efficient cost-driven index selection tool for microsoft sql server. In: Proceedings of the 23rd International Conference on Very Large Data Bases, VLDB 1997, pp. 146–155. Morgan Kaufmann Publishers Inc., San Francisco (1997)
Codd, E.F.: Normalized data base structure: a brief tutorial. In: Proceedings of the 1971 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control, SIGFIDET 1971, pp. 1–17. ACM, New York (1971)
Date, C.J.: Database in Depth: Relational Theory for Practitioners. O’Reilly (2005)
Dittrich, J., Jindal, A.: Towards a One Size Fits All Database Architecture. In: Outrageous Ideas and Vision Track, 5th Biennial Conference on Innovative Data Systems Research, CIDR 2011, January 9-12 (2011)
French, C.D.: “One size fits all” database architectures do not work for DSS. In: SIGMOD 1995: Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, pp. 449–450. ACM, New York (1995)
French, C.D.: Teaching an OLTP Database Kernel Advanced Data Warehousing Techniques. In: ICDE 1997: Proceedings of the 13th International Conference on Data Engineering, pp. 194–198. IEEE Computer Society Press, Washington, DC (1997)
Funke, F., Kemper, A., Neumann, T.: Benchmarking hybrid oltp&olap database systems. In: Härder, T., Lehner, W., Mitschang, B., Schöning, H., Schwarz, H. (eds.) 14. GI-Fachtagung Datenbanksysteme für Business, Technologie und Web (BTW). LNI, vol. 180, pp. 390–409. GI (2011)
Grund, M., Krüger, J., Plattner, H., Zeier, A., Cudre-Mauroux, P., Madden, S.: Hyrise: a main memory hybrid storage engine. Proceedings of the VLDB Endowment 4(2), 105–116 (2010)
Haderle, D.J.: Database Role in Information Systems: The Evolution of Database Technology and its Impact on Enterprise Information Systems. In: Blaser, A. (ed.) Database Systems of the 90s. LNCS, vol. 466, pp. 1–14. Springer, Heidelberg (1990)
Imhoff, C.: A New Class of Operational Data Store. Intelligent Solutions. Information Management Magazine (July 2000)
Inmon, W.H.: The Operational Data Store. In: InfoDB, pp. 21–24 (February 1995)
Inmon, W.H.: The Operational Data Store. Designing the Operational Data Store. Information Management Magazine (July 1998)
Inmon, W.H.: ODS Types. Information Management: Charting the Course. Information Management Magazine (January 2000)
Kemper, A., Neumann, T.: HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots. In: Abiteboul, S., Böhm, K., Koch, C., Tan, K.-L. (eds.) IEEE 27th International Conference on Data Engineering, ICDE, Hannover, pp. 195–206. IEEE Computer Society (April 2011)
Kent, W.: A simple guide to five normal forms in relational database theory. Communications of the ACM 26(2), 120–125 (1983)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley (2002)
Krueger, J., Tinnefeld, C., Grund, M., Zeier, A., Plattner, H.: A Case for Online Mixed Workload Processing. In: 3rd International Workshop on Testing Database System (2010)
Lightstone, S.S., Teorey, T.J., Nadeau, T.: Physical Database Design: The Database Professional’s Guide to Exploiting Indexes, Views, Storage, and more. Morgan Kaufmann Publishers (2007)
Martyn, T.: Reconsidering Multi-Dimensional schemas. ACM SIGMOD Record 33(1), 83–88 (2004)
Moore, G.E.: Cramming More Components onto Integrated Circuits. Electronics 38(8), 114–117 (1965)
Mullins, G.: Database Administration: The Complete Guide to Practices and Procedures. Addison-Wesley (2002)
Nambiar, R., Poess, M.: Transaction Performance vs. Moore’s Law: A Trend Analysis. In: Nambiar, R., Poess, M. (eds.) TPCTC 2010. LNCS, vol. 6417, pp. 110–120. Springer, Heidelberg (2011)
Papadomanolakis, E., Ailamaki, A.: Autopart: Automating schema design for large scientific databases using data partitioning. In: Proceedings of the 16th International Conference on Scientific and Statistical Database Management, pp. 383–392. IEEE Computer Society (2004)
Plattner, H.: A common database approach for oltp and olap using an in-memory column database. In: Proceedings of the 35th SIGMOD International Conference on Management of Data, SIGMOD 2009, pp. 1–2. ACM, New York (2009)
Röhm, U.: OLAP with a Database Cluster. In: Database Technologies: Concepts, Methodologies, Tools, and Applications, pp. 829–846. IGI Global, Hershey (2009)
TPC. TPC-W, Version 1.8. Technical report, Transaction Processing Performance Council (Febuary 2002)
TPC. TPC Benchmark C, Standard Specification, Revision 5.9. Technical report, Transaction Processing Performance Council (June 2007)
TPC. TPC Benchmark H (Decision Support), Standard Specification, Revision 2.7.0. Technical report, Transaction Processing Performance Council (February 2008)
Zilio, D.C., Rao, J., Lightstone, S., Lohman, G., Storm, A., Garcia-Arellano, C., Fadden, S.: Db2 design advisor: integrated automatic physical database design. In: Proceedings of the 30th International Conference on Very Large Data Bases, VLDB 2004, vol. 30, pp. 1087–1097. VLDB Endowment (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bog, A., Sachs, K., Zeier, A., Plattner, H. (2012). Normalization in a Mixed OLTP and OLAP Workload Scenario. In: Nambiar, R., Poess, M. (eds) Topics in Performance Evaluation, Measurement and Characterization. TPCTC 2011. Lecture Notes in Computer Science, vol 7144. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32627-1_5
Download citation
DOI: https://doi.org/10.1007/978-3-642-32627-1_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32626-4
Online ISBN: 978-3-642-32627-1
eBook Packages: Computer ScienceComputer Science (R0)