Relational Database Programming A Set-Oriented Approach

Learn the best way of writing code to run inside a relational database. This book shows how a holistic and set-oriented approach to database programming can far exceed the performance of the row-by-row model that is too often used by developers who haven’t been shown a better way. Two styles of prog...

Descripción completa

Detalles Bibliográficos
Autor principal: Ardeleanu, Stefan. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2016.
Edición:1st ed. 2016.
Colección:The expert's voice in databases
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630182406719
Tabla de Contenidos:
  • Introduction
  • 1. The Concept of Style
  • 2. SQL: Beauty and the Beast!
  • 3. A Holistic Vision Against the Data
  • 4. Data by Set or by Row?
  • 5. Data Transfer Paradigm
  • 6. The Challenge from Scalar Functions
  • 7. Writing SQL versus Writing Procedurally
  • 8. Row Triggers and the Need for Atomic Solutions
  • 9. Final Reflections and Thoughts.