Keys, Foreign Keys, and Relational Theory (Paperback)

Chris Date

ISBN 10: 163462405X / ISBN 13: 9781634624053

Editore: Technics Publications, 2023

Riguardo questo articolo

Paperback. Keys and foreign keys play a crucial role in relational databases-keys identify the objects of interest, and foreign keys knit those objects together. The basic idea couldn't be simpler. As so often, however, the devil is in the detail . The fact is, these concepts aren't quite as straightforward as they might seem on first acquaintance-or, at least, such would appear to be the case, if the literature is anything to go by. In this one of a kind book, noted database author C. J. Date traces the somewhat checkered history of the key and foreign key concepts, shedding some light on what turns out to be, on occasion, a surprisingly murky subject and explaining in detail what proper support should look like in true relational products. Topics covered include a detailed look at the pertinent theory; a critical review of the historical development of these ideas; and a couple of important case studies, one having to do with the SQL standard and one with the IBM DB2 product family. No serious database professional can afford to be without this book. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Codice articolo 9781634624053

Dati bibliografici

• Titolo: Keys, Foreign Keys, and Relational Theory (Paperback)
• Editore: Technics Publications
• Data di pubblicazione: 2023
• Lingua: Inglese
• ISBN 10: 163462405X
• ISBN 13: 9781634624053
• Rilegatura: Paperback
• Condizione: new

Descrizione articolo

Riassunto

Keys and foreign keys play a crucial role in relational databases—keys identify the objects of interest, and foreign keys knit those objects together. The basic idea couldn’t be simpler. As so often, however, the devil is in the detail ... The fact is, these concepts aren’t quite as straightforward as they might seem on first acquaintance—or, at least, such would appear to be the case, if the literature is anything to go by. In this one of a kind book, noted database author C. J. Date traces the somewhat checkered history of the key and foreign key concepts, shedding some light on what turns out to be, on occasion, a surprisingly murky subject and explaining in detail what proper support should look like in true relational products. Topics covered include a detailed look at the pertinent theory; a critical review of the historical development of these ideas; and a couple of important case studies, one having to do with the SQL standard and one with the IBM DB2 product family. No serious database professional can afford to be without this book.