Ruminating about Relational Databases and Algorithms
A central value add of modeling databases for analytical purposes and speed is that you can restore the sanity, often lost in the source system, that comes from using good keys in each table. But what exactly does it mean for a key to be “good”? Key Properties Keys, they refer to “something” that is … Read more
This page maintains my list of recommended reading if you are interested in learning about databases. This is very much work in progress – so check back here later for more. Query Optimisation Dan Tow: “Generating Optimal Execution Plans” A great resource to answer the question: What query plan do you want to get? Anjo … Read more