About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
Proceedings - International Conference on Data Engineering
Paper
The ATLaS system and its powerful database language based on simple extensions of SQL
Abstract
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.