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: 11575
Venue: VLDB
Year: 2017
Pagerank: 5.4736785e-05
Overall Rank: 8,176 | 43.91%
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,115	Fine-grained Concept Linking using Neural Networks in Healthcare	2018	SIGMOD	5.9709282e-05
8,510	Sigma Workbook: A Spreadsheet for Cloud Data Warehouses	2022	VLDB	5.4119882e-05
11,244	CohortNet: Empowering Cohort Discovery for Interpretable Healthcare Analytics	2024	VLDB	5.093636e-05
11,848	Data Pipelines for User Group Analytics	2019	SIGMOD	5.093636e-05
11,959	Effective Temporal Dependence Discovery in Time Series Data	2018	VLDB	5.093636e-05
13,519	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.00069513174
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.0006312782
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
207	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00025088003
324	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.00021200835
870	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.0001350293
1,091	Incremental Maintenance of Externally Materialized Views	1996	VLDB	0.00012226764
1,225	Processing a Trillion Cells per Mouse Click	2012	VLDB	0.00011590013
1,894	Optimizing Queries On Compressed Bitmaps	2000	VLDB	9.5268052e-05

Semantically Similar Papers

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