Database Systems - Softcover

Connolly, Thomas M.

  • 3.66 out of 5 stars
    304 ratings by Goodreads
 
9780321601100: Database Systems
Softcover
ISBN 10: 0321601106 ISBN 13: 9780321601100
Publisher: Pearson

Synopsis

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.

"synopsis" may belong to another edition of this title.

About the Author

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.

"About this title" may belong to another edition of this title.

Publisher
Pearson
Language
English
ISBN 10 
0321601106
ISBN 13 
9780321601100
Binding
Paperback
Rating
  • 3.66 out of 5 stars
    304 ratings by Goodreads

Other Popular Editions of the Same Title

9780321523068: Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition)

Featured Edition

ISBN 10:  0321523067 ISBN 13:  9780321523068
Publisher: Pearson, 2009
Softcover