Storing and Querying Tree-Structured Records in Dremel
Summary: Formal data model and query language for tree-structured records in Dremel (nested relations, leaf-valued attributes, repeated attributes). Columnar processing of Dremel's filter/aggregate queries via repetition context and semi-flattening achieves linear-time complexity in the size of relevant data. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Foto N. Afrati (National Technical University of Athens)
- 2. Dan Delorey (Google)
- 3. Mosha Pasumansky (Google)
- 4. Jeffrey D. Ullman (Stanford University)
BibTeX Citation
@article{afrati_vldb14,
title = {{Storing and Querying Tree-Structured Records in Dremel}},
author = {Afrati, Foto N. and Delorey, Dan and Pasumansky, Mosha and Ullman, Jeffrey D.},
journal = {PVLDB},
series = {{VLDB} '14},
volume = {7},
number = {11},
pages = {1131--1142},
doi = {10.14778/2732967.2732970},
url = {https://doi.org/10.14778/2732967.2732970},
year = {2014}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,453 | Dremel: A Decade of Interactive SQL Analysis at Web Scale | 2020 | VLDB | 0.00010742227 |
| 6,377 | Scalable Querying of Nested Data | 2021 | VLDB | 5.8931544e-05 |
| 6,385 | Exploiting Common Patterns for Tree-Structured Data | 2017 | SIGMOD | 5.8899875e-05 |
| 10,771 | Nested Parquet Is Flat, Why Not Use It? How To Scan Nested Data With On-the-Fly Key Generation and Joins | 2025 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 51 | Dremel: Interactive Analysis of Web-Scale Datasets | 2010 | VLDB | 0.0004291425 |
| 362 | Storing and Querying Ordered XML Using a Relational Database System | 2002 | SIGMOD | 0.00020125068 |
| 538 | Non First Normal Form Relations To Represent Hierarchically Organized Data | 1984 | PODS | 0.00016919845 |
| 607 | F1: A Distributed SQL Database That Scales | 2013 | VLDB | 0.00015800238 |
| 1,976 | On Line Processing of Compacted Relations | 1982 | VLDB | 9.3644331e-05 |
| 2,198 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 8.9680897e-05 |
| 2,494 | Supporting Flat Relations by a Nested Relational Kernel | 1987 | VLDB | 8.5053229e-05 |
| 2,701 | Possibilities and Limitations of Using Flat Operators in Nested Algebra Expressions | 1988 | PODS | 8.240179e-05 |
| 3,917 | Tree Logical Classes for Efficient Evaluation of XQuery | 2004 | SIGMOD | 7.0182992e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,615 | Relational Queries in a Domain Based DBMS | 1983 | SIGMOD |
| 2 | 8,682 | Columnar Formats for Schemaless LSM-based Document Stores | 2022 | VLDB |
| 3 | 124 | A Query Language and Optimization Techniques for Unstructured Data | 1996 | SIGMOD |
| 4 | 95 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 5 | 2,102 | The Tree Property Is Fundamental For Query Processing (Extended Abstract) | 1982 | PODS |
| 6 | 12,555 | Relational-Style XML Query | 2008 | SIGMOD |
| 7 | 4,107 | Processing Queries on Tree-Structured Data Efficiently | 2006 | PODS |
| 8 | 5,259 | An Implementation for Nested Relational Databases | 1988 | VLDB |
| 9 | 2,198 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD |
| 10 | 51 | Dremel: Interactive Analysis of Web-Scale Datasets | 2010 | VLDB |