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...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[Place of publication not identified], New York, NY
Apress, Distributed to the Book trade worldwide by Springer Science+Business Media
2016
|
| Series: | The expert's voice in databases
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 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