About the Book

This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases-conceptual, logical, and physical database design.
Background: Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database System Lifecycle; Database Analysis and the "DreamHome" Case Study; Entity-Relationship Modeling; Enhanced Entity-Relationship Modeling; Normalization; Advanced Normalization. Methodology: Methodology-Conceptual Database Design; Methodology-Logical Database Design for Relational Model; Methodology-Physical Database Design for Relational Databases; Methodology-Monitoring and Tuning the Operational System. Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication: Distributed DBMSs-Concepts and Design; Distributed DBMSs-Advanced Concepts; Replication and Mobile Databases. Object DBMSs: Object-Oriented DBMSs-Concepts and Design; Object-Oriented DBMSs-Standards and Languages; Object-Relational DBMSs. Web and DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices: Users' Requirements Specification for "DreamHome" Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho-A Liteweight RDBMS. Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational?; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts.
This book is ideal for readers interested in database management or database design.

Product Details

Media: Paperback Book, 1243 pages

Language: English

Publisher: Addison Wesley Longman

Edition: 5

ISBN-10: 0321523067

Publication Date: Feb. 24th, 2009

ISBN-13: 9780321523068

Dimensions: 7.30 x 9.10 x 1.80 inches

Shipping Weight: 3.85 lbs

• Categories: General Database Management