RIOT: I/O-Efficient Numerical Computing without SQL

Summary: RIOT transparently makes R I/O-efficient by intercepting array/numeric operations and executing them on a DB backend without exposing SQL or requiring user code changes. Prototype RIOT-DB uses cross-operation, high-level optimizations to outperform vanilla R on out-of-core workloads. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: h8fa58df8efcacb20
Venue: CIDR
Year: 2009
Pagerank: 0.00012327118
Overall Rank: 1,045 | 92.98%
DOI: -
PDF: Download (CC BY 3.0)

Incoming Non-self Citations Over Time

Authors

1. Yi Zhang (Duke University)
2. Herodotos Herodotou (Duke University)
3. Jun Yang (Duke University)

BibTeX Citation

@inproceedings{zhang_cidr09,
        address = {Amsterdam, Netherlands},
        series = {{CIDR} '09},
        title = {{RIOT: I/O-Efficient Numerical Computing without SQL}},
        booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
        author = {Zhang, Yi and Herodotou, Herodotos and Yang, Jun},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 22 of 22 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
154	MAD Skills: New Analysis Practices for Big Data	2009	VLDB	0.00028568843
1,082	Hybrid Parallelization Strategies for Large-Scale Machine Learning in SystemML	2014	VLDB	0.00012118261
1,223	Data Management in Machine Learning: Challenges, Techniques, and Systems	2017	SIGMOD	0.00011468426
1,371	Ricardo: Integrating R and Hadoop	2010	SIGMOD	0.00010894415
1,774	ArrayStore: A Storage Manager for Complex Parallel Array Processing	2011	SIGMOD	9.6661993e-05
2,087	LINVIEW: Incremental View Maintenance for Complex Analytical Queries	2014	SIGMOD	9.0661817e-05
2,201	Enabling and Optimizing Non-linear Feature Interactions in Factorized Linear Algebra	2019	SIGMOD	8.8708356e-05
2,249	Cumulon: Optimizing Statistical Data Analysis in the Cloud	2013	SIGMOD	8.7544468e-05
2,778	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0261532e-05
3,331	SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning	2017	CIDR	7.4138851e-05
3,385	Putting Pandas in a Box	2021	CIDR	7.3515238e-05
3,931	Flexible Rule-Based Decomposition and Metadata Independence in Modin: A Parallel Dataframe System	2022	VLDB	6.9153238e-05
4,117	Resource Elasticity for Large-Scale Machine Learning	2015	SIGMOD	6.7929814e-05
4,214	Optimizing I/O for Big Array Analytics	2012	VLDB	6.7268411e-05
4,505	Incremental View Maintenance over Array Data	2017	SIGMOD	6.5703306e-05
5,944	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB	5.9360073e-05
6,144	The BUDS Language for Distributed Bayesian Machine Learning	2017	SIGMOD	5.8705515e-05
6,403	Profiling R on a Contemporary Processor	2015	VLDB	5.7950827e-05
6,634	A Relational Matrix Algebra and its Implementation in a Column Store	2020	SIGMOD	5.7243855e-05
7,210	Dataset Relationship Management	2019	CIDR	5.5821013e-05
8,595	A Demonstration of Iterative Parallel Array Processing in Support of Telescope Image Analysis	2013	VLDB	5.305302e-05
9,761	Storing Matrices on Disk: Theory and Practice Revisited	2011	VLDB	5.1325223e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
6	Pig Latin: A Not-So-Foreign Language for Data Processing	2008	SIGMOD	0.0010515896
1,000	Declarative Networking: Language, Execution and Optimization	2006	SIGMOD	0.00012601156
2,478	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.4063622e-05
4,601	Spatio-Temporal Retrieval with RasDaMan	1999	VLDB	6.504744e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	397	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD
2	9,913	High-Performance DBMSs with io_uring: When and How to Use It	2026	VLDB
3	7,306	Theoretically Optimal and Empirically Efficient R-trees with Strong Parallelizability	2018	VLDB
4	3,071	Adaptive Query Processing on RAW Data	2014	VLDB
5	5,944	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB
6	43	A Comparison of Approaches to Large-Scale Data Analysis	2009	SIGMOD
7	4,214	Optimizing I/O for Big Array Analytics	2012	VLDB
8	6,403	Profiling R on a Contemporary Processor	2015	VLDB
9	6,024	Proactive Re-optimization with Rio	2005	SIGMOD
10	503	Towards a Unified Architecture for in-RDBMS Analytics	2012	SIGMOD