Polypheny Prism: Lessons Learned from Crafting a Versatile Multimodel, Multilingual Query Interface

Query interfaces are essential components of Database Management Systems (DBMS), enabling efficient data retrieval and manipulation. The diversification of DBMSs, driven by the increasing volume and complexity of data, has led to data silos with incompatible data models and query languages. Polystores and PolyDBMSs address this issue by providing a unified interface for accessing and integrating data across heterogeneous systems. This paper introduces Prism, a conceptual model and implementation of a multimodel, multilingual query interface protocol. Prism facilitates the use of multiple query languages and data models within a single protocol, simplifying data integration and application development.

• Heiko Schuldt
• Marco Vogt
• Martin Vahlensieck
• Tobias Hafner

• Polypheny-DB: Cost- and Workload-aware Adaptive Data Management
• Polypheny-DDI: A Flexible Polystore-based Distributed Data Infrastructure
• SwissRenov