Materialized Views in a Polystore Database System (Master Project, Finished)


Isabel Geissmann


In database systems, a view is the virtual representation of the result of a query which can be queried like a table. This allows to significantly simplify queries and enables additional approaches for query optimization and caching.

The goal of this project is to add support for views in Polypheny-DB. These views should be queryable like tables through the existing query interfaces. The implementation can be limited to read-only workloads.

In addition to these (virtual) views, it should be possible to also add "placements" for views like it is already possible for tables. This would introduce something similar to materialized views in a traditional database system.

A major part of the project is the handling of updates on the underlying tables. In addition to eagerly updating the materialized views, approaches for delayed updates should be investigated.

The project includes implementing support for managing views using the Polypheny-UI and SQL DDL commands.

Start / End Dates

2021/02/01 - 2021/08/01


Research Topics