Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL
Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language, like SQL. As a result they are not fully using the power a...
Autor principal: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Amsterdam ; Boston :
Elsevier / Morgan Kaufmann
c2008.
|
Edición: | 1st edition |
Colección: | The Morgan Kaufmann Series in Data Management Systems
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626933606719 |
Sumario: | Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language, like SQL. As a result they are not fully using the power and capability inherent in SQL and that translates into writing more code than they need to write, more complex code than is needed, and ultimately lower productivity. Thinking in sets reveals the conceptual shift these programmers need to make. Through detailed examples and clear explanation |
---|---|
Notas: | Includes index. |
Descripción Física: | 1 online resource (383 p.) |
ISBN: | 9781281172129 9786611172121 9780080557526 |