Learn database theory from the bestselling text with a beginner-friendly approach Database Systems: A Practical Approach to Design, Implementation, and Management, 6th edition, Global Edition,by Thomas Connolly and Carolyn Begg, introduces you to the theory behind databases in a concise yet comprehensive manner. The methodology behind relational Database Management Systems is presented in a simple way, with step-by-step instructions, making the text accessible for technical and non-technical readers. The text applies a realistic worked example that you follow across the chapters of the book using three explicit phases (conceptual, logical, and physical database design) to help you relate your knowledge to real-world applications. Designed for one or two-term undergraduate courses in database management or database design, this book can also be used as a working reference for IT professionals. This 6th edition has been updated with the latest information on the subject, as well as additional learning features compared to the previous edition. New features include: An extended chapter on database architectures and the Web, covering cloud computing.A new Section on Data Warehousing and Temporal Databases.Updated text to cover the latest version of the SQL standard, which was released late 2011 (SQL:2011).An extended chapter on replication and mobile databases.Updated chapters on Web-DBMS integration and XML.Extended treatment of XML, SPARQL, Xquery 1.0 and Xpath 2.0 (including the new Xquery Update facility), and the new SQL:2011 SQL/XML standard.Coverage updated to Oracle 11g.New review questions and exercises at the end of chapters allow readers to test their understanding. With its clear presentation that supports your learning, this book can provide you with a comprehensive understanding of the theory behind databases.
Les mer
Teach database theory with the bestselling text on the subject Database Systems: A Practical Approach to Design, Implementation, and Management introduces the theory behind databases in a concise yet comprehensive manner. Designed for undergraduate courses, the text is accessible for non-technical readers. This title comes with a Companion Website.
Les mer
Part 1 Background Chapter 1 Introduction to DatabasesDatabase EnvironmentDatabase Architectures and the Web Part 2 The Relational Model and Languages Chapter 4 The Rational ModelChapter 5 Relational Algebra and Relational CalculusChapter 6 SQL: Data ManipulationChapter 7 SQL: Data DefinitionChapter 8 Advanced SQLChapter 9 Object-Relational DBMSs Part 3 Database Analysis and Design Chapter 10 Database System Development LifecycleChapter 11 Database Analysis and the DreamHome Case StudyChapter 12 Entity-Relationship ModelingChapter 13 Enhanced Entity-Relationship ModelingChapter 14 NormalizationChapter 15 Advanced Normalization Part 4 Methodology Chapter 16 Methodology – Conceptual Database DesignChapter 17 Methodology – Logical Database Design for the Relational ModelChapter 18 Methodology – Physical Database Design for Relational DatabasesChapter 19 Methodology – Monitoring and Tuning the Operational System Part 5 Selected Database Issues Chapter 20 Security and AdministrationChapter 21 Professional, Legal, and Ethical Issues in Data ManagementChapter 22 Transaction ManagementChapter 23 Query Processing Part 6 Distributed DBMSs and Replication Chapter 24 Distributed DBMSs – Concepts and DesignChapter 25 Distributed DBMSs – Advanced ConceptsChapter 26 Replication and Mobile Databases Part 7 Object DBMSs Chapter 27 Object-Oriented DBMSs – Concepts and DesignChapter 28 Object-Oriented DBMSs – Standard Systems Part 8 The Web and DBMSs Chapter 29 Web Technology and DBMSsChapter 30 Semistructured Data and XML Part 9 Business Intelligence Chapter 31 Data Warehousing ConceptsChapter 32 Data Warehousing DesignChapter 33 OLAPChapter 34 Data Mining Appendices References Further Reading Index
Les mer
Hallmark features of this title A Methodology that can be used by Technical and Non-technical Readers The design methodology is divided into three phases based on the widely accepted Entity—Relationship model: conceptual, logical, and physical.The methodology in each phase is presented as a series of steps for the inexperienced designer, and a checklist for the experienced designer.A step-by-step methodology for physical database design, covers mapping of design to implementation. The integrated case study shows how to use the methodology. A Clear Presentation Supports Learning Definitions are highlighted, chapter objectives are clearly stated, and chapters are neatly summarized.Examples and diagrams throughout each chapter illustrate the main concepts.
Les mer
New and updated features of this edition This edition has been revised to present students with a concise introduction to the theory behind databases. Updates include: Additional updated content from the previous edition. An extended chapter on database architectures and the Web, covering cloud computing.A new Section on Data Warehousing and Temporal Databases.Updated text to cover the latest version of the SQL standard, which was released late 2011 (SQL:2011).An extended chapter on replication and mobile databases.Updated chapters on Web-DBMS integration and XML.Extended treatment of XML, SPARQL, Xquery 1.0 and Xpath 2.0 (including the new Xquery Update facility), and the new SQL:2011 SQL/XML standard.Coverage updated to Oracle 11g. Extra features to support your students' learning. New review questions and exercises at the end of chapters allow readers to test their understanding.
Les mer

Produktdetaljer

ISBN
9781292061184
Publisert
2014-10-03
Utgave
6. utgave
Utgiver
Vendor
Pearson Education Limited
Vekt
2010 gr
Høyde
231 mm
Bredde
193 mm
Dybde
46 mm
Aldersnivå
U, 05
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
1440

Biographical note

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