Books by splitShops

Domains and Types in Relational Theory and SQL - Paperback

$53.95

Tax not included.
Shipping calculated at checkout.

In stock

Order Note:

Purchase Information

Shipping charges, applicable taxes, the final order total, and available payment methods are shown during checkout before payment. Delivery timing varies by item and fulfillment origin. Standard U.S. returns are by mail for eligible new, unopened items within 30 days of carrier delivery. Customers pay standard return shipping; there is no restocking fee. Approved refunds are issued within 5 business days after the return is received and inspected. Standard exchanges are not offered.

Cindi Book items have a flat $9.99 shipping charge. Shopify Collective items use shipping rates set by the supplier. Orders containing items from different fulfillment sources may include more than one shipping charge. Your full shipping total is shown at checkout before payment.

Return eligibility is subject to the full policy. Opened, read, or unsealed books with broken seals or visible wear are final sale. Digital downloads, gift cards, and personalized products are non-refundable. Original shipping charges are not refunded for standard returns. Contact us within 7 days of delivery about damaged, defective, or incorrect items.

by Chris Date (Author)

What's a domain? What's a type? The original version of the relational model (defined by Codd in 1969) had domains and not types. The original version of the SQL standard (defined by committee in 1986, but based on work done by Boyce and Chamberlin et al. in the 1970s) had types and not domains. Later, Codd added types and SQL added domains. But no two of these constructs-domains per Codd, types per Codd, domains per SQL, types per SQL-are the same thing! Other researchers, designers, and implementers then got into the act with further definitions of their own, and the picture became, and remains, more confused than ever. This book is an attempt to clear the air. To be specific, it argues that:

    Domains per Codd aren't really domains in the mathematical sense but are much closer to types in the computing sense, and types per Codd don't belong in the model at all. Types per SQL are really several different concepts all mixed together in confusing ways, and domains per SQL are just a red herring. Properly understood, domains and types are the same thing after all.

The book justifies these claims by describing and analyzing the pertinent aspects of both SQL and the relational model in detail.

Number of Pages: 290
Dimensions: 0.61 x 9.25 x 7.5 IN
Publication Date: September 02, 2024

Pay with

  • Amazon
  • Amazon
  • American Express
  • Apple Pay
  • Diners Club
  • Discover
  • Google Pay
  • Mastercard
  • PayPal
  • Shop Pay
  • Visa

Available payment methods and your final total are shown at checkout before payment.

$53.95