8.5. Data Mining for Auxiliary Tables

We do not always know what values we want to add to a lookup table. Very often, we need to do some data mining in our historical data to discover rules we did not know.

If you watch the Food Channel on cable or just like Memphis-style barbeque, you know the name Corky’s. The chain was started in 1984 in Memphis by Don Pelts and has grown by franchise at a steady rate ever since. They sell a small menu of 25 items by mail order or from their website (www.corkysbbq.com) and ship the merchandise in special boxes, sometimes using dry ice. Most of the year, their staff can handle the orders. But at Christmastime, they have the problem of success.

Their packing operation consists of two lines. At the start of the ...

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.