Database Systems: A Practical Approach to Design, Implementation and Management: A Practical Approach to Design, Implementation and Management: United States Edition - Brossura

Connolly, Thomas M.; Begg, Carolyn E.

Brossura

ISBN 10: 0321523067 ISBN 13: 9780321523068

Casa editrice: Pearson College Div, 2009

Riassunto

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 theDreamHome 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.

Su questo libro

L'autore:

Thomas M. Connolly is the head of the Computing and Information Systems division at the University of Paisley.

Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine.

Product Description:

Book by Connolly Thomas M Begg Carolyn E

Su questa edizione

• Editore: Pearson College Div
• Data di pubblicazione: 2009
• ISBN 10: 0321523067
• ISBN 13: 9780321523068
• Rilegatura: Copertina flessibile
• Numero edizione: 5
• Numero di pagine: 1227