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.00012291671
Overall Rank: 1,050 | 92.97%
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.00028524078
1,083	Hybrid Parallelization Strategies for Large-Scale Machine Learning in SystemML	2014	VLDB	0.00012089325
1,226	Data Management in Machine Learning: Challenges, Techniques, and Systems	2017	SIGMOD	0.00011432354
1,375	Ricardo: Integrating R and Hadoop	2010	SIGMOD	0.00010861932
1,786	ArrayStore: A Storage Manager for Complex Parallel Array Processing	2011	SIGMOD	9.6344047e-05
2,083	LINVIEW: Incremental View Maintenance for Complex Analytical Queries	2014	SIGMOD	9.0563677e-05
2,204	Enabling and Optimizing Non-linear Feature Interactions in Factorized Linear Algebra	2019	SIGMOD	8.8531297e-05
2,250	Cumulon: Optimizing Statistical Data Analysis in the Cloud	2013	SIGMOD	8.7477605e-05
2,783	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0027405e-05
3,331	SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning	2017	CIDR	7.4065701e-05
3,397	Putting Pandas in a Box	2021	CIDR	7.3273688e-05
3,945	Flexible Rule-Based Decomposition and Metadata Independence in Modin: A Parallel Dataframe System	2022	VLDB	6.8925046e-05
4,134	Resource Elasticity for Large-Scale Machine Learning	2015	SIGMOD	6.7721426e-05
4,231	Optimizing I/O for Big Array Analytics	2012	VLDB	6.7050212e-05
4,525	Incremental View Maintenance over Array Data	2017	SIGMOD	6.5486702e-05
5,958	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB	5.9165265e-05
6,159	The BUDS Language for Distributed Bayesian Machine Learning	2017	SIGMOD	5.851731e-05
6,411	Profiling R on a Contemporary Processor	2015	VLDB	5.7765871e-05
6,613	A Relational Matrix Algebra and its Implementation in a Column Store	2020	SIGMOD	5.7168098e-05
7,230	Dataset Relationship Management	2019	CIDR	5.5636441e-05
8,615	A Demonstration of Iterative Parallel Array Processing in Support of Telescope Image Analysis	2013	VLDB	5.2878561e-05
9,793	Storing Matrices on Disk: Theory and Practice Revisited	2011	VLDB	5.115551e-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.0010494385
1,002	Declarative Networking: Language, Execution and Optimization	2006	SIGMOD	0.00012560011
2,477	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.392837e-05
4,618	Spatio-Temporal Retrieval with RasDaMan	1999	VLDB	6.4836791e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,948	High-Performance DBMSs with io_uring: When and How to Use It	2026	VLDB
2	396	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD
3	7,324	Theoretically Optimal and Empirically Efficient R-trees with Strong Parallelizability	2018	VLDB
4	3,079	Adaptive Query Processing on RAW Data	2014	VLDB
5	5,958	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,231	Optimizing I/O for Big Array Analytics	2012	VLDB
8	6,411	Profiling R on a Contemporary Processor	2015	VLDB
9	6,038	Proactive Re-optimization with Rio	2005	SIGMOD
10	506	Towards a Unified Architecture for in-RDBMS Analytics	2012	SIGMOD