Welcome to the website of the "Enterprise Platform and Integration Concepts" (EPIC) group.
Our activities are focused on the following research topics:
In-Memory Data Management for Enterprise Applications
Human-Centered Software Design and Engineering
In-Memory Data Management for Life Sciences
Our group includes PostDocs, PhD students, and student assistants, and is headed by Prof. Dr. Hasso Plattner. If you are interested in our work or want to join our team, please contact Dr. Matthias Uflacker.
Our team is giving a series of lectures and seminars with a focus on enterprise systems design and in-memory data management. Strong links to the industry ensure a close connection between theory and its implementation in the real world.
Our research focuses on the technical aspects of business software and the integration of different software systems to meet customer requirements. This involves studying the conceptual and technological aspects of in-memory databases, design principles, and programming methods for enterprise applications.
We continually strive to translate our research into practical outputs that improve the quality of enterprise applications. A close link to industry partners ensures relevance and impact of our work. Get here an overview of our current and previous projects.
Traditional databases are separated into ones for current data from the day-to-day business processes and ones for reporting and analytics. For fast moving businesses moving data from one silo to another is cumbersome and takes too much time. As a result the new data arriving in the reporting system is already old by the time it is loaded. HYRISE proposes a new way to solve this problem: It analyzes the query input and reorganizes the stored data in different dimensions. In detail, HYRISE partitions the layout of the underlaying tables in a vertical and horizontal manner depending on the input to this layout management component. The workload is specified as a set of queries and weights and is processed by calculating the layout dependent costs for those queries. Based on our cost-model we can now calculate the best set of partitions for this input workload. This optimization allows great speed improvements compared to traditional storage models.
Hybrid Data Structures for Main Memory Databases
Query Execution in Main Memory Databases
Application-specific Data Management in Enterprise Applications
Common Data Model (CDM) for combined OLTP and OLAP
I finished is doctoral research at the HPI in October 2012 and graduated summa cum laude from HPI. Beginning in November 2012 I will start a research project at the University of Fribourg together with Prof. Philippe Cudre-Mauorux in the area of graph oriented data structures for In-Memory Database Management Systems
Bachelorprojekt 2008/09 - Hauptspeicherorientierte Datenbanken *Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter '09
Wust, J., Grund, M., Hoewelmeyer, K., Schwalb, D., Plattner, H.: Concurrent Execution of Mixed Enterprise Workloads on In-Memory Databases.The 19th International Conference on Database System for Advanced Applications (DASFAA), Bali, Indonesia (2014).
Wust, J., Plattner, H., Grund, M.: Dynamic Query Prioritization for In-Memory Databases.1st International Workshop on In-Memory Data Management and Analytics (IMDM), in conjunction with VLDB 2013, Riva del Garda, Trento, Italy (2013).
Wust, J., Krüger, J., Grund, M., Hartmann, U., Plattner, H.: Sparse Dictionaries for In-Memory Column Stores.Proceedings of the DBKDA 2012, The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications. bll. 25 - 33 (2012).
Krüger, J., Kim, C., Grund, M., Satish, N., Schwalb, D., Chhugani, J., Dubey, P., Plattner, H., Zeier, A.: Fast Updates on Read-Optimized Databases Using Multi-Core CPUs.Proceedings of the VLDB Endowment Volume 5 Issue 1.5, (2011).
Krüger, J., Grund, M., Jaeckel, I., Zeier, A., Plattner, H.: Applicability of GPU Computing for Efficient Merge in In-Memory Databases.Second International Workshop on Accelerating Data Management Systems Using Modern Processor and Storage Architectures (In conjunction with Very Large Data Bases, VLDB) (2011).
Krüger, J., Grund, M., Wust, J., Zeier, A., Plattner, H.: Merging Differential Updates in In-Memory Column Store.Proceedings of the DBKDA 2011, The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications (2011).
Grund, M., Krüger, J., Kleine, M., Zeier, A., Plattner, H.: Optimal Query Operator Materialization Strategy for Hybrid Databases.Proceedings of the DBKDA 2011, The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications (2011).
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).
Krüger, J., Tinnefeld, C., Grund, M., Zeier, A., Plattner, H.: A Case for Online Mixed Workload Processing.Third International Workshop on Testing (DBTest) co-located with SIGMOD Database Systems (2010).
Grund, M., Krüger, J., Tinnefeld, C., Zeier, A.: Vertical Partition for Insert-Only Scenarios in Enterprise Applications.Proceedings of the 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
Tinnefeld, C., Mueller, S., Krüger, J., Grund, M., Zeier, A.: Leveraging Multi-Core CPUs in the Context of Demand Planning.Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
Krueger, J., Grund, M., Tinnefeld, C., Schaffner, J., Mueller, S., Zeier, A.: Enterprise Data Management in Mixed Workload Environments.Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
Grund, M., Schaffner, J., Schapranow, M.-P., Bog, A., Krüger, J.: Operational Reporting Using Navigational SQL.IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
Schapranow, M.-P., Grund, M., Krüger, J., Schaffner, J., Bog, A.: Combining Advantages - Unified Data Stores in Global Enterprises.IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
Krüger, J., Grund, M., Schaffner, J., Schapranow, M.-P., Bog, A.: Shared Table Access Pattern Analysis for Multi-Tenant Applications.IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
We are proud to announce " A Course in In-Memory Data Management" by Prof. Dr. h.c. Hasso Plattner. This book is the culmination of six years work of in-memory research. As such, it provides the technical foundation for combined transactional and analytical workloads inside one single database as well as examples of new applications that are now possible given the availability of the new technology. The book is available at Springer.