Cohort Query Processing

Summary: Extends SQL with three new operators to support cohort analysis on large user activity tables. Three evaluation schemes are explored: two non-intrusive and a columnar variant with cohort-specific optimizations; experiments show the columnar approach outperforms the others. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h1765c33d295e36dc
Venue: VLDB
Year: 2017
Pagerank: 5.3339863e-05
Overall Rank: 8,345 | 44.07%
DOI: 10.14778/3015270.3015271
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

1. Dawei Jiang (National University of Singapore; Zhejiang University)
2. Qingchao Cai (National University of Singapore)
3. Gang Chen (Zhejiang University)
4. H. V. Jagadish (University of Michigan)
5. Beng Chin Ooi (National University of Singapore)
6. Kian-Lee Tan (National University of Singapore)
7. Anthony K. H. Tung (National University of Singapore)

BibTeX Citation

@article{jiang_vldb17,
        title = {{Cohort Query Processing}},
        author = {Jiang, Dawei and Cai, Qingchao and Chen, Gang and Jagadish, H. V. and Ooi, Beng Chin and Tan, Kian-Lee and Tung, Anthony K. H.},
        journal = {PVLDB},
        series = {{VLDB} '17},
        volume = {10},
        number = {1},
        doi = {10.14778/3015270.3015271},
        url = {https://doi.org/10.14778/3015270.3015271},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,246	Fine-grained Concept Linking using Neural Networks in Healthcare	2018	SIGMOD	5.8200726e-05
8,294	Sigma Workbook: A Spreadsheet for Cloud Data Warehouses	2022	VLDB	5.344057e-05
11,631	CohortNet: Empowering Cohort Discovery for Interpretable Healthcare Analytics	2024	VLDB	4.9605343e-05
12,197	Data Pipelines for User Group Analytics	2019	SIGMOD	4.9605343e-05
12,306	Effective Temporal Dependence Discovery in Time Series Data	2018	VLDB	4.9605343e-05
13,877	Cohort Analysis with Ease	2018	SIGMOD	-

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00068985264
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00063972112
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.0005146739
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00039323387
214	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00024576033
324	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.00020934349
871	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.00013313281
1,088	Incremental Maintenance of Externally Materialized Views	1996	VLDB	0.00012066587
1,212	Processing a Trillion Cells per Mouse Click	2012	VLDB	0.00011493478
1,939	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.3280163e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,909	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
2	1,296	From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System	2015	SIGMOD
3	4,700	Continuous Analytics: Rethinking Query Processing in a Network-Effect World	2009	CIDR
4	12,785	CODS: Evolving Data Efficiently and Scalably in Column Oriented Databases	2010	VLDB
5	1,633	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD
6	2,606	Robust Query Processing in Co-Processor-accelerated Databases	2016	SIGMOD
7	712	Sequence Query Processing	1994	SIGMOD
8	5,598	Efficient Computation of Multiple Group By Queries	2005	SIGMOD
9	12,306	Effective Temporal Dependence Discovery in Time Series Data	2018	VLDB
10	13,877	Cohort Analysis with Ease	2018	SIGMOD