A new window Clause for SQL plus

Window queries are important analytical tools for ordered data and have been researched both in streaming and stored data environments. By incorporating ideas for window queries from existing streaming and stored data systems, we propose a new window syntax that makes a wide range of window queries easier to write and optimize. We have implemented this new window syntax in SQL++, an SQL extension that supports querying semistructured data, on top of AsterixDB, a Big Data Management System, thus allowing us to process window queries over large datasets in a parallel and efficient manner.

Automated summary

Window queries are valuable tools for analyzing ordered data, and have been studied in both streaming and stored data environments. We propose a new window syntax that incorporates ideas from existing systems, making a diverse range of window queries easier to write and optimize. By implementing this syntax in SQL++ on top of AsterixDB, we can efficiently process window queries over large datasets in a parallel manner.