C. J. Date - Database Design and Relational Theory: Normal Forms and All That Jazz
Here you can read online C. J. Date - Database Design and Relational Theory: Normal Forms and All That Jazz full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2019, publisher: Apress, genre: Romance novel. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Database Design and Relational Theory: Normal Forms and All That Jazz
- Author:
- Publisher:Apress
- Genre:
- Year:2019
- Rating:4 / 5
- Favourites:Add to favourites
- Your mark:
Database Design and Relational Theory: Normal Forms and All That Jazz: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Database Design and Relational Theory: Normal Forms and All That Jazz" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scientific foundation for database technology in general. Databases lie at the heart of so much of what we do in the computing world that negative impacts of poor design can be extraordinarily widespread.
This second edition includes greatly expanded coverage of exotic and little understood normal forms such as: essential tuple normal form (ETNF), redundancy free normal form (RFNF), superkey normal form (SKNF), sixth normal form (6NF), and domain key normal form (DKNF). Also included are new appendixes, including one that provides an in-depth look into the crucial notion of data consistency. Sequencing of topics has been improved, and many explanations and examples have been rewritten and clarified based upon the authors teaching of the content in instructor-led courses.
This book aims to be different from other books on design by bridging the gap between the theory of design and the practice of design. The book explains theory in a way that practitioners should be able to understand, and it explains why that theory is of considerable practical importance. Reading this book provides you with an important theoretical grounding on which to do the practical work of database design. Reading the book also helps you in going to and understanding the more academic texts as you build your base of knowledge and expertise. Anyone with a professional interest in database design can benefit from using this book as a stepping-stone toward a more rigorous design approach and more lasting database models.
What You Will Learn
- Understand what design theory is and is not
- Be aware of the two different goals of normalization
- Know which normal forms are truly significant
- Apply design theory in practice
- Be familiar with techniques for dealing with redundancy
- Understand what consistency is and why it is crucially important
Who This Book Is For
Those having a professional interest in database design, including data and database administrators; educators and students specializing in database matters; information modelers and database designers; DBMS designers, implementers, and other database vendor personnel; and database consultants. The book is product independent.
C. J. Date: author's other books
Who wrote Database Design and Relational Theory: Normal Forms and All That Jazz? Find out the surname, the name of the author of the book and a list of all author's works by series.
Database Design and Relational Theory: Normal Forms and All That Jazz — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Database Design and Relational Theory: Normal Forms and All That Jazz" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484255391 . For more detailed information, please visit http://www.apress.com/source-code .
In computing, elegance is not a dispensable luxury but a quality that decides between success and failure.
Edsger W. Dijkstra
The ill design is most ill for the designer.
Hesiod
It is to be noted that when any part of this paper is dull there is design in it.
Sir Richard Steele
The idea of a formal design discipline is often rejected on account of vague cultural / philosophical condemnations such as stifling creativity; this is more pronounced where a romantic vision of the humanities in fact idealizes technical incompetence
[We] know that for the sake of reliability and intellectual control we have to keep the design simple and disentangled.
Edsger W. Dijkstra
My designs are strictly honorable.
Anon.
To my wife Lindy
and my daughters Sarah and Jennie
with all my love
This book began life as a comparatively short chapter in a book calledDatabase in Depth: Relational Theory for Practitioners(OReilly, 2005). That book was superseded by a greatly expanded version calledSQL and Relational Theory: How to Write Accurate SQL Code(OReilly, 2009), where the design material, since it was somewhat tangential to the main theme of the book, ceased to be a chapter as such and became a (somewhat longer) appendix instead. I subsequently began work on a second edition of this latter book.During the course of that work, I found there was so much that needed to be said on the subject of database design in general that the appendix threatened to grow out of all proportion to the rest of the book. Since the topic was, as Ive indicated, rather out of line with the major emphasis of that book anyway, I decided to cut the Gordian knot and separate the material out into a book of its own: the one youre looking at right now.
First, the present book does assume youre familiar with material covered in theSQL and Relational Theorybook (in particular, it assumes you know exactly whatrelations,attributes, andtuplesare). I make no apology for this state of affairs, however, since the present book is aimed at database professionals and database professionals ought really to be familiar with most of whats in that earlier book, anyway.
Second, the previous point notwithstanding, theres unavoidably a small amount of overlap between this book and that earlier book. Ive done my best to keep that overlap to a minimum, however.
- Third, there are, again unavoidably, many references in this book to that earlier one. Now, most references in this book to other publications are given in full, as in this example:
Ronald Fagin: Normal Forms and Relational Database Operators, Proc. 1979 ACM SIGMOD International Conference on Management of Data, Boston, Mass. (May/June 1979)
In the case of references to theSQL and Relational Theorybook in particular, however, from this point forward Ill give them in the form of that abbreviated title alone.
Actually Ive published several short pieces over the years, in one place or another, on various aspects of design theory, and the present book is intended among other things to preserve the good parts of those earlier writings. But its not just a cobbling together of previously published material, and I sincerely hope it wont be seen as such. For one thing, it contains much new material. For another, it presents a more coherent, and I think much better, perspective on the subject as a whole (Ive learned a lot myself over the years!). Indeed, even when a portion of the text is based on some earlier publication, the material in question has been totally rewritten and, I trust, improved.
Font size:
Interval:
Bookmark:
Similar books «Database Design and Relational Theory: Normal Forms and All That Jazz»
Look at similar books to Database Design and Relational Theory: Normal Forms and All That Jazz. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Database Design and Relational Theory: Normal Forms and All That Jazz and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.