Optimizing Video Selection LIMIT Queries With Commonsense Knowledge

Summary: Introduces Paine: a cheap, lossy-index plus probabilistic commonsense models that patch missed targets and prioritize predicate-related videos for LIMIT video-selection queries. Cuts expensive detector scans dramatically—up to 97.8% fewer videos; even zero-content commonsense models give ~75% improvement while keeping index construction costs low. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13415
Venue: VLDB
Year: 2024
Pagerank: 4.4720866e-05
Overall Rank: 8,646 | 39.92%
DOI: 10.14778/3654621.3654639

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,394	MAST: Towards Efficient Analytical Query Processing on Point Cloud Data	2025	SIGMOD	4.1905499e-05
10,481	Approximating Opaque Top-k Queries	2025	SIGMOD	4.1905499e-05
10,532	Scalable Complex Event Processing on Video Streams	2025	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
66	Spark SQL: Relational Data Processing in Spark	2015	SIGMOD	0.00061707583
101	The Case for Learned Index Structures	2018	SIGMOD	0.00049778866
317	NoScope: Optimizing Neural Network Queries over Video at Scale	2017	VLDB	0.0002798145
332	Accelerating Machine Learning Inference with Probabilistic Predicates	2018	SIGMOD	0.00027173479
407	Database Cracking	2007	CIDR	0.00023941779
414	A Fast Index for Semistructured Data	2001	VLDB	0.00023801668
694	BlazeIt: Optimizing Declarative Aggregation and Limit Queries for Neural Network-Based Video Analytics	2020	VLDB	0.00018031141
1,390	MIRIS: Fast Object Track Queries in Video	2020	SIGMOD	0.00012242018
3,291	Jointly Optimizing Preprocessing and Inference for DNN-based Visual Analytics	2021	VLDB	7.2607192e-05
3,610	EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views	2022	SIGMOD	6.919859e-05
4,909	A Method for Optimizing Opaque Filter Queries	2020	SIGMOD	5.8354189e-05
6,868	Extract-Transform-Load for Video Streams	2023	VLDB	4.8982283e-05
9,092	Challenges and Techniques for Effective and Efficient Similarity Search in Large Video Databases	2008	VLDB	4.3934714e-05
9,301	Controlled Intentional Degradation in Analytical Video Systems	2022	SIGMOD	4.3558097e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,865	OTIF: Efficient Tracker Pre-processing over Large Video Datasets	2022	SIGMOD	5.8627966e-05
4,663	Towards Effective Indexing for Very Large Video Sequence Database	2005	SIGMOD	6.0066508e-05
5,168	FiGO: Fine-Grained Query Optimization in Video Analytics	2022	SIGMOD	5.6446115e-05
10,947	Predictive and Near-Optimal Sampling for View Materialization in Video Databases	2024	SIGMOD	4.1905499e-05
4,232	Efficient and Cost-effective Techniques for Browsing and Indexing Large Video Databases	2000	SIGMOD	6.3324137e-05
4,947	Evaluating Temporal Queries Over Video Feeds	2021	SIGMOD	5.8107138e-05
317	NoScope: Optimizing Neural Network Queries over Video at Scale	2017	VLDB	0.0002798145
3,599	Spatial and Temporal Constrained Ranked Retrieval over Videos	2022	VLDB	6.92963e-05
11,064	Optimizing Video Queries with Declarative Clues	2024	VLDB	4.1905499e-05
11,275	PAINE Demo: Optimizing Video Selection Queries With Commonsense Knowledge	2023	VLDB	4.1905499e-05