Chapter 3. Data Access and Records
THE RELATIONAL MODEL and the SQL standards are not concerned with physical implementations or access methods used by actual products. Standard SQL wants to keep the language portable and predictable, no matter what the internal implementations. However, code eventually has to run on hardware, and those platforms are totally different. Programmers are mildly concerned with tricks to tune their SQL.
Job titles in IT vary with each fad, but somewhere you have a physical DBA who is very concerned with how a database is configured for performance.
In the 1980s, we attempted to create database machines such as the Britton-Lee IDM, but they never really caught on (”Database Machines: An Idea Whose Time Passed? A Critique ...
Get Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
