Closing the functional and Performance Gap between SQL and NoSQL

Summary: Enhances Oracle JSON in 12cR2 with Flexible Schema Data Management, via auto-computed JSON DataGuide soft schema. Introduces OSON, a query-friendly binary JSON encoding narrowing the relational vs. schema-less gap, enabling mixed SQL/NoSQL in RDBMS. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h10e8b7a6c9f27645
Venue: SIGMOD
Year: 2016
Pagerank: 5.5015337e-05
Overall Rank: 7,479 | 49.87%
DOI: 10.1145/2588555.2595628

Incoming Non-self Citations Over Time

Authors

1. Zhen Hua Liu (Oracle)
2. Beda Hammerschmidt (Oracle)
3. Doug McMahon (Oracle)
4. Ying Lu (Oracle)
5. Hui Joe Chang (Oracle)

BibTeX Citation

@inproceedings{liu_sigmod16,
        title = {{Closing the functional and Performance Gap between SQL and NoSQL}},
        author = {Liu, Zhen Hua and Hammerschmidt, Beda and McMahon, Doug and Lu, Ying and Chang, Hui Joe},
        series = {{SIGMOD} '16},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2588555.2595628},
        url = {https://dl.acm.org/doi/10.1145/2588555.2595628},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,464	JSON Relational Duality: A Revolutionary Combination of Document, Object, and Relational Models	2025	SIGMOD	5.5056479e-05
7,484	Reducing Ambiguity in Json Schema Discovery	2021	SIGMOD	5.5005016e-05
7,712	STEED: An Analytical Database System for TrEE-structured Data	2017	VLDB	5.4561733e-05
9,068	Native JSON Datatype Support: Maturing SQL and NoSQL convergence in Oracle Database	2020	VLDB	5.213321e-05
10,216	Adaptive Schema Databases	2017	CIDR	5.0468526e-05
10,369	Zed: Leveraging Data Types to Process Eclectic Data	2023	CIDR	5.0064651e-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
50	DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases	1997	VLDB	0.00042977538
321	Making Database Systems Usable	2007	SIGMOD	0.00021093212
1,753	Sinew: A SQL System for Multi-Structured Data	2014	SIGMOD	9.7119095e-05
1,793	System RX: One Part Relational, One Part XML	2005	SIGMOD	9.6149082e-05
2,634	WideTable: An Accelerator for Analytical Data Processing	2014	VLDB	8.1797149e-05
2,862	JSON Data Management – Supporting Schema-less Development in RDBMS	2014	SIGMOD	7.9096239e-05
3,731	Schema Management for Document Stores	2015	VLDB	7.0445622e-05
7,195	Towards An Enterprise XML Architecture	2005	SIGMOD	5.5731411e-05
9,384	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1701116e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,362	JSON: Data model, Query languages and Schema specification	2017	PODS
2	6,696	Semistructured Models, Queries and Algebras in the Big Data Era	2016	SIGMOD
3	4,111	Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data	2016	SIGMOD
4	11,430	Towards Principled, Practical Document Database Design	2025	VLDB
5	12,123	JSON Schema Matching: Empirical Observations	2020	SIGMOD
6	3,927	JSON Tiles: Fast Analytics on Semi-Structured Data	2021	SIGMOD
7	7,464	JSON Relational Duality: A Revolutionary Combination of Document, Object, and Relational Models	2025	SIGMOD
8	9,384	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR
9	9,068	Native JSON Datatype Support: Maturing SQL and NoSQL convergence in Oracle Database	2020	VLDB
10	2,862	JSON Data Management – Supporting Schema-less Development in RDBMS	2014	SIGMOD