{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,9,15]],"date-time":"2026-09-15T01:18:43Z","timestamp":1789435123901,"version":"build-2803163510"},"reference-count":13,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,8]]},"abstract":"<jats:p>\n                    Unstructured data comprises over 80% of today's information, yet no specialized system effectively supports its semantic analytics. Traditional SQL-based approaches rely on predefined schemas, making them unsuitable. While large language models (LLMs) enable semantic analysis of unstructured data, manually orchestrating execution plans remains inefficient. This raises a critical question:\n                    <jats:italic toggle=\"yes\">how can we automate unstructured data analytics?<\/jats:italic>\n                    In this demonstration, we present Unify, a system that automates unstructured data analytics for natural language queries. Unify defines a set of core operators for unstructured data processing, with both preprogrammed and LLM-based implementations. It guides LLMs to decompose queries into logical steps and map them to appropriate operators for accurate execution. Our demonstration showcases Unify by real-world scenarios, highlighting its ability to bridge the gap between unstructured data and actionable analytics.\n                  <\/jats:p>","DOI":"10.14778\/3750601.3750653","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"5287-5290","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":6,"title":["Unify: A System For Unstructured Data Analytics"],"prefix":"10.14778","volume":"18","author":[{"given":"Jiayi","family":"Wang","sequence":"first","affiliation":[{"name":"Tsinghua University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yuan","family":"Li","sequence":"additional","affiliation":[{"name":"Tsinghua University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jianming","family":"Wu","sequence":"additional","affiliation":[{"name":"Tsinghua University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Shihui","family":"Xu","sequence":"additional","affiliation":[{"name":"Tsinghua University"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Guoliang","family":"Li","sequence":"additional","affiliation":[{"name":"Tsinghua University"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"2025. Stack Exchange Data Archive. https:\/\/archive.org\/download\/stackexchange. Last accessed: 2025-07-11."},{"key":"e_1_2_1_2_1","unstructured":"2025. Wiki Data Archive. https:\/\/dumps.wikimedia.org."},{"key":"e_1_2_1_3_1","volume-title":"Symphony: Towards Natural Language Query Answering over Multi-modal Data Lakes. In CIDR.","author":"Chen Zui","year":"2023","unstructured":"Zui Chen, Zihui Gu, Lei Cao, et al. 2023. Symphony: Towards Natural Language Query Answering over Multi-modal Data Lakes. In CIDR."},{"key":"e_1_2_1_4_1","volume-title":"SIGMOD","author":"Li Guoliang","year":"2025","unstructured":"Guoliang Li, Jiayi Wang, Chenyang Zhang, and Jiannan Wang. 2025. Data+AI: LLM4Data and Data4LLM. In SIGMOD 2025. ACM, 837\u2013843."},{"key":"e_1_2_1_5_1","volume-title":"Palimpzest: Optimizing AI-Powered Analytics with Declarative Query Processing. CIDR.","author":"Liu Chunwei","year":"2025","unstructured":"Chunwei Liu, Matthew Russo, Michael Cafarella, et al. 2025. Palimpzest: Optimizing AI-Powered Analytics with Declarative Query Processing. CIDR."},{"key":"e_1_2_1_6_1","volume-title":"LOTUS: Enabling Semantic Queries with LLMs Over Tables of Unstructured and Structured Data. CoRR","author":"Patel Liana","year":"2024","unstructured":"Liana Patel, Siddharth Jha, Carlos Guestrin, and Matei Zaharia. 2024. LOTUS: Enabling Semantic Queries with LLMs Over Tables of Unstructured and Structured Data. CoRR (2024)."},{"key":"e_1_2_1_7_1","first-page":"57","article-title":"Data Agent: A Holistic Architecture for Orchestrating Data+AI Ecosystems","volume":"50","author":"Sun Zhaoyan","year":"2025","unstructured":"Zhaoyan Sun, Jiayi Wang, Xinyang Zhao, Jiachi Wang, and Guoliang Li. 2025. Data Agent: A Holistic Architecture for Orchestrating Data+AI Ecosystems. IEEE Data Eng. Bull. 50, 1 (2025), 57\u201369.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_8_1","volume-title":"CAESURA: Language Models as Multi-Modal Query Planners. In CIDR.","author":"Urban Matthias","year":"2024","unstructured":"Matthias Urban and Carsten Binnig. 2024. CAESURA: Language Models as Multi-Modal Query Planners. In CIDR."},{"key":"e_1_2_1_9_1","volume-title":"Unify: An Unstructured Data Analytics System. ICDE.","author":"Wang Jiayi","year":"2025","unstructured":"Jiayi Wang and Jianhua Feng. 2025. Unify: An Unstructured Data Analytics System. ICDE."},{"key":"e_1_2_1_10_1","volume-title":"AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries. CIDR","author":"Wang Jiayi","year":"2025","unstructured":"Jiayi Wang and Guoliang Li. 2025. AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries. CIDR (2025)."},{"key":"e_1_2_1_11_1","first-page":"57","article-title":"iDataLake: An LLM-Powered Analytics System on Data Lakes","volume":"49","author":"Wang Jiayi","year":"2025","unstructured":"Jiayi Wang, Guoliang Li, and Jianhua Feng. 2025. iDataLake: An LLM-Powered Analytics System on Data Lakes. IEEE Data Eng. Bull. 49, 1 (2025), 57\u201369.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_12_1","first-page":"2514","article-title":"D-Bot: Database Diagnosis System using Large Language Models","volume":"17","author":"Zhou Xuanhe","year":"2024","unstructured":"Xuanhe Zhou, Guoliang Li, Zhaoyan Sun, Zhiyuan Liu, Weize Chen, Jianming Wu, Jiesi Liu, Ruohang Feng, and Guoyang Zeng. 2024. D-Bot: Database Diagnosis System using Large Language Models. VLDB 17, 10 (2024), 2514\u20132527.","journal-title":"VLDB"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1007\/s41019-023-00235-6"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750653","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:44:09Z","timestamp":1758030249000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750653"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":13,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750653"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750653","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}