Relational Database Programming A Set-Oriented Approach /

• Main Author: Ardeleanu, Stefan (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Subjects: Computer science.; Computer programming.; Database management.; Computer Science.; Programming Techniques.; Database Management.

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...

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.