Relational Database Programming

Database developers don't know how to write good code. Careers are damaged and opportunities are missed the world over because of developers applying the same techniques to database applications as they do to user-interface and other types of programming. Two Styles of Database Development aims to change all that by showing a different way of thinking can lead to stunning improvements in application speed and performance. Too many universities teach a wrong approach to database programming. Two Styles of Database Development aims to overcome that disadvantage by showing database programming done right. Directly addresses the ongoing demand for applications that run fasterProvides readers a competitive advantage over their unread peers

Compares two common architectures used in applications Shows the performance advantages of set-based development Solves example problems using both approaches

Autorentext
Stefan Ardeleanu was born in Bucharest, Romania in 1967. He graduated Math and Philosophy, and he was a math teacher for 10 years. Then he began a career in software development. He felt attracted by databases from the beginning, so his entire career in software industry is related to databases, and especially to developing applications that run on them. Stefan has many years' experience in systems such as Oracle, SQL Server, DB2, and PostgreSQL. He has experience in OLTP and data warehousing, and with replication systems. Stefan is a passionate SQL guy, a database trainer, and he has delivered courses on Oracle products as an Oracle partner, especially database development courses and business intelligence courses. Stefan has published works in both Romanian and English.

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