Sebastian Schmidl

Ph.D. student at the chair for Infomation Systems at Hasso Plattner Institute for Digital Engineering. I am in the distributed computing research group, where we investigate computationally complex problems and how they can be solved in distributed environments.

Contact Information

Hasso-Plattner-Institut für Digital Engineering gGmbH
Prof.-Dr.-Helmert-Str. 2-3
D-14482 Potsdam

Office: F-2.04

Phone: +49 331 5509 4977
Email: Sebastian Schmidl

Research Interests

Distributed computing
Scalable and reactive systems
Data engineering

Teaching

Bachelor Projects:

UltraMine - Scalable Analytics on Time Series Data (2020/2021)

Lectures:

Guest Lecture about distributed discovery of Order Dependencies for the Data Profiling course (2020/2021)

Publications

Weise, J., Schmidl, S., Papenbrock, T.: Optimized Theta-Join Processing. In: Sattler, K.-U., Herschel, M., and Lehner, W. (eds.) Proceedings of the Conference on Database Systems for Business, Technology, and Web (BTW). pp. 59-78. Gesellschaft für Informatik, Bonn (2021).
[ Download ] [ Details ]

Weitere Informationen
HerausgeberSattler, Kai-Uwe and Herschel, Melanie and Lehner, Wolfgang
URNhttp://dx.doi.org/10.18420/btw2021-03
AbstractThe Theta-Join is a powerful operation to connect tuples of different relational tables based on arbitrary conditions. The operation is a fundamental requirement for many data-driven use cases, such as data cleaning, consistency checking, and hypothesis testing. However, processing theta-joins without equality predicates is an expensive operation, because basically all database management systems (DBMSs) translate theta-joins into a Cartesian product with a post-filter for non-matching tuple pairs. This seems to be necessary, because most join optimization techniques, such as indexing, hashing, bloom-filters, or sorting, do not work for theta-joins with combinations of inequality predicates based on <, <=, !=, >=, >. In this paper, we therefore study and evaluate optimization approaches for the efficient execution of theta-joins. More specifically, we propose a theta-join algorithm that exploits the high selectivity of theta-joins to prune most join candidates early; the algorithm also parallelizes and distributes the processing (over CPU cores and compute nodes, respectively) for scalable query processing. The algorithm is baked into our distributed in-memory database system prototype A2DB. Our evaluation on various real-world and synthetic datasets shows that A2DB significantly outperforms existing single-machine DBMSs including PostgreSQL and distributed data processing systems, such as Apache SparkSQL, in processing highly selective theta-join queries.
Schmidl, S., Schneider, F., Papenbrock, T.: An Actor Database System for Akka.Proceedings of the conference on Database Systems for Business, Technology, and Web (BTW) - Workshopband. pp. 225-234 (2019).
[ Download ] [ Details ]

Weitere Informationen
URNhttp://dx.doi.org/10.18420/btw2019-ws-23
AbstractSystem architectures for data-centric applications are commonly comprised of two tiers: An application tier and a data tier. The fact that these tiers do not typically share a common format for data is referred to as object-relational impedance mismatch. To mitigate this, we develop an actor database system that enables the implementation of application logic into the data storage runtime. The actor model also allows for easy distribution of both data and computation across multiple nodes in a cluster. More specifically, we propose the concept of domain actors that provide a type-safe, SQL-like interface to develop the actors of our database system and the concept of Functors to build queries retrieving data contained in multiple actor instances. Our experiments demonstrate the feasibility of encapsulating data into domain actors by evaluating their memory overhead and performance. We also discuss how our proposed actor database system framework solves some of the challenges that arise from the design of distributed databases such as data partitioning, failure handling, and concurrent query processing.

Sebastian Schmidl

Research Interests

Links

Teaching

Publications

Chair

News

14.06.2021 | Paper accepted at PatentSemTech@SIGIR

13.06.2021 | Paper on Data Integration for Toxic Comment Classification Accepted

10.06.2021 | Book chapter published

31.05.2021 | Article accepted for Journal Track of ECML/PKDD 2021

27.05.2021 | Short Paper Accepted at LChange@ACL 2021 Workshop

Project highlights

People and open positions