OLAP EXTENSIONS TO SQL
There are a set of proposed enhancements to SQL to enable some OLAP functions to be performed. The SQL standards authority is aware of the importance of data warehousing to industry generally and is keen to rise to the challenge that it brings to the state of database technology. I describe here the major proposals in outline form. The requirements and the proposed solutions have been well thought through. The details (syntax, etc.) are still being tested.
Moving averages. It will be possible to specify the number of rows to be included in the moving average. For instance, in a result set containing monthly sales, we can create moving averages for any number of months. We can even look ahead in the data to, for instance, ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
