Domains and Types in Relational Theory and SQL

Domains and Types in Relational Theory and SQL

Chris Date

47,07 €
IVA incluido
Disponible
Editorial:
Technics Publications
Año de edición:
2024
ISBN:
9781634625449
47,07 €
IVA incluido
Disponible

Selecciona una librería:

  • Librería Samer Atenea
  • Librería Aciertas (Toledo)
  • Kálamo Books
  • Librería Perelló (Valencia)
  • Librería Elías (Asturias)
  • Donde los libros
  • Librería Kolima (Madrid)
  • Librería Proteo (Málaga)

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. 

Artículos relacionados

  • Poetry Is Our Ministry to Touch the Heart
    Anelda Lukesia Ballard / Jean Anelda Scott
    Poetry is Our Ministry to Touch the Heart, was birthed when Anelda L. Ballard became ill. God spoke to her in a dream and said 'pick up a pen and write' by being obedient this book was written through the Holy Spirit. Anelda and her mother Jean A. Scott believes that God’s wants to heal a hurting heart. This book will inspire you and encourage you to never give up hope. Jesu...
    Disponible

    11,12 €

  • I soldati lunghi
    Pierluigi Romeo di Colloredo Mels
    Il 24 maggio 1915 il Regno d’Italia entrò nella Grande Guerra, che si sarebbe dimostrata il momento più alto e tragico della sua storia, a poco più di cinquant’anni dalla sua unificazione.In quella lotta tremenda durata quattro anni, la Brigata Granatieri di Sardegna , con i suoi due valorosi Reggimenti, i più antichi del Regio Esercito scrisse, nel grande quadro della guerra d...
    Disponible

    32,59 €

  • Five Beneath Philly
    Susan Bandy / Tom Richmond
    Allen Williams plans to make something of his life and escape South Philly and the work at Cross Brothers’ Meat Packing Plant. He prepares himself with excellent grades and an upcoming full-ride scholarship to climb out of South Philly forever. Then fate changes his whole world. An only son in a family of six, Allen suddenly finds himself responsible for his mother, grandmother...
    Disponible

    18,28 €

  • Forms
    Sharon Welch
    I am an award-winning artist and my works hang in private residences, community hospitals, businesses, and restaurants across the US and also abroad.  I live in Pierre, South Dakota. Since 2008 I have owned Sharon Welch Gallery and Studio where I paint and teach classes.  My theory is have fun, remove the fear of failure, experiment and let the child inside of you play.Very oft...
  • Ricordi di una ausiliaria
    Andrea Lombardi / Raffaella Duelli
    Le memorie di Raffaella Duelli, Volontaria nel Battaglione Barbarigo della Decima Flottiglia Mas iniziano con la partenza del Barbarigo da Roma, narrando la lunga marcia del reparto verso il nord, sotto il mitragliamento degli aerei Alleati. Quindi, è descritta vividamente l'ultima battaglia del Barbarigo sul Fronte Sud, dal Senio a Comacchio: gli appunti di Raffaella, giov...
    Disponible

    28,08 €

  • Why Didn’t You Ask?
    Panya Dixon
    From an early occurrence in her childhood to a perilous thirteen-year relationship, Panya Dixon too often suffered from various forms of physical, emotional, and sexual abuse. Conflicted between love and the pain her loved ones brought on her, she consistently had to fight for her life and her will to move on. Why Didn’t You Ask? is an expression of Panya’s truth—her trials, pa...
    Disponible

    20,35 €

Otros libros del autor

  • Database Technology
    Chris Date
    Essentially all truly general purpose database systems today are based on the relational model of data. That model was invented by E. F. ('Ted') Codd in the late 1960s and early 1970s, during his employment at the IBM Research Laboratory in San Jose, California, and it was solidly based on conventional two-valued logic, 2VL. Unfortunately, those same general purpose database sy...
    Disponible

    46,58 €

  • The Relational Model for Database Management Version 2 - A Critical Analysis
    Chris Date
    The relational model of data was invented by one man, E. F. ('Ted') Codd, during his employment in the late 1960s and early 1970s at the IBM Research Laboratory in San Jose, California. Today, virtually all general purpose database systems are based on that model. But those systems are still a long way from perfect-and a major reason for this sorry state of affairs is that they...
    Disponible

    67,03 €

  • E. F. Codd and Relational Theory, Revised Edition
    Chris Date
    E. F. Codd’s relational model of data has been described as one of the three greatest inventions of all time (the other two being agriculture and the scientific method), and his receipt of the 1981 ACM Turing Award, the top award in computer science, for inventing it was thoroughly deserved. The papers in which Codd first described his model were staggering in their originality...
    Disponible

    39,54 €

  • Fifty Years of Relational, and Other Database Writings
    Chris Date
    Fifty years of relational. It’s hard to believe the relational model has been around now for over half a century! But it has-it was born on August 19th, 1969, when Codd’s first database paper was published. And Chris Date has been involved with it for almost the whole of that time, working closely with Codd for many years and publishing the very first, and definitive, book on t...
    Disponible

    39,51 €

  • Logic and Relational Theory
    Chris Date
    This book is a revised, upgraded, and hugely improved version of an earlier one called Logic and Databases.  Although it’s effectively a brand new book, therefore, the following remarks from that earlier book are still relevant here.  First, logic and databases are inextricably intertwined.  The relational model itself is essentially just elementary logic, tailored to database ...
    Disponible

    40,73 €