Andreas Lübcke
Office: Building 29, Room 112
Phone: +49 391 67-52994
Fax: +49 391 67-12020
Email: andreas.luebcke(at)iti.cs.uni-magdeburg.de
Current Teaching (in German)
Wintersemester 2012/13
- Datenbanken: Konzepte und Sprachen (DB I)
- Management of Business Processes and Workflows (MBPWF, in English)
- Database Implementation Techniques (DB II, in English)
Previous Teaching
Research Interests
Data Warehouses:- Extend existing approaches for other applications
- Index- and index-self-tuning (e.g. use bitmap indices)
- ETL and real-time ETL process
- Column-oriented DBMS
- Adaptive data warehousing
- Physical approaches for high-performance database-extension and -tuning
- Self-tuning techniques
- Materialized views and indexing
- Physical design for databases
- Architecture-independent tuning and advise
- Hybrid relational database management
Research Projects
Dissertation "Automated Query Interface for Hybrid Relational Architectures":- Implementing advisor for physical design process
- Implementations for self-tuning with bitmap-indeces
- Automatic index recommendation for materialized views
- Evaluate column-oriented DBMS
- Comparison of ETL, real-time and embedded system approaches
- Adjust tuning and advisor approaches for column and row store
- Implementation of a hybrid relation DBMS
Grants & Awards
Publications
2013
- Andreas Lübcke, Martin Schäler, and Gunter Saake. Dynamic Relational Data Management for Technical Applications. Technical Report 2, University of Magdeburg, Germany, March 2013.
2012
- Martin Schäler, Sandro Schulze, Alexander Grebhahn, Veit Köppen, Andreas Lübcke, and Gunter Saake (Hrsg.). Techniken zur forensischen Datenhaltung - Ausgewählte studentische Beiträge. Collection FIN-05-2012, University of Magdeburg, Germany, October 2012. In German.
- Andreas Lübcke, Martin Schäler, Veit Köppen, and Gunter Saake. Workload-based Heuristics for Evaluation of Physical Database Architectures. In DB&IS, pages 3–10, Vilnius, Lithuania, July 2012. University of Vilnius.
- Martin Kuhlemann, Andreas Lübcke, and Gunter Saake. Reduction of Program-Generation Times by Transformation-Sequence Optimization. In ENASE, pages 182–186, Wroclaw, Poland, June 2012. SciTePress.
- Andreas Lübcke, Veit Köppen, and Gunter Saake. Heuristics-based Workload Analysis for Relational DBMSs. In UNISCON, LNBIP 137, pages 22–36, Yalta, Ukraine, May 2012. Springer.
- Thorsten Winsemann, Veit Köppen, Andreas Lübcke, and Gunter Saake. A Layered Architecture Approach for Large-Scale Data Warehouse Systems. In UNISCON, page to appear, Yalta, Ukraine, May 2012.
2011
- Andreas Lübcke, Veit Köppen, and Gunter Saake. A Query Decomposition Approach for Relational DBMS using Different Storage Architectures. Technical Report 11, University of Magdeburg, Germany, December 2011.
- Andreas Lübcke, Veit Köppen, and Gunter Saake. Workload Representation across Different Storage Architectures for Relational DBMS. In Proceedings of the 23. GI-Workshop on Foundations of Databases, pages 79–84, Obergurgl, Austria, June 2011. Universtiy of Innsbruck.
- Andreas Lübcke, Veit Köppen, and Gunter Saake. A Decision Model to Select the Optimal Storage Architecture for Relational Databases. In Proceedings of the Fifth IEEE International Conference on Research Challenges in Information Science, RCIS, pages 74–84, Gosier, France, May 2011. IEEE.
2010
- Andreas Lübcke, Veit Köppen, and Gunter Saake. Towards Selection of Optimal Storage Architecture for Relational Databases. Technical Report 11, University of Magdeburg, Germany, December 2010.
- Andreas Lübcke and Gunter Saake. A Framework for Optimal Selection of a Storage Architecture in RDBMS. In DB&IS, pages 65–76, Riga, Latvia, July 2010. University of Latvia.
- Andreas Lübcke. Challenges in Workload Analyses for Column and Row Stores. In Proceedings of the 22. GI-Workshop on Foundations of Databases, Bad Helmstedt, Germany, May 2010. Institute for Information Systems, University of Brunswick.
2009
- Andreas Lübcke, Ingolf Geist, and Ronny Bubke. Dynamic Construction and Administration of the Workload Graph for Materialized Views Selection. International Journal of Information Studies, 1(3):172–181, July 2009.
- Andreas Lübcke. Self-tuning of Data Allocation and Storage Management: Advantages and Implications. In Proceedings of the 21. GI-Workshop on Foundations of Databases, pages 21–25, Warnemünde, Germany, June 2009. University of Rostock.
2008
- Andreas Lübcke, Ingolf Geist, and Ronny Bubke. Dynamic detection and administration of materialized views based on the Query Graph Model. In Proceedings of the Third IEEE International Conference on Digital Information Management (ICDIM), pages 940–942, London, UK, November 2008. IEEE.
- Andreas Lübcke. Cost-Effective Usage of Bitmap-Indexes in DS-Systems. In Proceedings of the 20. GI-Workshop on Foundations of Databases, pages 96–100, Apolda, Germany, May 2008. School of Information Technology, International University in Germany.
2007
- Andreas Lübcke. Self-Tuning-Konzepte zur Verwaltung von Bitmap-Index-Konfigurationen. Master thesis (diplomarbeit), University of Magdeburg, Germany, April 2007. In German.
- Andreas Lübcke. Self-Tuning für Bitmap-Index-Konfigurationen. In BTW Studierendenprogramm, pages 28–30. International University, Bruchsal, Germany, 2007. In German.
Supervised Bachelor, Master Theses
- Konstantin Sander. Entwurf und Implementierung eines Data-Warehouses zur Erstellung von Analyseberichten. Bachelor thesis, University of Magdeburg, Germany, December 2012. In German.
- Waldemar Braun. Anfrageinterface für zeilenorientierte und spaltenorientierte Datenbanksysteme. Master thesis, University of Magdeburg, Germany, October 2012. In German.
- Daniel Lüddecke. Extraktion von Feature-Modellen aus Implementierungsartefakten. Master thesis, University of Magdeburg, Germany, October 2012. In German.
- Andreas Meister. Optimierung der verteilten und parallelen Datenverarbeitung in der GINSENG-Middleware. Bachelor thesis, University of Magdeburg, Germany, June 2012. In German.
- Tobias Mittelstädt. Processifying Database Communication. Bachelor thesis, University of Magdeburg, Germany, June 2012.
- Henning Steinhorst. Spalten-orientierte Datenbanken: Empirische Untersuchung ihrer Performanz im Hinblick auf verschiedene Anwendungsszenarien. Bachelor thesis, University of Magdeburg, Germany, June 2012. In German.
- Thanh Hong Nguyen. Materialisierung von Tupeln in spaltenorientierten Datenbanken. Bachelor thesis, University Magdeburg, Germany, June 2012. In German.
- Steven Ladewig. Konzeption und Entwicklung einer automatisierten Schnittstelle für Warenwirtschafts- und Versandsysteme von Onlineshops. Bachelor thesis, University of Magdeburg, Germany, March 2012. In German.
- Robert Clausing. Prototypische Implementierung einer integrierten Personensuchbasis für Oracle-Datenbanken. Bachelor thesis, University of Magdeburg, Germany, May 2011. In German.
- Kamran Safdar. Framework to select an optimal data block size in Oracle. Master thesis, University of Magdeburg, Germany, May 2011.
- André Kausche. Entwicklung eines Konzepts zur Optimierung der Mengenplanung im Produktionsbereich und Implementierung in ein bestehendes Informationssystem. Master thesis (diplomarbeit), University of Magdeburg, Germany, March 2011. In German.
- Ulf Wucherpfennig. Entwicklung einer webbasierten Anwendung für eine flexible und effiziente Verwaltung von antiken Fluchtafeln durch spezialisierte Historiker mit Anwendung des UTF-Formats. Bachelor thesis, University of Magdeburg, Germany, March 2011. In German.
- Konstanze Winter. Erarbeitung eines Datenbank-Konzeptes für ein Werkzeug zur Planung und Visualisierung von Fabrikstrukturen. Bachelor thesis, University of Magdeburg, Germany, December 2010. In German.
- Eniyavan Chennai Sivaji. State of the Art in Column-oriented Database Management Systems. Master thesis, University of Magdeburg, Germany, August 2010.
- Carsten Wittwer. Klassifizierung von Ansätzen für column oriented DBMS. Master thesis (diplomarbeit), University of Magdeburg, Germany, December 2009. In German.
- Carsten Wittwer. Herleitung und Extraktion von Schematagraphen aus integrierten Datenbanken der Lebenswissenschaften. Bachelor thesis, University of Magdeburg, Germany, January 2009. In German.