Relational Database Design and Implementation: Clearly Explained - Softcover

Harrington, Jan L.

Softcover

ISBN 10: 0128043997 ISBN 13: 9780128043998

Publisher: Morgan Kaufmann, 2016

Synopsis

Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance.

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. This book covers relational database theory as well as providing a solid introduction to SQL, the international standard for the relational database data manipulation language.

The book begins by reviewing basic concepts of databases and database design, then turns to creating, populating, and retrieving data using SQL. Topics such as the relational data model, normalization, data entities, and Codd's Rules (and why they are important) are covered clearly and concisely. In addition, the book looks at the impact of big data on relational databases and the option of using NoSQL databases for that purpose.

• Features updated and expanded coverage of SQL and new material on big data, cloud computing, and object-relational databases
• Presents design approaches that ensure data accuracy and consistency and help boost performance
• Includes three case studies, each illustrating a different database design challenge
• Reviews the basic concepts of databases and database design, then turns to creating, populating, and retrieving data using SQL

About this title

From the Back Cover

Fully revised, updated, and expanded, Relational Database Design and Implementation, Fourth Edition, is the most lucid and effective introduction to relational database design and the database environment available. Here you’ll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.

This edition retains its in-depth coverage of the process of designing a good relational database as well as three major case studies illustrating the planning and design steps involved in arriving at a sound design. For the first time, it also includes coverage of all major capabilities of SQL (creating database structures, querying, and using advanced techniques such as windowing). This edition also contains chapters covering the environment in which databases run, as well as an examination of object-relational and NoSQL databases.

Coverage Includes

• Concepts needed to create effective relational database designs.
•  Theoretical and practical guidelines for normalizing relational databases.
• The impact of database design on data accuracy and consistency.
• Examples of how design can inhibit or boost database application performance.
• Using SQL to implement database structure, manipulate data values, and retrieve data.
•  The overall systems analysis and design process during which database design takes place.
• Database implementation issues including database security, concurrency control, and integration with XML.
• Techniques for using CASE tools for database design.
•  The relationship between relational database design and data warehouse design.
•  Enhancements and alternatives to the relational database model such as object-relational databases and NoSQL databases.

About the Author

Jan L. Harrington, author of more than 35 books on a variety of technical subjects, has been writing about databases since 1984. She retired in 2013 from her position as professor and chair of the Department of Computing Technology at Marist College, where she taught database design and management, data communications, computer architecture, and the impact of technology on society for 25 years.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 2016
• ISBN 10: 0128043997
• ISBN 13: 9780128043998
• Binding: Paperback
• Language: English
• Edition number: 4
• Number of pages: 712