A Native Extension of SQL for Mining Data Streams

Summary: A native SQL extension, ESL, enables stream mining within SQL-based continuous queries with Turing-complete expressive power. It weaves DSMS primitives (windows, buffers, load shedding, indexing) into SQL, avoiding cache mining and adding aggregates, UDFs, approximate queries, concept-drift classifiers, and GUI visualization. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3765
Venue: SIGMOD
Year: 2005
Pagerank: 5.093636e-05
Overall Rank: 12,736 | 12.62%
DOI: 10.1145/1066157.1066271

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Chang Luo (University of California Los Angeles)
2. Hetal Thakkar (University of California Los Angeles)
3. Haixun Wang (IBM)
4. Carlo Zaniolo (University of California Los Angeles)

BibTeX Citation

@inproceedings{luo_sigmod05,
        title = {{A Native Extension of SQL for Mining Data Streams}},
        author = {Luo, Chang and Thakkar, Hetal and Wang, Haixun and Zaniolo, Carlo},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066271},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066271},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
25	NiagaraCQ: A Scalable Continuous Query System for Internet Databases	2000	SIGMOD	0.00054667018
26	Models and Issues in Data Stream Systems	2002	PODS	0.00052982574
167	Monitoring Streams – A New Class of Data Management Applications	2002	VLDB	0.0002757283
193	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.00025964286
980	Integrating Association Rule Mining with Relational Database Systems: Alternatives and Implications	1998	SIGMOD	0.00012844074
4,925	Query Languages and Data Models for Database Sequences and Data Streams	2004	VLDB	6.442888e-05
9,516	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB	5.2567112e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,719	Exploratory Mining via Constrained Frequent Set Queries	1999	SIGMOD
2	7,296	StreaMon: An Adaptive Engine for Stream Query Processing	2004	SIGMOD
3	5,349	Data Stream Query Processing: A Tutorial	2003	VLDB
4	4,907	One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables	2019	SIGMOD
5	7,610	Using Domain-Specific Languages For Analytic Graph Databases	2016	VLDB
6	4,925	Query Languages and Data Models for Database Sequences and Data Streams	2004	VLDB
7	1,274	Querying and Mining Data Streams: You Only Get One Look	2002	SIGMOD
8	150	Query Processing, Resource Management, and Approximation in a Data Stream Management System	2003	CIDR
9	3,515	STREAM: The Stanford Stream Data Manager (Demonstration Description)	2003	SIGMOD
10	6,817	ATLAS: a Small but Complete SQL Extension for Data Mining and Data Streams	2003	VLDB