Matches in SemOpenAlex for { <https://semopenalex.org/work/W1437370899> ?p ?o ?g. }
Showing items 1 to 64 of
64
with 100 items per page.
- W1437370899 endingPage "554" @default.
- W1437370899 startingPage "539" @default.
- W1437370899 abstract "This chapter focuses on advanced grouping, windowed aggregation, and Online Analytic Processing (OLAP) in SQL. As OLAP is concerned with summarizing and reporting data, the schema designs and common operations are very different from the usual SQL queries. Until recent changes in SQL, OLAP queries had to be done with special OLAP-centric languages, such as Microsoft's Multidimensional Expressions (MDX). OLAP functions add the ROLLUP and CUBE extensions to the GROUP BY clause. The ROLLUP and CUBE are often referred to as super-groups, which can be written in older Standard SQL by using GROUP BY and UNION operators. The GROUPING SET(<column list>) is shorthand in SQL-99 for a series of UNION-ed queries that are common in reports. A ROLLUP group is an extension to the GROUP BY clause in SQL-99 that produces a result set that contains subtotal rows in addition to the regular grouped rows. Subtotal rows are super-aggregate rows that contain further aggregates whose values are derived by applying the same column functions that were used to obtain the grouped rows. The CUBE super-group is the other SQL-99 extension to the GROUP BY clause that produces a result set containing all the subtotal rows of a ROLLUP aggregation and crosstabulation rows. Crosstabulation rows are additional “super-aggregate” rows that summarize across columns if the data was represented as a spreadsheet. The window clause is also called the OVER() clause informally that has three subclauses including partitioning, ordering, and aggregation grouping or window frame." @default.
- W1437370899 created "2016-06-24" @default.
- W1437370899 creator A5066287408 @default.
- W1437370899 date "2011-01-01" @default.
- W1437370899 modified "2023-09-26" @default.
- W1437370899 title "Advanced Grouping, Windowed Aggregation, and OLAP in SQL" @default.
- W1437370899 doi "https://doi.org/10.1016/b978-0-12-382022-8.00030-2" @default.
- W1437370899 hasPublicationYear "2011" @default.
- W1437370899 type Work @default.
- W1437370899 sameAs 1437370899 @default.
- W1437370899 citedByCount "0" @default.
- W1437370899 crossrefType "book-chapter" @default.
- W1437370899 hasAuthorship W1437370899A5066287408 @default.
- W1437370899 hasConcept C104140500 @default.
- W1437370899 hasConcept C126042441 @default.
- W1437370899 hasConcept C135572916 @default.
- W1437370899 hasConcept C135598885 @default.
- W1437370899 hasConcept C159985019 @default.
- W1437370899 hasConcept C177264268 @default.
- W1437370899 hasConcept C192562407 @default.
- W1437370899 hasConcept C199360897 @default.
- W1437370899 hasConcept C201932085 @default.
- W1437370899 hasConcept C2780551164 @default.
- W1437370899 hasConcept C41008148 @default.
- W1437370899 hasConcept C4679612 @default.
- W1437370899 hasConcept C510870499 @default.
- W1437370899 hasConcept C76155785 @default.
- W1437370899 hasConcept C77088390 @default.
- W1437370899 hasConcept C78168278 @default.
- W1437370899 hasConceptScore W1437370899C104140500 @default.
- W1437370899 hasConceptScore W1437370899C126042441 @default.
- W1437370899 hasConceptScore W1437370899C135572916 @default.
- W1437370899 hasConceptScore W1437370899C135598885 @default.
- W1437370899 hasConceptScore W1437370899C159985019 @default.
- W1437370899 hasConceptScore W1437370899C177264268 @default.
- W1437370899 hasConceptScore W1437370899C192562407 @default.
- W1437370899 hasConceptScore W1437370899C199360897 @default.
- W1437370899 hasConceptScore W1437370899C201932085 @default.
- W1437370899 hasConceptScore W1437370899C2780551164 @default.
- W1437370899 hasConceptScore W1437370899C41008148 @default.
- W1437370899 hasConceptScore W1437370899C4679612 @default.
- W1437370899 hasConceptScore W1437370899C510870499 @default.
- W1437370899 hasConceptScore W1437370899C76155785 @default.
- W1437370899 hasConceptScore W1437370899C77088390 @default.
- W1437370899 hasConceptScore W1437370899C78168278 @default.
- W1437370899 hasLocation W14373708991 @default.
- W1437370899 hasOpenAccess W1437370899 @default.
- W1437370899 hasPrimaryLocation W14373708991 @default.
- W1437370899 hasRelatedWork W1437370899 @default.
- W1437370899 hasRelatedWork W2055526252 @default.
- W1437370899 hasRelatedWork W2092428805 @default.
- W1437370899 hasRelatedWork W2120079907 @default.
- W1437370899 hasRelatedWork W2216243182 @default.
- W1437370899 hasRelatedWork W2377040749 @default.
- W1437370899 hasRelatedWork W2769125116 @default.
- W1437370899 hasRelatedWork W310976110 @default.
- W1437370899 hasRelatedWork W965083046 @default.
- W1437370899 hasRelatedWork W2281295632 @default.
- W1437370899 isParatext "false" @default.
- W1437370899 isRetracted "false" @default.
- W1437370899 magId "1437370899" @default.
- W1437370899 workType "book-chapter" @default.