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.3542169e-05
Overall Rank: 8,324 | 44.04%
DOI: 10.14778/3015270.3015271

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,233	Fine-grained Concept Linking using Neural Networks in Healthcare	2018	SIGMOD	5.8420918e-05
8,271	Sigma Workbook: A Spreadsheet for Cloud Data Warehouses	2022	VLDB	5.3643259e-05
11,577	CohortNet: Empowering Cohort Discovery for Interpretable Healthcare Analytics	2024	VLDB	4.9793485e-05
12,148	Data Pipelines for User Group Analytics	2019	SIGMOD	4.9793485e-05
12,257	Effective Temporal Dependence Discovery in Time Series Data	2018	VLDB	4.9793485e-05
13,832	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.00068998927
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00064031282
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.0005158963
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.000392237
214	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00024656893
323	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.0002100085
873	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.00013338838
1,089	Incremental Maintenance of Externally Materialized Views	1996	VLDB	0.00012088658
1,210	Processing a Trillion Cells per Mouse Click	2012	VLDB	0.00011527605
1,930	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.351027e-05

Semantically Similar Papers

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