Hasso-Plattner-Institut
Prof. Dr. h.c. Hasso Plattner
  
 

Martin Lorenz, M.Sc.

Research Assistant, PhD Student

  Phone: +49 (331) 5509-1318
  Fax: +49 (331) 979 92-579
  Email: martin.lorenz(at)hpi.de
  Address: August-Bebel-Str. 88 Potsdam, Brandenburg, 14482 Germany
  Room: V-2.01

Overview

Enterprise information systems can be characterized as OnLine Transaction Processing (OLTP) or OnLine Analytical Processing (OLAP). In an enterprise information system landscape, OLTP systems are mostly systems that capture information either through single transactions (e.g., web forms) or batch operations (e.g., importing CSV-files). OLAP systems are business intelligence or decision support systems, which perform complex analytics (e.g., demand planning), based on the information captured by OLTP systems. Up to the present, the separation of both types of systems manifests itself in in the form of dedicated database technologies for either of the two. Systems with an OLTP database workload mainly rely on row-oriented systems, optimized for write operations. OLAP databases favor column-oriented data layout to optimize complex read operations. The data transfer from OLTP to OLAP systems is managed via an ETL process, which extracts, transforms, and loads the data. Drawbacks of that architecture include the inability to perform real-time analytics based on the most current data and an increased total cost of ownership (TCO), because two separate systems have to be managed and maintained.

One of the greatest promises of in-memory technology is the reunification of OLTP and OLAP. In-memory technology combines the advantages of hardware trends ( multi-core CPUs, cheap main memory) with suitable software concepts ( light-weight compression, column-orientation, differential buffer) to design a database system that allows run OLAP-style and OLTP-style queries on the same platform. A question that is to be answered is what is an appropriate data model design for a database system that supports mixed workloads. The data layout (row- vs. column-orientation) is only one characteristic that distinguishes OLAP and OLTP databases, the other one is the data model. Database schemas for OLTP systems are highly normalized to minimize the data volume and to speed up data manipulation queries. OLAP systems on the other hand are tuned to access large portions of data to analyze them in a timely manner. Star or snowflake schemas are the most prominent designs for OLAP database schemas.

In my research, I focus on data model designs and data access technologies that support the requirements of modern enterprise applications and at the same time are optimized for the concepts of an in-memory column-store.

Research Interests

Fig. 1 Mapping Strategies

Class inheritance is one of the major features of object-oriented programming languages. It provides for advanced conceptual modeling and code and structural reuse. However, fundamental differences between object-oriented programming and relational algebra obviate a straight forward mapping between domain models, designed for application logic, and relational data models, designed to persist the data. Research has proposed three different mapping strategies to persist inheritance hierarchies in relational databases (Figure 1).

 

What they all have in common is an inherent tradeoff between memory consumption and query performance. Depending on the actual characteristics of the inheritance structure at hand, each strategy has its strength and weaknesses. Consequently, the combination of inheritance characteristics and prioritization of non-functional requirements (memory consumption and query performance) leads to a decision for the appropriate strategy. Unfortunately, not all characteristics of the inheritance hierarchy can be defined in advance. Especially runtime characteristics, such as the distribution of objects along the hierarchy can rarely be determined at system's design time. This problem becomes even more serious for vendors of standard software, since they offer their software for a number of customers from different industries and various sizes.

In my research, I look at column-orientation, as a means to structure physically data in memory. In-memory column-oriented databases proof to be advantageous over traditional disk-based row-oriented storage technologies, both in terms of memory consumption and query performance. Additionally to that, it also seems to shift the tradeoff between those two requirements depending on the chosen mapping strategy. Both facts make column-orientation a promising fit for mapping inheritance hierarchies to relational databases.

Master's Thesis Topics

We offer different Master's Thesis topics in this field of research. If you are interested, please contact us for more information.

Teaching activities

Summer Term 2013

Winter Term 2012/13

Summer Term 2012

Winter Term 2011/2012

Summer Term 2011

Winter Term 2010/2011

Publications

  • Serth, S., Podlesny, N., Bornstein, M., Lindemann, J., Latt, J., Selke, J., Schlosser, R., Boissier, M., Uflacker, M.: An Interactive Platform to Simulate Dynamic Pricing Competition on Online Marketplaces. 21st IEEE International Enterprise Distributed Object Computing Conference, EDOC 2017, Quebec City, QC, Canada, October 10-13, 2017. bll. 61-66. IEEE (2017).
     
  • Boissier, M., Schlosser, R., Podlesny, N., Serth, S., Bornstein, M., Latt, J., Lindemann, J., Selke, J., Uflacker, M.: Data-Driven Repricing Strategies in Competitive Markets: An Interactive Simulation Platform. Proceedings of the Eleventh ACM Conference on Recommender Systems. bll. 355-357. ACM, New York, NY, USA (2017).
     
  • Lorenz, M., Rudolph, J.-P., Hesse, G., Uflacker, M., Plattner, H.: Object-Relational Mapping Revisited-A Quantitative Study on the Impact of Database Technology on O/R Mapping Strategies. Proceedings of the 50th Hawaii International Conference on System Sciences (2017).
     
  • Zimmermann, T., Djürken, T., Mayer, A., Janke, M., Boissier, M., Schwarz, C., Schlosser, R., Uflacker, M.: Detecting Fraudulent Advertisements on a Large E-Commerce Platform. Proceedings of the Nineteenth International Workshop on Data Warehousing and OLAP, DOLAP, Venice, Italy, March 21, 2017 (2017).
     
  • Boissier, M., Spivak, A., Meyer, C.: Improving Materialization for Tiered Column-Stores: A Workload-Aware Ansatz Based on Table Reordering. ACSW '17 Proceedings of the Australasian Computer Science Week Multiconference, ACSW '17. bll. 25:1-25:10. ACM, New York, NY, USA (2017).
     
  • Schlosser, R., Boissier, M.: Optimal Price Reaction Strategies in the Presence of Active and Passive Competitors. Proceedings of the 6th International Conference on Operations Research and Enterprise Systems (ICORES), Porto, Portugal (2017).
     
  • Boissier, M., Meyer, C., Djürken, T., Lindemann, J., Mao, K., Reinhardt, P., Specht, T., Zimmermann, T., Uflacker, M.: Analyzing Data Relevance and Access Patterns of Live Production Database Systems. Proceedings of the 25th ACM International on Conference on Information and Knowledge Management. bl. 2473--2475. ACM, New York, NY, USA (2016).
     
  • Boissier, M., Djürken, T., Schlosser, R., Faust, M.: A Cost-Aware and Workload-Based Index Advisor for Columnar In-Memory Databases. 22nd International Conference, ICIST 2016, Druskininkai, Lithuania, October 13-15, 2016, Proceedings, CCIS 639. bl. 285--299 (2016).
     
  • Faust, M., Boissier, M., Keller, M., Schwalb, D., Bischoff, H., Eisenreich, K., Färber, F., Plattner, H.: Footprint Reduction and Uniqueness Enforcement with Hash Indices in SAP HANA. Database and Expert Systems Applications: 27th International Conference, DEXA 2016, Porto, Portugal, September 5-8, 2016, Proceedings, Part II. bl. 137--151 (2016).
     
  • Richly, K., Lorenz, M., Oergel, S.: S4J - Integrating SQL into Java at Compiler-Level. To appear in Information and Software Technologies - 22st International Conference, ICIST 2016, Proceedings (Springer - Communications in Computer and Information Science) (2016).
     
  • Lorenz, M., Hesse, G., Rudolph, J.-P.: Object-relational Mapping Revised - Guideline Review and Consolidation. Proceedings of the 11th International Joint Conference on Software Technologies (ICSOFT 2016) - Volume 1: ICSOFT-EA, Lisbon, Portugal, July 24 - 26, 2016. bll. 157-168 (2016).
     
  • Schlosser, R., Boissier, M., Schober, A., Uflacker, M.: How To Survive Dynamic Pricing Competition in E-commerce. Proceedings of the Poster Track of the 10th ACM Conference on Recommender Systems (RecSys 2016), Boston, USA, September 17, 2016 (2016).
     
  • Lorenz, M.: The impact of column-orientation on the quality of class inheritance mapping specifications. Software Analysis, Evolution and Reengineering (SANER), 2015 IEEE 22nd International Conference on (2015).
     
  • Hesse, G., Lorenz, M.: Conceptual Survey on Data Stream Processing Systems. Parallel and Distributed Systems (ICPADS), 2015 IEEE 21st International Conference on. 797-802 (2015).
     
  • Boissier, M., Meyer, C., Uflacker, M., Tinnefeld, C.: And all of a sudden: Main Memory Is Less Expensive Than Disk. In: Rabl, T., Sachs, K., Poess, M., K. Baru, C., en Jacobsen, H.-A. (reds.) Big Data Benchmarking. bll. 132-144. Springer International Publishing (2015).
     
  • Meyer, C., Boissier, M., Michaud, A., Vollmer, J.O., Taylor, K., Schwalb, D., Uflacker, M., Roedszus, K.: Dynamic and Transparent Data Tiering for In-Memory Databases in Mixed Workload Environments. International Workshop on Accelerating Data Management Systems Using Modern Processor and Storage Architectures - ADMS @ VLDB 2015 (2015).
     
  • Lorenz, M., Albrecht, J.: Object-Relational Mapping Strategies revised – A comparison of Row- and Column- oriented Database Systems. International Conference on Challenges in IT, Engineering and Technology (ICCIET) (2014).
     
  • Boissier, M., Krüger, J., Wust, J., Plattner, H.: An Integrated Data Management for Enterprise Systems. In: Hammoudi, S., Maciaszek, L.A., en Cordeiro, J. (reds.) ICEIS 2014 - Proceedings of the 16th International Conference on Enterprise Information Systems. bll. 410-418. SciTePress (2014).
     
  • Boissier, M.: Optimizing Main Memory Utilization of Columnar In-Memory Databases Using Data Eviction. Proceedings of Phd Workshop @ VLDB 2014, Hangzhou (2014).
     
  • Januschowski, T., Kolassa, S., Lorenz, M., Schwarz, C.: Forecasting With In-Memory Technology. Foresight, The International Journal of Applied Forecasting. (2013).
     
  • Folkerts, E., Heimburger, R., Simchi-Levi, D., Youssef, N., Schwarz, C., Lorenz, M., Januschowski, T., Akkas, A.: Demand Forecasting with partial POS Data using In-Memory Technology. 32nd International Symposium on Forecasting in Boston (2012).
     
  • Schapranow, M.-P., Lorenz, M., Zeier, A., Plattner, H.: License-based Access Control in EPCglobal Networks. The 7th European Workshop on RFID Systems and Technologies, pp. 1-7 (2011).
     
  • Krüger, J., Hübner, F., Wust, J., Boissier, M., Zeier, A., Plattner, H.: Main Memory Databases for Enterprise Applications. IEEE 18Th International Conference on Industrial Engineering and Engineering Management (IE&EM), 2011 (2011).
     
  • Lorenz, M., Müller, J., Schapranow, M.-P., Zeier, A.: A Distributed EPC Discovery Service based on Peer-to-peer Technology. Proceedings of the RFID SysTech 2011, 7th European Workshop on Smart Objects: Systems, Technologies and Applications, Dresden. bll. 1 - 7. VDE (2011).
     
  • Schapranow, M.-P., Zeier, A., Plattner, H., Müller, J., Lorenz, M.: Discovery Services in the EPC Network. Designing and Deploying RFID Applications, pp. 109-130, INTECH Press (2011).
     
  • Schapranow, M.-P., Geller, F., Lorenz, M., Müller, J., Kowark, T., Zeier, A.: Assessment of Communication Protocols in the EPC Network: Replacing Textual SOAP and XML with Binary Google Protocol Buffers Encoding. 17th IEEE International Conference on Industrial Engineering and Engineering Management (IE&EM), Xiamen, China (2010).
     
  • Krüger, J., Grund, M., Boissier, M., Zeier, A., Plattner, H.: Data Structures for Mixed Workloads in In-Memory Databases. 5th International Conference on Computer Sciences and Convergence Information Technology (ICCIT), 2010 (2010).