Andreas Lübcke
Office: Building 29, Room 125
Phone: ++49 391 67-52845
Fax: ++49 391 67-12020
Email: andreas.luebcke(at)iti.cs.uni-magdeburg.de
Teaching (in German)
Sommersemester 2012
- Datenmanagement (DM)
- Advanced Topics in Databases (AdvDB, in English)
- Management of Business Processes and Workflows (MBPWF, in English)
Wintersemester 2011/12
Sommersemester 2011
- Datenmanagement (DM)
- Advanced Topics in Databases (AdvDB, in English)
- Management of Business Processes and Workflows (MBPWF, in English)
Wintersemester 2010/11
Sommersemester 2010
Wintersemester 2009/10
- Datenbanken: Konzepte und Sprachen (DB I)
- Seminar: Optimierungs- und Modellierungstechniken für Datenbanken
- Seminar: Aktuelle Forschungsthemen in Datenbanksystemen
Sommersemester 2009
- Datenbanken: Implementierungstechniken (DB II)
- Datenmanagement (DM)
- Seminar: Optimierungs- und Modellierungstechniken für Datenbanken (zusammen mit Student Conference)
- Praktikum: Implementierung und Integration aktueller Forschungsansätze in DBS
- Softwareprojekt: Datenbanken und Web 2.0
Wintersemester 2008/09
Sommersemester 2008
- Datenmanagement (DM)
- Seminar: Virtual Engineering
- Spezifikationtechnik
- Softwareprojekt: Modellierung und Entwicklung einer Versuchsdatenbank mit GUI
Wintersemester 2007/08
Sommersemester 2007
- Datenbanken: Implementierungstechniken (DB II)
- Datenmanagement (DM)
- Seminar: Modellmanagement im Virtual Engineering
Wintersemester 2006/07
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
- Physical approaches for high-performance database-extension and -tuning
- Self-tuning techniques
- Materialized views and indexing
- Physical design for databases
Research Projects
- 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
Publications
- Martin Kuhlemann, Andreas Lübcke, and Gunter Saake. Reduction of Program-Generation Times by Transformation-Sequence Optimization. In ENASE, 2012. to appear.
- Andreas Lübcke, Veit Köppen, and Gunter Saake. Heuristics-based Workload Analysis for Relational DBMSs. In UNISCON, 2012. to appear.
- Thorsten Winsemann, Veit Köppen, Andreas Lübcke, and Gunter Saake. A Layered Architecture Approach for Large-Scale Data Warehouse Systems. In UNISCON, 2012. accepted.
- 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.
- 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.
- 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.
- 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.
- 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, 2007. In German.
Supervised Bachelor, Master Theses
- 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.