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,135 | Dremel: A Decade of Interactive SQL Analysis at Web Scale | 2020 | VLDB | 0.00011891907 |
| 6,438 | Scalable Querying of Nested Data | 2021 | VLDB | 5.7851309e-05 |
| 6,518 | Exploiting Common Patterns for Tree-Structured Data | 2017 | SIGMOD | 5.757997e-05 |
| 11,191 | Nested Parquet Is Flat, Why Not Use It? How To Scan Nested Data With On-the-Fly Key Generation and Joins | 2025 | SIGMOD | 4.9793485e-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 |
|---|---|---|---|---|
| 49 | Dremel: Interactive Analysis of Web-Scale Datasets | 2010 | VLDB | 0.00043160717 |
| 374 | Storing and Querying Ordered XML Using a Relational Database System | 2002 | SIGMOD | 0.00019707844 |
| 549 | Non First Normal Form Relations To Represent Hierarchically Organized Data | 1984 | PODS | 0.00016563595 |
| 617 | F1: A Distributed SQL Database That Scales | 2013 | VLDB | 0.00015555815 |
| 2,012 | On Line Processing of Compacted Relations | 1982 | VLDB | 9.1867589e-05 |
| 2,154 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 8.9474855e-05 |
| 2,531 | Supporting Flat Relations by a Nested Relational Kernel | 1987 | VLDB | 8.3351949e-05 |
| 2,751 | Possibilities and Limitations of Using Flat Operators in Nested Algebra Expressions | 1988 | PODS | 8.0562002e-05 |
| 4,000 | Tree Logical Classes for Efficient Evaluation of XQuery | 2004 | SIGMOD | 6.8610702e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,686 | Relational Queries in a Domain Based DBMS | 1983 | SIGMOD |
| 2 | 8,840 | Columnar Formats for Schemaless LSM-based Document Stores | 2022 | VLDB |
| 3 | 130 | A Query Language and Optimization Techniques for Unstructured Data | 1996 | SIGMOD |
| 4 | 97 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 5 | 2,142 | The Tree Property Is Fundamental For Query Processing (Extended Abstract) | 1982 | PODS |
| 6 | 12,845 | Relational-Style XML Query | 2008 | SIGMOD |
| 7 | 4,189 | Processing Queries on Tree-Structured Data Efficiently | 2006 | PODS |
| 8 | 5,378 | An Implementation for Nested Relational Databases | 1988 | VLDB |
| 9 | 2,154 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD |
| 10 | 49 | Dremel: Interactive Analysis of Web-Scale Datasets | 2010 | VLDB |