Harrington - Relational Database Design and Implementation
Here you can read online Harrington - Relational Database Design and Implementation full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2009, publisher: Elsevier Science;Morgan Kaufmann, genre: Computer. 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:Relational Database Design and Implementation
- Author:
- Publisher:Elsevier Science;Morgan Kaufmann
- Genre:
- Year:2009
- Rating:5 / 5
- Favourites:Add to favourites
- Your mark:
Relational Database Design and Implementation: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Relational Database Design and Implementation" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
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 Codds Rules (and why they are important) are covered clearly and concisely but without resorting to Dummies--Style talking down to the reader. Supporting the books 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 books 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 Codds rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design.
Harrington: author's other books
Who wrote Relational Database Design and Implementation? Find out the surname, the name of the author of the book and a list of all author's works by series.
Harrington
Halpin Terry
Faroult Stéphane
Louis Davidson
Allen G. Taylor
Jan L. Harrington
Ramez Elmasri
Relational Database Design and Implementation — 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 "Relational Database Design and Implementation" 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.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
Copyright Page
Morgan Kaufmann Publishers is an imprint of Elsevier.
30 Corporate Drive, Suite 400, Burlington, MA 01803, USA
This book is printed on acid-free paper.
Copyright 2009 by Elsevier Inc. All rights reserved.
Designations used by companies to distinguish their products are often claimed as trademarks or registered trademarks. In all instances in which Morgan Kaufmann Publishers is aware of a claim, the product names appear in initial capital or all capital letters. All trademarks that appear or are otherwise referred to in this work belong to their respective owners. Neither Morgan Kaufmann Publishers nor the authors and other contributors of this work have any relationship or affiliation with such trademark owners nor do such trademark owners confirm, endorse or approve the contents of this work. Readers, however, should contact the appropriate companies for more information regarding trademarks and any related registrations.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any meanselectronic, mechanical, photocopying, scanning, or otherwisewithout prior written permission of the publisher.
Permissions may be sought directly from Elsevier's Science & Technology Rights Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333, E-mail: ), by selecting
Support & Contact then Copyright and Permission and then Obtaining Permissions.
Library of Congress Cataloging-in-Publication Data
Harrington, Jan L.
Relational database design and implementation : clearly explained / Jan L. Harrington.3rd ed.
p. cm.
Rev. ed of: Relational database design clearly explained, 1998.
Includes bibliographical references and index.
ISBN 978-0-12-374730-3
1. Relational databases.2.Database design.I.Harrington, Jan L. Relational database design clearly explained.II.Title.
QA76.9.D26H38 2009
005.75'6dc222009022380
ISBN: 978-0-12-374730-3
For information on all Morgan Kaufmann publications,
visit our Web site at www.mkp.com or www.elsevierdirect.com
Printed in the United States of America
091011121354321
 |
Preface to the Third Edition
My favorite opening line for the database courses I teach is Probably the most misunderstood term in all of business computing is database, followed closely by the word relational. At that point, some students look a bit smug because they are absolutely, positively sure that they know what a database is and that they also know what is means for a database to be relational. Unfortunately, the popular press, with the help of some PC software developers, long ago distorted the meaning of both terms, which led many businesses to think that designing a database is a task that could be left to any clerical worker who had taken a one-week course on using database software. As you will see throughout this book, however, nothing could be further from the truth.
Note: The media has given us a number of nonsense computer terms such as telephone modem (we're modulating an analog signal, not a telephone), software program (the two words mean pretty much the same thing), and cable modem and DSL modem (they're not modems; they don't modulate and demodulate analog signals; they are more properly termed codecs that code and decode digital signals). It's all in an attempt to make computer jargon easier for people to understand, but it has generally had the effect of introducing misunderstandings.
This book is intended for anyone who has been given the responsibility for designing or maintaining a relational database. It will teach you how to look at the environment your database serves and to tailor the design of the database to the environment. It will also teach you how to design the database so it provides accurate and consistent data, avoiding the problems that are common to poorly designed databases. In addition, you will learn about design compromises that you might choose to make in the interest of database application performance and the consequences of making such choices.
If you are a college instructor, you may choose to use this book as a text in an undergraduate database management course. I've been doing that for a number of years (along with SQL Clearly Explained, this book's companion volume) and find that students learn from it quite well. They appreciate the straightforward language rather than a text that forces them to struggle with overly academic sentence structures. They also like the many real-world examples that appear throughout the book.
Changes in the Third Edition
The core of this bookParts II and III, the bulk of the content of the previous editionsremains mostly unchanged from the second edition. Relational database theory has been relatively stable for more than 30 years (with the exception of the addition of sixth normal form) and requires very little updating from one edition to the next, although it has been seven years since the second edition appeared. The major changes are the discussions of fifth and sixth normal forms. The first two case studies in Part III have been updated; the third case study is new.
The chapter on object-relational databases has been removed from this edition, as well as object-relational examples in the case studies. There are two reasons for this. First, support for objects within a relational environment has largely been provided as a part of the SQL standard rather than as changes to underlying relational database theory. Second, the direction that SQL's object-relational capabilities have taken since the second edition appeared involves a number of features that violate relational design theory, and presenting them in any depth in this book would be more confusing than helpful.
By far the biggest change, however, is the addition of the new Parts I and IV. Part I contains three chapters that provide a context for database design. Database requirements don't magically appear at the point an organization needs a database, although looking at the previous editions of this book, you might think they did. presents several organizational aspects of database management, including the hardware architectures on which today's databases run, and a look at service-oriented architecture (SOA), an information systems technique in which databases, like other IT functions, become services provided throughout an organization.
youll discover why we care about good database design. (It really does matter!)
Part IV provides an overview of a variety of database implementation issues that you may need to consider as you design a relational database. The topics include concurrency control (keeping the database consistent while multiple users interact with it at the same time), data warehousing (understanding issues that may arise when your operational database data are destined for data mining), data quality (ensuring that data are as accurate and consistent as possible), and XML (understanding how today's databases support XML).
The addition of Parts I and IV also make this book better suited for use as a textbook in a college course. When I used the second edition as a text in my classes, I added supplementary readings to cover that material. It's nice to have it all in once place!
The material about older data models that was presented in in the second edition has been moved into an appendix. None of the material in the body of the book depends on it any longer. You can read it if you are interested in knowing what preceded the relational data model, but you won't lose anything significant in terms of relational databases if you skip it.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
Similar books «Relational Database Design and Implementation»
Look at similar books to Relational Database Design and Implementation. 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.
Halpin Terry
Faroult Stéphane
Louis Davidson
Allen G. Taylor
Jan L. Harrington
Ramez Elmasri
Reviews about «Relational Database Design and Implementation»
Discussion, reviews of the book Relational Database Design and Implementation 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.