Sinew: A SQL System for Multi-Structured Data

Summary: Sinew is a SQL system for multi-structured data, preserving SQL access while embracing JSON-based formats. It stores arbitrary key-value documents in columns and exposes a dynamic relational view for standard SQL, delivering strong gains over JSON/MongoDB. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hb21a1f1dc95741ca
Venue: SIGMOD
Year: 2014
Pagerank: 9.7368807e-05
Overall Rank: 1,743 | 88.29%
DOI: 10.1145/2588555.2612183

Incoming Non-self Citations Over Time

Authors

1. Daniel Tahara (Yale University)
2. Thaddeus Diamond (Hadapt)
3. Daniel J. Abadi (Hadapt; Yale University)

BibTeX Citation

@inproceedings{tahara_sigmod14,
        title = {{Sinew: A SQL System for Multi-Structured Data}},
        author = {Tahara, Daniel and Diamond, Thaddeus and Abadi, Daniel J.},
        series = {{SIGMOD} '14},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2588555.2612183},
        url = {https://dl.acm.org/doi/10.1145/2588555.2612183},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
23	Spark SQL: Relational Data Processing in Spark	2015	SIGMOD	0.00055406774
2,347	Filter Before You Parse: Faster Analytics on Raw Data with Sparser	2018	VLDB	8.6012176e-05
2,436	Mison: A Fast JSON Parser for Data Analytics	2017	VLDB	8.4708399e-05
3,505	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	7.2508161e-05
3,916	JSON Tiles: Fast Analytics on Semi-Structured Data	2021	SIGMOD	6.9285787e-05
4,088	Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data	2016	SIGMOD	6.8148416e-05
6,518	Exploiting Common Patterns for Tree-Structured Data	2017	SIGMOD	5.757997e-05
7,456	Closing the functional and Performance Gap between SQL and NoSQL	2016	SIGMOD	5.5223997e-05
7,693	STEED: An Analytical Database System for TrEE-structured Data	2017	VLDB	5.4768655e-05
8,840	Columnar Formats for Schemaless LSM-based Document Stores	2022	VLDB	5.2665183e-05
9,040	Native JSON Datatype Support: Maturing SQL and NoSQL convergence in Oracle Database	2020	VLDB	5.2330939e-05
9,349	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1897188e-05
10,066	ReCG: Bottom-Up JSON Schema Discovery Using a Repetitive Cluster-and-Generalize Framework	2024	VLDB	5.0874072e-05
10,710	TurboLynx: Schemaless Graph Engine Strikes Back for General-Purpose Analytics	2026	VLDB	4.9793485e-05
12,185	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB	4.9793485e-05
12,438	Tutorial: SQL-on-Hadoop Systems	2015	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
49	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.00043160717
141	Relational Databases for Querying XML Documents: Limitations and Opportunities	1999	VLDB	0.00029294114
326	Storing Semistructured Data with STORED	1999	SIGMOD	0.00020963333
876	Tenzing: A SQL Implementation On The MapReduce Framework	2011	VLDB	0.00013309176
1,037	Jaql: A Scripting Language for Large Scale Semistructured Data Analysis	2011	VLDB	0.00012376819
1,056	Storage and Querying of E-Commerce Data	2001	VLDB	0.00012248386
1,069	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.00012185253
4,295	The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets	2007	SIGMOD	6.6809755e-05
5,255	Pathfinder: XQuery—The Relational Way	2005	VLDB	6.2079337e-05
5,810	Column Stores For Wide and Sparse Data	2007	CIDR	5.9872574e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,037	Future-Proof Data Systems	2026	VLDB
2	10,179	Adaptive Schema Databases	2017	CIDR
3	3,916	JSON Tiles: Fast Analytics on Semi-Structured Data	2021	SIGMOD
4	9,349	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR
5	6,679	Semistructured Models, Queries and Algebras in the Big Data Era	2016	SIGMOD
6	3,723	Schema Management for Document Stores	2015	VLDB
7	11,371	Towards Principled, Practical Document Database Design	2025	VLDB
8	4,088	Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data	2016	SIGMOD
9	2,854	JSON Data Management – Supporting Schema-less Development in RDBMS	2014	SIGMOD
10	1,578	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB