Relational Database Design and Implementation: Clearly Explained - Tapa blanda

Harrington, Jan L.

 
9780128043998: Relational Database Design and Implementation: Clearly Explained
Tapa blanda
ISBN 10: 0128043997 ISBN 13: 9780128043998
Editorial: Morgan Kaufmann, 2016

Sinopsis

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

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.

De la contraportada

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.

    • "Sobre este título" puede pertenecer a otra edición de este libro.

    Editorial
    Morgan Kaufmann
    Año de publicación
    2016
    Idioma
    Inglés
    ISBN 10 
    0128043997
    ISBN 13 
    9780128043998
    Encuadernación
    Tapa blanda
    Número de edición
    4
    Número de páginas
    712
    Contacto del fabricante
    no disponible
    Persona responsable
    no disponible