School of Computer Science and Technology, Heilongjiang University, and Key Laboratory of Database and Parallel Computing, Harbin, China, 150080

---

Abstract—Estimating the number of distinct values in a data stream is a vital problem with many applications such as complex join query over multiple data streams. In this paper, we focus on the continuous and periodic distinct values estimation over sliding windows. We propose a compound sliding window model to compute the distinct values over basic sliding windows in an incremental way. LDV, HDV and AHDV are the three algorithms that are based on compound sliding windows. The basic idea behind the compound sliding windows is to organize the basic windows into a Hash table according to distinct values. Whenever a new data arrives at the data stream, it is inserted into a basic window. Once the basic window is full, a scan using distinct values is executed and the distinct values number is updated incrementally. Theoretical analysis and experiment results show that the distinct values estimation algorithms based on compound sliding windows have a great performance benefits.

Index Terms—Data stream, basic window, compound sliding window, distinct values estimation.

[PDF]

Cite: Yingli Zhong, Jinghua Zhu, Meirui Ren, Yan Yang, "Estimation of the Number of Distinct Values over Data Stream Based on Compound Sliding Window," Journal of Software vol. 8, no. 1, pp. 19-24, 2013.