» » Relational Database Design and Implementation: Clearly Explained
ePub 1657 kb. | Fb2 1762 kb. | DJVU: 1653 kb.

Relational Database Design and Implementation: Clearly Explained epub ebook

by Jan L. Harrington

Relational Database Design and Implementation: Clearly Explained epub ebook

Author: Jan L. Harrington
Category: Databases & Big Data
Language: English
Publisher: Morgan Kaufmann; 3 edition (July 24, 2009)
Pages: 440 pages
ISBN: 0123747309
ISBN13: 978-0123747303
Rating: 4.7
Votes: 697
Other formats: lit docx lrf rtf

Harrington, Jan L. Relational database design clearly explained. Part IV provides an overview of a variety of database implementation issues that you may need to consider as you design a relational database.

Harrington, Jan L. D26H38 2009 00. 5’6-dc22 2009022380 ISBN: 978-0-12-374730-3 For information on all Morgan Kaufmann publications, visit our Web site at ww. kp. com or ww. lsevierdirect. com Printed in the United States of America 09 10 11 12 13 5 4 3 2 1. Working together to grow libraries in developing countries ww. lsevier.

Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture. Series: Clearly Explained.

We’re dedicated to reader privacy so we never track you. We never accept ads. But we still need to pay for servers and staff. I know we could charge money, but then we couldn’t achieve our mission: a free online library for everyone.

This book covers relational database theory as well as providing a solid introduction to SQL, the international . Jan L. Harrington, author of more than 35 books on a variety of technical subjects, has been writing about databases since 1984.

This book is affiliated solely with Princeton Cambridge Publishing Group LLC "The Magic of Believing&q.

Carlos Coronel, Steven. This book is affiliated solely with Princeton Cambridge Publishing Group LLC "The Magic of Believing&q. Database Systems: Design, Implementation, and Management. 58 MB·1,551 Downloads·New!

Relational Database Technology. Relational Database Index Design and the Optimizers Conceptual Schema and Relational Database Design. Report "Relational Database Design Clearly Explained".

Database systems underlie the large majority of business information systems. Most of those in use today are based on the relational data model, a way of representing data and data relationships using only two-dimensional tables.

Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS.The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to "Dummies"-style talking down to the reader.Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues. * Principles needed to understand the basis of good relational database design and implementation practices. * Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work.* Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put.* Design approaches that ensure data accuracy and consistency.* Examples of how design can inhibit or boost database application performance.* Object-relational design techniques, benefits, and examples.* Instructions on how to choose and use a normalization technique.* Guidelines for understanding and applying Codd's rules.* Tools to implement a relational design using SQL.* Techniques for using CASE tools for database design.
Reviews (3)
I have been working with databases for about ten years now. I consider myself an intermediate user. I have had exposure to mainframe systems, mini systems and desktop systems, including DB/2, Oracle, MSSQL, Access, Paradox, dBase and others. I have learned a lot on my own, and I recognize that I have much to learn. That said, I wish I had come across a book like this one YEARS AGO. This book breaks down database types, concepts, terminology and fundamentals in a way that can be understood by anyone with the will to learn about databases. I am not much of a reader. For me, reading is work. Yet I have already read this book half way through in about four days. If I were an avid reader, I'm sure I would have finished it.

While this book will not walk you through building a database in any particular database product, it WILL teach you how to look at your data and determine the best approach to take in setting up a database to manage it. It will also lay the foundation, upon which you CAN learn to use a database application and make it happen.

I HIGHLY RECOMMEND THIS BOOK to any aspiring database administrator or analyst. There are some typos, but they are minor. This book ROCKS. I know I am repeating myself, but I wish I had found this years ago.

Recently, I finished reading Dr. Harrington's excellent book, "Relational Database Design and Implementation". And I felt the need to share how impressed I am with this book.

Dr. Harrington's book represents a full, yet accessible, treatment of the Relational Model for Database together with practical considerations pertaining to the implementation of relational databases. In this, I would compare her excellent book with two other classics on the subject: Dr. Codd's magisterial "The Relational Model for Database Management, Version 2" and "The Handbook of Relational Database Design" by Fleming and Von Halle. Codd's book, of course, is the masterpiece that ought to be required reading for any person aspiring to a career in modern data administration or database management. Harrington's book, here reviewed, covers much of the important, foundational material treated in much greater depth in Codd's book. And it does so in a very readable and understandable fashion. The reader of both will soon appreciate that Harrington is a teacher by trade, where Codd was a database scientist. In other words, Harrington nicely makes much of the important work covered by Codd accessible to readers who are not necessarily database scientists, but who, perhaps, are simply interested practitioners. "The Handbook of Relational Database Design" by Fleming and Von Halle is truly an emerging classic in the field. Yet, it is now becoming a bit dated. Harrington does not go into the depth of describing a full blown methodology for logical data modeling and relational database design, as did Fleming and Von Halle. But she does deal with current issues of design and implementation in an extraordinarily clear and effective manner.

In summary, I was thrilled and well edified by Dr. Harrington's book. Perhaps the greatest complement I can pay to the esteemed author is that I have purchased and started reading her companion volume, "SQL Clearly Explained". To Dr. Harrington, I can only say: "Bravo"! To other interested readers and reviewers, I can only highly recommend Dr. Harrington's excellent and important book on Relational Database Design and Implementation. God bless.

I was surprised at how quickly I got though this book, in fact the biggest delays were in trying to determine the correct values of the many typos liberally scattered through the diagrams & examples in the book. These ranged from typos to mistakes in relationship cardinalities to just bad database design.

I have built & designed systems with flat files for decades (wow - that was a scary thing to re-read ;-) and although I've picked up a lot on Relational systems along the way, I wanted to confirm my learnings and formalise my understandings of relational systems, hence reading this book.

Sadly it has been a real disappointment, as I found so many mistakes in the book that I cannot really trust it, and so have started again with another author. Also, along the way I found her explanations - of things that I do know about - very confused and confusing (concurrency etc.)

All in all, mostly a waste of my time (but thankfully it's quick to read ;-)

I couldn't really recommend it to anyone.

2016-2020 © www.hotellemcasadeicervia.it
All rights reserved