IEEE

Generate Text-to-SQL Queries Based on Sketch Filling

Abstract: The Text-to-SQL task has significant application prospects in automating relational database query interfaces. It can reduce user learning costs and improve data query efficiency. However, ...
GitHub

SQL-Mongo Converter - A Lightweight SQL to MongoDB (and Vice Versa) Query Converter

SQL-Mongo Converter is a lightweight Python library for converting SQL queries into MongoDB query dictionaries and converting MongoDB query dictionaries into SQL statements. It is designed for ...
GitHub

Critical: HNSW Index Segmentation Fault with Parameterized Queries on ruvector(384) Columns

HNSW indexes on ruvector(384) columns cause PostgreSQL to crash with a segmentation fault when executing similarity queries with parameterized query vectors. The crash is 100% reproducible with ...
IEEE

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Abstract: Efficient SQL Query Optimization (QO) is a fundamental aspect of database management systems, aimed at enhancing query performance and reducing resource consumption typically involves ...