The ATLaS system and its powerful database language based on simple extensions of SQL

A lack of power and extensibility in their query languages has seriously limited the generality of DBMSs and hampered their ability to support new applications domains, such as datamining. In this paper, we solve this problem by stream-oriented aggregate functions and generalized table functions definable by users in the SQL language itself-rather than in an external programming language. These simple extensions turn SQL into a powerful database language, Which can express a wide range of applications, including recursive queries, ROLAP aggregates, time-series queries, stream-oriented processing, and datamining functions.