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.7119095e-05
Overall Rank: 1,753 | 88.26%
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.00055523999
2,356	Filter Before You Parse: Faster Analytics on Raw Data with Sparser	2018	VLDB	8.5715425e-05
2,446	Mison: A Fast JSON Parser for Data Analytics	2017	VLDB	8.4392802e-05
3,510	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	7.2263115e-05
3,927	JSON Tiles: Fast Analytics on Semi-Structured Data	2021	SIGMOD	6.9025015e-05
4,111	Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data	2016	SIGMOD	6.7891131e-05
6,532	Exploiting Common Patterns for Tree-Structured Data	2017	SIGMOD	5.7362407e-05
7,479	Closing the functional and Performance Gap between SQL and NoSQL	2016	SIGMOD	5.5015337e-05
7,712	STEED: An Analytical Database System for TrEE-structured Data	2017	VLDB	5.4561733e-05
8,868	Columnar Formats for Schemaless LSM-based Document Stores	2022	VLDB	5.2467001e-05
9,068	Native JSON Datatype Support: Maturing SQL and NoSQL convergence in Oracle Database	2020	VLDB	5.213321e-05
9,384	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1701116e-05
10,105	ReCG: Bottom-Up JSON Schema Discovery Using a Repetitive Cluster-and-Generalize Framework	2024	VLDB	5.0681847e-05
10,781	TurboLynx: Schemaless Graph Engine Strikes Back for General-Purpose Analytics	2026	VLDB	4.9605343e-05
12,234	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB	4.9605343e-05
12,487	Tutorial: SQL-on-Hadoop Systems	2015	VLDB	4.9605343e-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.00043085722
141	Relational Databases for Querying XML Documents: Limitations and Opportunities	1999	VLDB	0.00029191386
329	Storing Semistructured Data with STORED	1999	SIGMOD	0.00020888032
876	Tenzing: A SQL Implementation On The MapReduce Framework	2011	VLDB	0.00013272245
1,040	Jaql: A Scripting Language for Large Scale Semistructured Data Analysis	2011	VLDB	0.00012336829
1,062	Storage and Querying of E-Commerce Data	2001	VLDB	0.00012205105
1,072	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.00012143482
4,313	The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets	2007	SIGMOD	6.6565501e-05
5,278	Pathfinder: XQuery—The Relational Way	2005	VLDB	6.1850189e-05
5,825	Column Stores For Wide and Sparse Data	2007	CIDR	5.9647545e-05

Semantically Similar Papers

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