Navigation auf uzh.ch

Suche

Department of Informatics Data Systems and Theory

News

December 2024: Article in SIGMOD Record database principles column

  • Pessimistic Cardinality Estimation.
    Mahmoud Abo Khamis, Kyle Deeds, Dan Olteanu, Dan Suciu.

Overview of pessimistic cardinality estimators and their comparison with traditional, density-based estimators.


November 2024: Article accepted for PODS 2025

  • Insert-Only versus Insert-Delete in Dynamic Query Evaluation. [ arxiv, ACM ]
    Mahmoud Abo Khamis, Ahmet Kara, Dan Olteanu, Dan Suciu.

October 2024: SNSF Grant on Cardinality Estimation

Many thanks to the Swiss National Science Foundation (SNSF) for funding our research on cardinality estimation with strong theoretical guarantees for the next four years!


September 2024: DaST on Tour

During his sabbatical, Prof. Olteanu will give lectures on DaST research projects at several institutions:


September 2024: UZH Postdoc Grant for Dr. Zilu Tian

Postdoctoral researcher Dr. Zilu Tian was awarded an UZH grant to support her research project "Efficient execution of distributed agent-based simulations" starting October 2024.


August 2024: VLDB 2024 distinguished paper

  • CHORUS: Foundation Models for Unified Data Discovery and Exploration. [arxiv ]
    Moe Kayali, Anton Lykov, Ilias Fountalis, Nikolaos Vasiloglou, Dan Olteanu, Dan Suciu.

Nominated for the best paper award at VLDB 2024 (15 out of 303 accepted papers were nominated)


July 2024: Congratulations, Professor Kara!

Dr. Ahmet Kara will join OTH Regensburg as tenured professor starting September 2024. The DaST group wishes him all the best in his future career and thanks him for his extraordinary contributions to the research, teaching, admin, and well-being of the group over the past four years.


June 2024: Invited talk at SPARSE@PLDI 2024

Dr. Zhang was invited to talk on "Recent Advances in Incremental View Maintenance" at the SPARSE workshop collocated with PLDI 2024 in Copenhagen.


May 2024: Special session on bridging theory and practice at PODS 2024

Prof. Olteanu co-organises together with Prof. Geerts (U Antwerp) a special session on Bridging Theory and Practice at PODS 2024 in Santiago, Chile on June 9, 2024.
Three distinguished invited speakers will give their insights into how to identify research problems that (do not) have potential for theory and practice and their recipes for theory to practice transition or vice versa.


April 2024: Gems of PODS 2024 lecture

Prof. Olteanu will deliver the Gems of PODS lecture at the ACM PODS 2024 conference to be held in Santiago, Chile in June 2024. Gems of PODS features topics and results in PODS that have been highly influential in the PODS community and beyond. The lecture will be on the Incremental View Maintenance problem.


March 2024: SIGMOD 2024 paper

  • Banzhaf Values for Facts in Query Answering. [ arxiv ]
    Omer Abramovich, Daniel Deutch, Nave Frost, Ahmet Kara, Dan Olteanu.
    In SIGMOD 2024.

March 2024: Two PODS 2024 papers, one distinguished paper

  • Join Size Bounds using Lp-Norms on Degree Sequences. [ arxiv]
    Mahmoud Abo Khamis, Vasileios Nakos, Dan Olteanu, Dan Suciu.
    In PODS 2024.
    Distinguished paper, invited to a special issue of ACM TODS for best of PODS 2024
  • From Shapley Value to Model Counting and Back. [ arxiv]
    Ahmet Kara, Dan Olteanu, Dan Suciu.
    In PODS 2024.

November 2023: UZH Global Strategy Grant

We are grateful to UZH for a grant to support our on-going joint research project on dynamic query evaluation with Dr. Milos Nikolic from University of Edinburgh.


October 2023: Lecture on Factorized Databases at Simons Institute

Dr. Kara delivers an overview lecture on factorized databases [video] at the Probabilistic Circuits and Logic workshop, which is part of the "Logic and Algorithms in Database Theory and AI" program at Simons Institute for the Theory of Computing in Berkeley, California.


September 2023: Two articles accepted for VLDB Journal, special issue on Databases and Machine Learning

  • Givens Rotations for QR Decomposition, SVD and PCA over Database Joins. [arxiv]
    Dan Olteanu, Nils Vortmeier, Dorde Zivanovic.
  • F-IVM: Analytics over Relational Databases under Updates. [arxiv]
    Ahmet Kara, Milos Nikolic, Dan Olteanu, Haozhe Zhang.

September 2023: Lectures on Incremental View Maintenance at University of California, Berkeley

Prof. Olteanu is an invited lecturer in the advanced course CS294-248: Topics in Database Theory. His two lectures introduce the topic of incremental view maintenance and highlights recent results done by the DaST team towards efficient fully dynamic algorithms and optimality of the IVM problem.

Slides: pdf. Videos: part 1 and part 2.


September 2023: Welcome Christoph Mayer!

After having spent some time as MSc student with DaST, Christoph Mayer joins DaST as PhD student. He will work on adaptive processing of database and machine learning workloads and will support our teaching on machine learning and query processing.


August 2023: Simons Institute program on "Logic and Algorithms in Database Theory and AI"

DaST work on incremental view maintenance will be presented at the Logic and Algorithms in Database Theory and AI Boot Camp at the Simons Institute for the Theory of Computing in Berkeley, California.

Videos: part 1 and part 2


August 2023: VLDB full paper & demonstration

  • ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning. [ arxiv ]
    Junxiong Wang, Immanuel Trummer, Ahmet Kara, Dan Olteanu.
  • Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning.
    Junxiong Wang, Mitchell E Gray, Immanuel Trummer, Ahmet Kara, Dan Olteanu.

August 2023: Prof. Olteanu named PVLDB Distinguished Associate Editor

Prof. Olteanu is honoured as Distinguished Associate Editor at VLDB 2023 for his work from March 2022 to June 2023 as associate editor of the Proceedings of Very Large Databases Volume 16. This award is in recognition of "the timely handling of the papers, active and thoughtful guidance of the discussions and reviewer probing, well-informed decisions, and detailed meta-reviews". The editorial board comprised 35 associate editors and 213 reviewers. They managed over 1000 papers, out of which 266 were accepted for this volume of PVLDB.


July 2023: UZH Global Strategy Grant

We are grateful to UZH for a grant to support our on-going joint research project on fact attribution in query answering with Prof. Daniel Deutch from Tel Aviv University.


July 2023: Welcome Dr. Johannes Marti!

Johannes joins DaST to support our teaching and research in data science, database theory, and logic.


May 2023: Talks on F-IVM and FiGaRo at DRAGSTERS 2023

  • F-IVM: Analytics over Relational Databases under Updates
  • FiGaRo: Matrix Decompositions over Database Joins

DRAGSTERS (Workshop on Distributions, Relational Algebra, Graphs, Semi-Rings, Tensors, and All That) at the 44th ACM SIGPLAN Conference on Programming Language Design and Implementation (PLDI 2023).


May 2023: SIGMOD'22 work passed the reproducibility test

Out SIGMOD'22 paper Givens QR Decomposition over Relational Databases has been successfully reproduced! It was awarded the badges "Artifacts Evaluated" and "Results Reproduced".


April 2023: Prof. Olteanu's inaugural lecture at UZH

In his inaugural lecture, Prof. Dan Olteanu showcased how the intertwining of theory and systems can successfully address challenges that arise in answering questions over uncertain data and learning over large relational data. [slides (PDF, 8 MB), video


April 2023: DaST research retreat

It was wonderful to meet in person DaST collaborators and friends from EPFL, University of Edinburgh, Ruhr-Bochum University, University of Washington, RelationalAI Zurich, and Apple Zurich, and talk about on-going research projects. More details are here.


April 2023: PhD Student Antonia Kormpa graduated

Congratulations to our student Antonia Kormpa, who defended her PhD thesis in the Department of Computer Science, University of Oxford. Antonia's work establishes a polynomial-time equivalence between two query evaluation problems: for queries with intersection joins and for queries with equality joins. Her work appeared in ACM PODS 2022.


April 2023: PhD Student Dorde Zivanovic graduated

Congratulations to our student Dorde Zivanovic, who defended his PhD thesis in the Department of Computer Science, University of Oxford. Dorde's work in at the interface of linear algebra and relational databases: Matrix decompositions (QR, SVD, PCA), where the matrix is defined by joins over relational data. His work was published in ACM SIGMOD 2022 and will appear in the Special Issue of Databases and Machine Learning of the VLDB Journal 2023.


March 2023: DaST highlight in the IfI research talk series

Brief overview of DaST efforts on the theory and systems for real-time analytics over continuously evolving databases. The slides are available here (PDF, 4 MB).


February 2023: Welcome Prof. Dan Suciu!

Prof. Dan Suciu (University of Washington) will be spending this semester in the DaST research group as part of his sabbatical. He is accompanied by his graduate students Anton Lykov and Moe Kayali. Looking forward to a wonderful research-intensive semester!


January 2023: Three papers on Query Processing Trade-Offs

  • Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries.
    In LMCS (Logical Methods in Computer Science) journal 2023.
  • Conjunctive Queries with Free Access Patterns under Updates.
    In ICDT (International Conference on Database Theory) 2023.
    Distinguished paper, invited to LMCS special issue of best papers at ICDT 2023.
  • Evaluation Trade-Offs for Acyclic Conjunctive Queries.
    In CSL (Computer Science Logic) 2023.

January 2023: PhD Student Haozhe Zhang graduated

Congratulations to our student Haozhe Zhang, who defended his PhD thesis in the Department of Computer Science, University of Oxford. Haozhe's work in on worst-case optimality of maintenance for queries under updates to the input database.


December 2022: OOPSLA paper

  • Functional collection programming with semi-ring dictionaries. [arxiv]
    Proc. ACM Program. Lang. 6(OOPSLA1): 1-33 (2022)
    Distinguished paper, invited to JFP special issue of best papers at OOPSLA 2022

August 2-4, 2022: Factorised Databases workshop

Check out the exciting program of the Factorised Databases workshop to take place from August 2 to 4 in Zurich and online. Contact a member of the DaST team if you are interested to attend.


June 2022: ACM SIGMOD and PODS papers

  • Givens QR Decomposition over Relational Databases [arxiv Video], ACM SIGMOD
    Push QR decomposition of matrices, which are defined by acyclic joins over relational data, past the joins to improve runtime performance and numerical accuracy.
  • The Complexity of Boolean Conjunctive Queries with Intersection Joins [arxiv, Video], ACM PODS
    Settle the longstanding open problem of the data complexity for queries with intersection joins and give syntactic characterisation of all such queries that can be computed in linear time data complexity.

May 2022: Chair of ICDT council

Prof. Olteanu has been elected unanimously by the members of the ICDT (International Conference on Database Theory) council to serve as the chair of the council. In this new role, he is responsible for leading the council meetings.


April 2022: Test of Time Award at 25th International Conference on Database Theory

Dan Olteanu and Jakub Závodný received the Test of Time Award for their ICDT 2012 paper "Factorized Representations of Query Results: Size Bounds and Readability". This award recognizes a paper presented 10 years prior at the ICDT conference that has best met the "test of time" and had the highest impact in terms of research, methodology, conceptual contribution, or transfer to practice over the past decade.

23-minute video of the talk is available here.

News: Conference announcement; UZH IfI; St Cross College, University of Oxford; Department of Computer Science, University of Oxford


December 2021: Invited Talk at DBAI@NeurIPS 2021

Work by the DaST team on "Machine Learning through Database Glasses" to be presented at the Workshop on Databases and AI at NeuIPS 2021 conference.


June 2021: Tutorial at Distributed Event-Based Systems conference

The DaST group will give a tutorial on in-database machine learning at Distributed Event-Based Systems (DEBS) conference in June 2021.


May 2021: Honourable Mention for the 2021 SIGMOD Jim Gray Doctoral Dissertation Award

Former PhD student Maximilian Schleich was awarded an Honourable Mention for the 2021 SIGMOD Jim Gray Doctoral Dissertation Award for his DPhil dissertation entitled "Structure-Aware Learning over Multi-Relational Databases". The award recognizes excellent research by doctoral candidates in the database field.


May 2021: Invited Talk at Spotlight on Logic and Databases

Dr. Ahmet Kara and Prof. Dan Olteanu will give an invited talk on their work on trade-offs in incremental maintenance for query processing at the workshop Spotlight on Logic and Databases associated with the Highlights of Logic, Games, and Automata conference.


October 2020: LMFAO prototype released

LMFAO (Layered Multiple Functional Aggregate Optimisation) has been released in the public domain.

LMFAO 1.0 Repository https://github.com/fdbresearch/LMFAO


September 2020: Three Articles accepted for ACM Transactions on Database Systems

  • Maintaining Triangle Queries under Updates. [arxiv]
    Ahmet Kara, Hung Q. Ngo, Milos Nikolic, Dan Olteanu, Haozhe Zhang.
    In ACM Transactions on Database Systems (TODS), 2020.
    Special issue of best papers at ICDT 2019
  • Functional Aggregate Queries with Additive Inequalities. [arxiv]
    Mahmoud Abo Khamis, Ryan Curtin, Benjamin Moseley, Hung Ngo, XuanLong Nguyen, Dan Olteanu and Maximilian Schleich.
    In ACM Transactions on Database Systems (TODS), 2020.
    Special issue of best papers at PODS 2019
  • In-Database Learning with Sparse Tensors and Functional Dependencies. [arxiv]
    Mahmoud Abo Khamis, Hung Ngo, XuanLong Nguyen, Dan Olteanu, and Maximilian Schleich.
    In ACM Transactions on Database Systems (TODS), 2020.
    Special issue of best papers at PODS 2018

August 2020: VLDB'20 Keynote and System Demonstration

Dan Olteanu will give a . VLDB is an internationally premier forum for data management and database research in academia and industry.


June 2020: PODS'20 Paper and SIGMOD'20 System Demonstration

Check out videos and slides for our PODS and SIGMOD papers on incremental maintenance of queries and machine learning over evolving relational databases:

  • F-IVM: Learning over Fast Evolving Relational Data. (Demonstration)
    Milos Nikolic, Haozhe Zhang, Ahmet Kara, Dan Olteanu.
    In ACM SIGMOD 2020. [pdf, video]
  • Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries.
    Ahmet Kara, Milos Nikolic, Dan Olteanu, Haozhe Zhang.
    In ACM PODS 2020. [arxiv, extended slides, video]

May 2020: PC Chair of ICDT 2022

Prof. Olteanu has been appointed Programme Committee Chair of the International Conference on Database Theory (ICDT) 2022. Together with PODS, ICDT is the main international forum for research in database theory.


May 2020: The DaST group is born

As of 1 May 2020 the Board of the University has appointed Dan Olteanu as ordinary (full/chair) Professor for Big Data Science.
More...