English

Relational Deep Dive: Error-Aware Queries Over Unstructured Data

Databases 2025-11-05 v1 Information Retrieval

Abstract

Unstructured data is pervasive, but analytical queries demand structured representations, creating a significant extraction challenge. Existing methods like RAG lack schema awareness and struggle with cross-document alignment, leading to high error rates. We propose ReDD (Relational Deep Dive), a framework that dynamically discovers query-specific schemas, populates relational tables, and ensures error-aware extraction with provable guarantees. ReDD features a two-stage pipeline: (1) Iterative Schema Discovery (ISD) identifies minimal, joinable schemas tailored to each query, and (2) Tabular Data Population (TDP) extracts and corrects data using lightweight classifiers trained on LLM hidden states. A main contribution of ReDD is SCAPE, a statistically calibrated method for error detection with coverage guarantees, and SCAPE-HYB, a hybrid approach that optimizes the trade-off between accuracy and human correction costs. Experiments across diverse datasets demonstrate ReDD's effectiveness, reducing data extraction errors from up to 30% to below 1% while maintaining high schema completeness (100% recall) and precision. ReDD's modular design enables fine-grained control over accuracy-cost trade-offs, making it a robust solution for high-stakes analytical queries over unstructured corpora.

Keywords

Cite

@article{arxiv.2511.02711,
  title  = {Relational Deep Dive: Error-Aware Queries Over Unstructured Data},
  author = {Daren Chao and Kaiwen Chen and Naiqing Guan and Nick Koudas},
  journal= {arXiv preprint arXiv:2511.02711},
  year   = {2025}
}
R2 v1 2026-07-01T07:21:33.126Z