Multi-model databases and polystore systems are increasingly studied for managing multimodel data holistically.As their primary interface, multi-model query languages (MMQLs) often exhibit complex grammars, highlighting the need for effective Text-to-MMQL translation methods.Despite advances in natural language translation, no effective solutions for Text-to-MMQL exist.To address this gap, we formally define the Text-to-MMQL task and present the first Text-to-MMQL dataset involving three representative MMQLs.We propose an adaptive Text-to-MMQL framework that includes both a schema embedding module for capturing multi-model schema information and an MMQL representation strategy to generate concise intermediate query formats with error correction in generated queries.Experimental results show that the proposed framework achieves over a 9% accuracy improvement over our adapted baseline methods.

Procedural Language extensions of SQL (abbr. PL/SQL) enhance database programming by integrating procedural constructs with SQL's declarative syntax, thereby improving the reusability, modularity, and maintainability of SQL. Besides, PL/SQL in database systems presents significant challenges in real-world development, primarily due to the inherent complexity of programming. To reduce the development difficulty of PL/SQL, this paper studies the novel task of translating natural language (NL) to PL/SQL (i.e., NL-to-PL/SQL), aimed at simplifying PL/SQL development. Recent advancements in language models have shown promise in translating natural language questions into SQL queries (i.e., Text-to-SQL). However, the state-of-the-art Text-to-SQL methods focus only on single SQL queries, neglecting the procedural extensions of SQL, which limits their effectiveness for the NL-to-PL/SQL task. In this paper, we propose PLForge, a suite of pre-trained language models with parameter configurations of 3B, 7B, and 15B, tailored for NL-to-PL/SQL tasks. To enhance the PL/SQL generation capabilities of PLForge, we leverage a curated PL/SQL-centric data corpus and employ an incremental pre-training approach. Furthermore, to fully exploit the potential of PLForge, we propose a comprehensive prompt construction strategy tailored specifically for PL/SQL. Given the scarcity of NL-to-PL/SQL datasets, we develop a template-based method for generating NL-to-PL/SQL data. We conduct a series of experiments on PLForge and several baseline models. Based on execution match and exact match metrics that are designed specifically for the NL-to-PL/SQL task, the experimental results demonstrate that PLForge outperforms existing models in both in-context learning and supervised fine-tuning settings.

The concept of polystore has been proposed and studied for heterogeneous data storage and cross-model query processing. Correspondingly, the evaluation of diverse polystores is an essential yet challenging task. However, most current evaluation approaches for polystores only focus on cross-model analytical workloads and provide limited configurations. To address these problems, this paper presents a flexible polystore evaluation platform named FONT. FONT incorporates hybrid single-model and cross-model workloads that combine read and write operations, as well as diagnostic analytical workloads. FONT supports customization of both multi-model dataset generation and workload generation procedures. The proposed platform is the first visual tool for polystore evaluation, providing user-friendly graphical interfaces for user customization and displaying evaluation results.