Articoli correlati a Database Technology: Nulls Considered Harmful
Sinossi
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 systems today all use the language SQL as their user language—and SQL is based not on 2VL but on what’s called three-valued logic, 3VL, instead, and uses what are called nulls to represent missing information. In fact, Codd himself subsequently extended his original model to support 3VL and nulls as well. (Actually, basing SQL on 3VL and adding 3VL to the relational model seem to have occurred in lockstep, as it were. Certainly both developments occurred at the same place—the IBM San Jose Research Laboratory—at more or less the same time.)
But 3VL is a disastrously bad basis on which to build databases, or database applications, or database languages. It’s bad because 3VL doesn’t behave the way reality behaves, which means that results that 3VL says are correct are often not correct in the real world. Not only that, but SQL’s implementation of 3VL is itself incorrect in places, which means it effectively adds another layer of wrong answers on top of the first. Bottom line:
If you have nulls in your database, you’re getting wrong answers.
This book explains this issue in detail. It also contains numerous practical suggestions for dealing with the problem.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
- EditoreTechnics Publications
- Data di pubblicazione2024
- ISBN 10 1634624769
- ISBN 13 9781634624763
- RilegaturaCopertina flessibile
- LinguaInglese
- Numero di pagine246
- Contatto del produttorenon disponibile
Compra nuovo
Visualizza questo articolo
EUR 37,30
EUR 7,76 per la spedizione da U.S.A. a Italia
Destinazione, tempi e costiRisultati della ricerca per Database Technology: Nulls Considered Harmful
Foto dell'editore
Database Technology: Nulls Considered Harmful
Da: California Books, Miami, FL, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo I-9781634624763
Quantità: Più di 20 disponibili
Foto dell'editore
Database Technology
Print on DemandDa: PBShop.store US, Wood Dale, IL, U.S.A.
Valutazione del venditore 5 su 5 stelle
PAP. Condizione: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice articolo L0-9781634624763
Quantità: Più di 20 disponibili
Foto dell'editore
Database Technology: Nulls Considered Harmful
Print on DemandDa: THE SAINT BOOKSTORE, Southport, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 431. Codice articolo C9781634624763
Quantità: Più di 20 disponibili
Foto dell'editore
Database Technology
Print on DemandDa: PBShop.store UK, Fairford, GLOS, Regno Unito
Valutazione del venditore 4 su 5 stelle
PAP. Condizione: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice articolo L0-9781634624763
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
Database Technology
Editore:
Technics Publications Jul 2024, 2024
ISBN 10: 1634624769
ISBN 13: 9781634624763
Nuovo
Taschenbuch
Da: BuchWeltWeit Ludwig Meier e.K., Bergisch Gladbach, Germania
Valutazione del venditore 5 su 5 stelle
Taschenbuch. Condizione: Neu. This item is printed on demand - it takes 3-4 days longer - Neuware -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 systems today all use the language SQL as their user language-and SQL is based not on 2VL but on what's called three-valued logic, 3VL, instead, and uses what are called nulls to represent missing information. In fact, Codd himself subsequently extended his original model to support 3VL and nulls as well. (Actually, basing SQL on 3VL and adding 3VL to the relational model seem to have occurred in lockstep, as it were. Certainly both developments occurred at the same place-the IBM San Jose Research Laboratory-at more or less the same time.)But 3VL is a disastrously bad basis on which to build databases, or database applications, or database languages.It's bad because 3VL doesn't behave the way reality behaves, which means that results that 3VL says are correct are often not correct in the real world. Not only that, but SQL's implementation of 3VL is itself incorrect in places, which means it effectively adds another layer of wrong answers on top of the first. Bottom line:If you have nulls in your database, you're getting wrong answers.This book explains this issue in detail. It also contains numerous practical suggestions for dealing with the problem. 246 pp. Englisch. Codice articolo 9781634624763
Quantità: 2 disponibili
Foto dell'editore
Database Technology: Nulls Considered Harmful
Da: Ria Christie Collections, Uxbridge, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: New. In. Codice articolo ria9781634624763_new
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
Database Technology
Editore:
Technics Publications Jul 2024, 2024
ISBN 10: 1634624769
ISBN 13: 9781634624763
Nuovo
Taschenbuch
Da: buchversandmimpf2000, Emtmannsberg, BAYE, Germania
Valutazione del venditore 5 su 5 stelle
Taschenbuch. Condizione: Neu. Neuware -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 systems today all use the language SQL as their user language-and SQL is based not on 2VL but on what's called three-valued logic, 3VL, instead, and uses what are called nulls to represent missing information. In fact, Codd himself subsequently extended his original model to support 3VL and nulls as well. (Actually, basing SQL on 3VL and adding 3VL to the relational model seem to have occurred in lockstep, as it were. Certainly both developments occurred at the same place-the IBM San Jose Research Laboratory-at more or less the same time.)But 3VL is a disastrously bad basis on which to build databases, or database applications, or database languages.It's bad because 3VL doesn't behave the way reality behaves, which means that results that 3VL says are correct are often not correct in the real world. Not only that, but SQL's implementation of 3VL is itself incorrect in places, which means it effectively adds another layer of wrong answers on top of the first. Bottom line:If you have nulls in your database, you're getting wrong answers.This book explains this issue in detail. It also contains numerous practical suggestions for dealing with the problem.Libri GmbH, Europaallee 1, 36244 Bad Hersfeld 246 pp. Englisch. Codice articolo 9781634624763
Quantità: 2 disponibili
Foto dell'editore
Database Technology: Nulls Considered Harmful
Da: Books Puddle, New York, NY, U.S.A.
Valutazione del venditore 4 su 5 stelle
Condizione: New. Codice articolo 26401471804
Quantità: 4 disponibili
Foto dell'editore
Database Technology: Nulls Considered Harmful
Print on DemandDa: Majestic Books, Hounslow, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: New. Print on Demand. Codice articolo 395986659
Quantità: 4 disponibili
Foto dell'editore
Database Technology: Nulls Considered Harmful
Print on DemandDa: Biblios, Frankfurt am main, HESSE, Germania
Valutazione del venditore 5 su 5 stelle
Condizione: New. PRINT ON DEMAND. Codice articolo 18401471798
Quantità: 4 disponibili