O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required