The Most Versatile Data Management Platform

Technologies
javascript, java, sql, angular
Topics
database, big data, data science, cloud, ai
The Most Versatile Data Management Platform
Polypheny is an adaptive database system using innovative ideas to jointly manage data in multiple models. It bridges the gap between polystores and hybrid transaction/analytical processing (HTAP) systems. In contrast to most existing polystore systems, Polypheny offers support for data manipulation queries. Furthermore, it features a flexible schema, supporting schema changes at runtime. Polypheny is a full database management system providing support for a rich set of data types. Due to its support for features like the enforcement of constraints, transactions, prepared statements, and batch queries, it even goes beyond of what many well-known DBMS provide. Moreover, Polypheny comes with integrated support for several specialized database management systems. Therefore, it is able to efficiently process heterogeneous workloads. The seamless combination of data replication and data partitioning allows combining different underlying data storage engines in order to provide excellent query performance independent of the type of workload. Polypheny even goes a step further in terms of flexibility: With "Data Sources" it is possible to map data on (remote) database systems into the schema of Polypheny. It also features adapters for directly querying CSV files or file systems. Thanks to GSoC 2021, Polypheny now even has support for querying the Ethereum Blockchain. The JDBC, Python and REST query interfaces allow to easily integrate Polypheny into existing environments using industry standard techniques. It supports a broad spectrum of query languages including SQL, CQL, the MongoDB query language and the Pig query language. The powerful browser-based user interface makes managing Polypheny a pleasant experience. In conjunction with the support for multimedia data and workloads, Polypheny offers a flexibility not matched by existing database systems.
2022 Program

Successful Projects

Contributor
Kelly Xie
Mentor
Marc Hennemann, Isabel
Organization
Polypheny
Data Source Adapter for Excel Sheets
This project will allow Polypheny to interact with Excel sheets by adding a data source adapter. The Excel adapter enables Polypheny to query the...
Contributor
AnhTran
Mentor
Marc Hennemann, David Lengweiler
Organization
Polypheny
Data Source Adapter for Google Sheets
A data source adapter is a feature that allows the ability to map existing data into schemas/tables of Polypheny, offering users the benefit of using...
Contributor
Jai
Mentor
Marco Vogt, David Lengweiler
Organization
Polypheny
Railroad Diagram Creation and Implementation for Language Syntax
Currently the documentation for the Syntax of the various SQL’s that Polypheny supports has text based format which proves rather hard to read. The...