{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,4,7]],"date-time":"2025-04-07T04:02:11Z","timestamp":1743998531659,"version":"3.40.3"},"publisher-location":"Berlin, Heidelberg","reference-count":33,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783642326264"},{"type":"electronic","value":"9783642326271"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2012]]},"DOI":"10.1007\/978-3-642-32627-1_5","type":"book-chapter","created":{"date-parts":[[2012,8,1]],"date-time":"2012-08-01T14:39:57Z","timestamp":1343831997000},"page":"67-82","source":"Crossref","is-referenced-by-count":3,"title":["Normalization in a Mixed OLTP and OLAP Workload Scenario"],"prefix":"10.1007","author":[{"given":"Anja","family":"Bog","sequence":"first","affiliation":[]},{"given":"Kai","family":"Sachs","sequence":"additional","affiliation":[]},{"given":"Alexander","family":"Zeier","sequence":"additional","affiliation":[]},{"given":"Hasso","family":"Plattner","sequence":"additional","affiliation":[]}],"member":"297","reference":[{"key":"5_CR1","first-page":"240","volume-title":"Managing Information Technology in a Global Environment, IRMA 2001","author":"M. Abolhassani","year":"2001","unstructured":"Abolhassani, M.: Business Objects and Enterprise Applications. In: Managing Information Technology in a Global Environment, IRMA 2001, pp. 240\u2013242. Idea Group Publishing, Hershey (2001)"},{"issue":"4","key":"5_CR2","doi-asserted-by":"publisher","first-page":"129","DOI":"10.1145\/820127.820184","volume":"34","author":"D.B. Bock","year":"2002","unstructured":"Bock, D.B., Schrage, J.F.: Denormalization Guidelines for Base and Transaction Tables. ACM SIGCSE Bulletin\u00a034(4), 129\u2013133 (2002)","journal-title":"ACM SIGCSE Bulletin"},{"key":"5_CR3","doi-asserted-by":"publisher","first-page":"321","DOI":"10.1007\/s10796-010-9283-8","volume":"13","author":"A. Bog","year":"2010","unstructured":"Bog, A., Plattner, H., Zeier, A.: A mixed transaction processing and operational reporting benchmark. Information Systems Frontiers\u00a013, 321\u2013335 (2010), http:\/\/dx.doi.org\/10.1007\/s10796-010-9283-8","journal-title":"Information Systems Frontiers"},{"key":"5_CR4","doi-asserted-by":"publisher","first-page":"417","DOI":"10.1145\/1958746.1958806","volume-title":"Proceeding of the Second Joint WOSP\/SIPEW International Conference on Performance Engineering, ICPE 2011","author":"A. Bog","year":"2011","unstructured":"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\u2013418. ACM, New York (2011)"},{"key":"5_CR5","first-page":"146","volume-title":"Proceedings of the 23rd International Conference on Very Large Data Bases, VLDB 1997","author":"S. Chaudhuri","year":"1997","unstructured":"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\u2013155. Morgan Kaufmann Publishers Inc., San Francisco (1997)"},{"key":"5_CR6","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/1734714.1734716","volume-title":"Proceedings of the 1971 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control, SIGFIDET 1971","author":"E.F. Codd","year":"1971","unstructured":"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\u201317. ACM, New York (1971)"},{"key":"5_CR7","unstructured":"Date, C.J.: Database in Depth: Relational Theory for Practitioners. O\u2019Reilly (2005)"},{"key":"5_CR8","unstructured":"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)"},{"key":"5_CR9","doi-asserted-by":"publisher","first-page":"449","DOI":"10.1145\/223784.223871","volume-title":"SIGMOD 1995: Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data","author":"C.D. French","year":"1995","unstructured":"French, C.D.: \u201cOne size fits all\u201d database architectures do not work for DSS. In: SIGMOD 1995: Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, pp. 449\u2013450. ACM, New York (1995)"},{"key":"5_CR10","doi-asserted-by":"crossref","unstructured":"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\u2013198. IEEE Computer Society Press, Washington, DC (1997)","DOI":"10.1109\/ICDE.1997.581753"},{"key":"5_CR11","unstructured":"Funke, F., Kemper, A., Neumann, T.: Benchmarking hybrid oltp&olap database systems. In: H\u00e4rder, T., Lehner, W., Mitschang, B., Sch\u00f6ning, H., Schwarz, H. (eds.) 14. GI-Fachtagung Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW). LNI, vol.\u00a0180, pp. 390\u2013409. GI (2011)"},{"key":"5_CR12","doi-asserted-by":"crossref","unstructured":"Grund, M., Kr\u00fcger, J., Plattner, H., Zeier, A., Cudre-Mauroux, P., Madden, S.: Hyrise: a main memory hybrid storage engine. Proceedings of the VLDB Endowment\u00a04(2), 105\u2013116 (2010)","DOI":"10.14778\/1921071.1921077"},{"key":"5_CR13","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/3-540-53397-4_29","volume-title":"Database Systems of the 90s","author":"D.J. Haderle","year":"1990","unstructured":"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.\u00a0466, pp. 1\u201314. Springer, Heidelberg (1990)"},{"key":"5_CR14","unstructured":"Imhoff, C.: A New Class of Operational Data Store. Intelligent Solutions. Information Management Magazine (July 2000)"},{"key":"5_CR15","unstructured":"Inmon, W.H.: The Operational Data Store. In: InfoDB, pp. 21\u201324 (February 1995)"},{"key":"5_CR16","unstructured":"Inmon, W.H.: The Operational Data Store. Designing the Operational Data Store. Information Management Magazine (July 1998)"},{"key":"5_CR17","unstructured":"Inmon, W.H.: ODS Types. Information Management: Charting the Course. Information Management Magazine (January 2000)"},{"key":"5_CR18","doi-asserted-by":"crossref","unstructured":"Kemper, A., Neumann, T.: HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots. In: Abiteboul, S., B\u00f6hm, K., Koch, C., Tan, K.-L. (eds.) IEEE 27th International Conference on Data Engineering, ICDE, Hannover, pp. 195\u2013206. IEEE Computer Society (April 2011)","DOI":"10.1109\/ICDE.2011.5767867"},{"issue":"2","key":"5_CR19","doi-asserted-by":"publisher","first-page":"120","DOI":"10.1145\/358024.358054","volume":"26","author":"W. Kent","year":"1983","unstructured":"Kent, W.: A simple guide to five normal forms in relational database theory. Communications of the ACM\u00a026(2), 120\u2013125 (1983)","journal-title":"Communications of the ACM"},{"key":"5_CR20","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley (2002)"},{"key":"5_CR21","doi-asserted-by":"crossref","unstructured":"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)","DOI":"10.1145\/1838126.1838134"},{"key":"5_CR22","doi-asserted-by":"crossref","unstructured":"Lightstone, S.S., Teorey, T.J., Nadeau, T.: Physical Database Design: The Database Professional\u2019s Guide to Exploiting Indexes, Views, Storage, and more. Morgan Kaufmann Publishers (2007)","DOI":"10.1016\/B978-012369389-1\/50004-8"},{"issue":"1","key":"5_CR23","doi-asserted-by":"publisher","first-page":"83","DOI":"10.1145\/974121.974136","volume":"33","author":"T. Martyn","year":"2004","unstructured":"Martyn, T.: Reconsidering Multi-Dimensional schemas. ACM SIGMOD Record\u00a033(1), 83\u201388 (2004)","journal-title":"ACM SIGMOD Record"},{"issue":"8","key":"5_CR24","first-page":"114","volume":"38","author":"G.E. Moore","year":"1965","unstructured":"Moore, G.E.: Cramming More Components onto Integrated Circuits. Electronics\u00a038(8), 114\u2013117 (1965)","journal-title":"Electronics"},{"key":"5_CR25","unstructured":"Mullins, G.: Database Administration: The Complete Guide to Practices and Procedures. Addison-Wesley (2002)"},{"key":"5_CR26","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"110","DOI":"10.1007\/978-3-642-18206-8_9","volume-title":"Performance Evaluation, Measurement and Characterization of Complex Systems","author":"R. Nambiar","year":"2011","unstructured":"Nambiar, R., Poess, M.: Transaction Performance vs. Moore\u2019s Law: A Trend Analysis. In: Nambiar, R., Poess, M. (eds.) TPCTC 2010. LNCS, vol.\u00a06417, pp. 110\u2013120. Springer, Heidelberg (2011)"},{"key":"5_CR27","doi-asserted-by":"crossref","unstructured":"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\u2013392. IEEE Computer Society (2004)","DOI":"10.1109\/SSDM.2004.1311234"},{"key":"5_CR28","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/1559845.1559846","volume-title":"Proceedings of the 35th SIGMOD International Conference on Management of Data, SIGMOD 2009","author":"H. Plattner","year":"2009","unstructured":"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\u20132. ACM, New York (2009)"},{"key":"5_CR29","doi-asserted-by":"publisher","first-page":"829","DOI":"10.4018\/978-1-60566-058-5.ch047","volume-title":"Database Technologies: Concepts, Methodologies, Tools, and Applications","author":"U. R\u00f6hm","year":"2009","unstructured":"R\u00f6hm, U.: OLAP with a Database Cluster. In: Database Technologies: Concepts, Methodologies, Tools, and Applications, pp. 829\u2013846. IGI Global, Hershey (2009)"},{"key":"5_CR30","unstructured":"TPC. TPC-W, Version 1.8. Technical report, Transaction Processing Performance Council (Febuary 2002)"},{"key":"5_CR31","unstructured":"TPC. TPC Benchmark C, Standard Specification, Revision 5.9. Technical report, Transaction Processing Performance Council (June 2007)"},{"key":"5_CR32","unstructured":"TPC. TPC Benchmark H (Decision Support), Standard Specification, Revision 2.7.0. Technical report, Transaction Processing Performance Council (February 2008)"},{"key":"5_CR33","doi-asserted-by":"crossref","unstructured":"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.\u00a030, pp. 1087\u20131097. VLDB Endowment (2004)","DOI":"10.1016\/B978-012088469-8.50095-4"}],"container-title":["Lecture Notes in Computer Science","Topics in Performance Evaluation, Measurement and Characterization"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-642-32627-1_5.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,4,6]],"date-time":"2025-04-06T11:52:54Z","timestamp":1743940374000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-642-32627-1_5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012]]},"ISBN":["9783642326264","9783642326271"],"references-count":33,"URL":"https:\/\/doi.org\/10.1007\/978-3-642-32627-1_5","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2012]]}}}