SQL for Web Nerds | Search for a title, author or keyword | ||||||||
SQL for Web Nerds by Philip Greenspun. This book was written for students at MIT who have access to MIT Web/db development systems. In this book we're trying to demonstrate how the concurrency control and transaction management capabilities of the RDBMS enable the construction of powerful reliable Web services. From an application programmer's point of view, the biggest innovation in the relational database is that one uses a declarative query language, SQL (an acronym for Structured Query Language and pronounced "ess-cue-el" or "sequel"). Most computer languages are procedural. The programmer tells the computer what to do, step by step, specifying a procedure. In SQL, the programmer says "I want data that meet the following criteria" and the RDBMS query planner figures out how to get it. There are two advantages to using a declarative language. The first is that the queries no longer depend on the data representation. The RDBMS is free to store data however it wants. The second is increased software reliability. It is much harder to have "a little bug" in an SQL query than in a procedural program. Generally it either describes the data that you want and works all the time or it completely fails in an obvious way.
|
|||||||||
SQL for Web Nerds | Disclaimer: this link points to content provided by other sites. |