Abstract: Publisher Summary
Online analytical processing (OLAP), functions ADD the ROLLUP and CUBE extensions to the GROUP BY Clause. ROLLUP and CUBE are often referred to as supergroups. The grouping operators are used to do the basic reporting. They can be written in older standard SQL using GROUP BY and UNION operators. The compiler writers can reuse some of the code they already have, and the programmers can reuse some of the mental models they already have. In the case of SQL, it also means that the results of these new features will be SQL tables and not a new kind of data structure. The GROUPING SET ( ) is shorthand in SQL-99 for a series of UNIONed queries that are common in reports. Furthermore, there is a problem with all of the new grouping functions. They will generate NULLs for each dimension at the subtotal levels.
Publication Year: 2006
Publication Date: 2006-01-01
Language: en
Type: book-chapter
Indexed In: ['crossref']
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot