Creating Efficient SQL – The De-normalize Transpose
BibTeX
@MISC{_creatingefficient,
author = {},
title = {Creating Efficient SQL – The De-normalize Transpose},
year = {}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
Normalization and warehousing are battle cries of two waring factions. Although vertical or row-wise designs ultimately minimize storage access and retrieval time, the law of the relational model precludes simultaneous access from more than one table row. Quite often, we desire knowledge of two variables for the same aggregate observation, when performing high level arithmetic or reporting spreadsheet like tablature. This article presents an efficient query method for turning rows into columns at SQL run time, which farmer Jack uses for his bean quality audit policy, and discusses some finer points which make the transposition process database system independent.
Keyphrases
de-normalize transpose efficient sql sql run time transposition process database system high level aggregate observation retrieval time battle cry storage access efficient query method finer point table row bean quality audit policy row-wise design relational model precludes simultaneous access
