10.6. Sharing SQL Data
There are two simple truths that we all know about the environment that our data lives in. The first truth is that no enterprise runs on one and only one database or data source today. Any enterprise of medium to large size will have desktop databases, department-level servers, enterprise-level servers, and data warehouse servers.
If you do not have different platforms, then you are doing something wrong. While virtually all databases today run some version of SQL, they do not implement it in the same way. The same hardware and software that runs a data warehouse would be overkill for a departmental server doing OLTP.
The first part of this chapter was concerned with legacy file systems, assumed to be on magnetic tapes ...
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.
