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.00012332595
Overall Rank: 1,044 | 92.99%
DOI: -

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.00028579704
1,081	Hybrid Parallelization Strategies for Large-Scale Machine Learning in SystemML	2014	VLDB	0.00012123917
1,255	Data Management in Machine Learning: Challenges, Techniques, and Systems	2017	SIGMOD	0.00011325762
1,371	Ricardo: Integrating R and Hadoop	2010	SIGMOD	0.00010899041
1,774	ArrayStore: A Storage Manager for Complex Parallel Array Processing	2011	SIGMOD	9.6688719e-05
2,087	LINVIEW: Incremental View Maintenance for Complex Analytical Queries	2014	SIGMOD	9.068879e-05
2,199	Enabling and Optimizing Non-linear Feature Interactions in Factorized Linear Algebra	2019	SIGMOD	8.8750296e-05
2,247	Cumulon: Optimizing Statistical Data Analysis in the Cloud	2013	SIGMOD	8.7585767e-05
2,778	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0299506e-05
3,330	SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning	2017	CIDR	7.4173693e-05
3,384	Putting Pandas in a Box	2021	CIDR	7.3550055e-05
3,930	Flexible Rule-Based Decomposition and Metadata Independence in Modin: A Parallel Dataframe System	2022	VLDB	6.9185978e-05
4,116	Resource Elasticity for Large-Scale Machine Learning	2015	SIGMOD	6.7961306e-05
4,212	Optimizing I/O for Big Array Analytics	2012	VLDB	6.7298655e-05
4,503	Incremental View Maintenance over Array Data	2017	SIGMOD	6.5734419e-05
5,944	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB	5.9387238e-05
6,144	The BUDS Language for Distributed Bayesian Machine Learning	2017	SIGMOD	5.8717563e-05
6,401	Profiling R on a Contemporary Processor	2015	VLDB	5.7978253e-05
6,631	A Relational Matrix Algebra and its Implementation in a Column Store	2020	SIGMOD	5.7270666e-05
7,208	Dataset Relationship Management	2019	CIDR	5.584745e-05
8,588	A Demonstration of Iterative Parallel Array Processing in Support of Telescope Image Analysis	2013	VLDB	5.3078077e-05
9,756	Storing Matrices on Disk: Theory and Practice Revisited	2011	VLDB	5.1349531e-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.001052036
1,000	Declarative Networking: Language, Execution and Optimization	2006	SIGMOD	0.00012607089
2,476	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.409729e-05
4,599	Spatio-Temporal Retrieval with RasDaMan	1999	VLDB	6.5077908e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,906	High-Performance DBMSs with io_uring: When and How to Use It	2026	VLDB
2	397	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD
3	7,303	Theoretically Optimal and Empirically Efficient R-trees with Strong Parallelizability	2018	VLDB
4	3,069	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,212	Optimizing I/O for Big Array Analytics	2012	VLDB
8	6,401	Profiling R on a Contemporary Processor	2015	VLDB
9	6,029	Proactive Re-optimization with Rio	2005	SIGMOD
10	503	Towards a Unified Architecture for in-RDBMS Analytics	2012	SIGMOD