Oracle AI Database 26ai(23.26.4): Streaming Windowing Table Functions
Analyzing time-based data is a common requirement in modern database applications. Oracle AI Database 26ai(RU 23.26.4) introduces four SQL streaming windowing table functions that simplify this type of analysis by dividing table rows into time-based windows. These functions are: TUMBLE: Divides rows into consecutive, non-overlapping time windows. HOP: Creates sliding time windows that can overlap or have gaps. CUMULATE: Creates expanding time windows with a common starting point. SESSIONS: Groups rows into sessions based on the time interval between consecutive events. Each function accepts a datetime column and interval parameters to determine how rows are assigned to windows. The returned result includes two additional columns, WINDOW_START and WINDOW_END , which identify the time boundaries of each window. In this article, we will explore how these four functions work and demonstrate their practical applications using customer activity data. 1. How Streaming Windowing Fun...