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: 125
Venue: CIDR
Year: 2009
Pagerank: 0.00012474977
Overall Rank: 1,039 | 92.88%
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
155	MAD Skills: New Analysis Practices for Big Data	2009	VLDB	0.00028713176
1,079	Hybrid Parallelization Strategies for Large-Scale Machine Learning in SystemML	2014	VLDB	0.00012258469
1,250	Data Management in Machine Learning: Challenges, Techniques, and Systems	2017	SIGMOD	0.00011485301
1,333	Ricardo: Integrating R and Hadoop	2010	SIGMOD	0.0001112858
1,742	ArrayStore: A Storage Manager for Complex Parallel Array Processing	2011	SIGMOD	9.8748669e-05
2,059	LINVIEW: Incremental View Maintenance for Complex Analytical Queries	2014	SIGMOD	9.2471145e-05
2,179	Enabling and Optimizing Non-linear Feature Interactions in Factorized Linear Algebra	2019	SIGMOD	9.0146333e-05
2,217	Cumulon: Optimizing Statistical Data Analysis in the Cloud	2013	SIGMOD	8.9332438e-05
2,847	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0583142e-05
3,284	SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning	2017	CIDR	7.5663058e-05
4,049	Resource Elasticity for Large-Scale Machine Learning	2015	SIGMOD	6.9369379e-05
4,079	Flexible Rule-Based Decomposition and Metadata Independence in Modin: A Parallel Dataframe System	2022	VLDB	6.9188052e-05
4,137	Optimizing I/O for Big Array Analytics	2012	VLDB	6.8783832e-05
4,292	Putting Pandas in a Box	2021	CIDR	6.7784325e-05
4,406	Incremental View Maintenance over Array Data	2017	SIGMOD	6.7191598e-05
5,855	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB	6.064726e-05
6,030	The BUDS Language for Distributed Bayesian Machine Learning	2017	SIGMOD	6.0009079e-05
6,276	Profiling R on a Contemporary Processor	2015	VLDB	5.9291284e-05
6,514	A Relational Matrix Algebra and its Implementation in a Column Store	2020	SIGMOD	5.8559163e-05
7,065	Dataset Relationship Management	2019	CIDR	5.7123431e-05
8,430	A Demonstration of Iterative Parallel Array Processing in Support of Telescope Image Analysis	2013	VLDB	5.4263087e-05
9,580	Storing Matrices on Disk: Theory and Practice Revisited	2011	VLDB	5.2528121e-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.0010686205
972	Declarative Networking: Language, Execution and Optimization	2006	SIGMOD	0.00012874501
2,451	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.560157e-05
4,527	Spatio-Temporal Retrieval with RasDaMan	1999	VLDB	6.6449663e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,203	Design and Implementation of a Real-Time Interactive Analytics System for Large Spatio-Temporal Data	2014	VLDB
2	396	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD
3	7,151	Theoretically Optimal and Empirically Efficient R-trees with Strong Parallelizability	2018	VLDB
4	3,062	Adaptive Query Processing on RAW Data	2014	VLDB
5	5,855	Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine	2011	VLDB
6	44	A Comparison of Approaches to Large-Scale Data Analysis	2009	SIGMOD
7	4,137	Optimizing I/O for Big Array Analytics	2012	VLDB
8	6,276	Profiling R on a Contemporary Processor	2015	VLDB
9	6,117	Proactive Re-optimization with Rio	2005	SIGMOD
10	518	Towards a Unified Architecture for in-RDBMS Analytics	2012	SIGMOD