dorsal/arxiv
View SchemaCSQL: Mapping Documents into Causal Databases
| Authors | Sridhar Mahadevan |
|---|---|
| Categories | |
| ArXiv ID | 2601.08109vv1 |
| URL | https://arxiv.org/abs/2601.08109 |
| License | http://creativecommons.org/licenses/by/4.0/ |
Abstract
We describe a novel system, CSQL, which automatically converts a collection of unstructured text documents into an SQL-queryable causal database (CDB). A CDB differs from a traditional DB: it is designed to answer "why'' questions via causal interventions and structured causal queries. CSQL builds on our earlier system, DEMOCRITUS, which converts documents into thousands of local causal models derived from causal discourse. Unlike RAG-based systems or knowledge-graph based approaches, CSQL supports causal analysis over document collections rather than purely associative retrieval. For example, given an article on the origins of human bipedal walking, CSQL enables queries such as: "What are the strongest causal influences on bipedalism?'' or "Which variables act as causal hubs with the largest downstream influence?'' Beyond single-document case studies, we show that CSQL can also ingest RAG/IE-compiled causal corpora at scale by compiling the Testing Causal Claims (TCC) dataset of economics papers into a causal database containing 265,656 claim instances spanning 45,319 papers, 44 years, and 1,575 reported method strings, thereby enabling corpus-level causal queries and longitudinal analyses in CSQL. Viewed abstractly, CSQL functions as a compiler from unstructured documents into a causal database equipped with a principled algebra of queries, and can be applied broadly across many domains ranging from business, humanities, and science.
{
"annotation_id": "a62b0e53-1efb-4566-b516-c52076476458",
"date_created": "2026-02-17T05:53:15.942000Z",
"date_modified": "2026-02-17T05:53:15.942000Z",
"file_hash": "c16be7206029a6a33e65a9542c3689318d96fb757d17b43d720e5f5f4642fefa",
"private": false,
"record": {
"abstract": "We describe a novel system, CSQL, which automatically converts a collection of unstructured text documents into an SQL-queryable causal database (CDB). A CDB differs from a traditional DB: it is designed to answer \"why\u0027\u0027 questions via causal interventions and structured causal queries. CSQL builds on our earlier system, DEMOCRITUS, which converts documents into thousands of local causal models derived from causal discourse. Unlike RAG-based systems or knowledge-graph based approaches, CSQL supports causal analysis over document collections rather than purely associative retrieval. For example, given an article on the origins of human bipedal walking, CSQL enables queries such as: \"What are the strongest causal influences on bipedalism?\u0027\u0027 or \"Which variables act as causal hubs with the largest downstream influence?\u0027\u0027 Beyond single-document case studies, we show that CSQL can also ingest RAG/IE-compiled causal corpora at scale by compiling the Testing Causal Claims (TCC) dataset of economics papers into a causal database containing 265,656 claim instances spanning 45,319 papers, 44 years, and 1,575 reported method strings, thereby enabling corpus-level causal queries and longitudinal analyses in CSQL. Viewed abstractly, CSQL functions as a compiler from unstructured documents into a causal database equipped with a principled algebra of queries, and can be applied broadly across many domains ranging from business, humanities, and science.",
"arxiv_id": "2601.08109",
"authors": [
"Sridhar Mahadevan"
],
"categories": [
"cs.DB",
"cs.AI",
"cs.IR",
"cs.LG"
],
"license": "http://creativecommons.org/licenses/by/4.0/",
"title": "CSQL: Mapping Documents into Causal Databases",
"url": "https://arxiv.org/abs/2601.08109",
"version": "v1"
},
"schema_id": "dorsal/arxiv",
"source": {
"execution_id": "f8ac0997-d718-447a-a0d9-e2324c3d352c",
"id": "arXiv Dataset",
"type": "Model",
"variant": "snapshot-2026-01-17",
"version": "0.1.0"
},
"user_id": 1000002
}