|
|
ISBN: 9780071244763
Division: Higher Education
Pub Date: AUG-05
Pages: 1024
Edition: 05
Format: Paperback
: In Stock
|
|
|
| Database System Concepts |
, ,
| |
| About the book |
Database System Concepts, 5/e, is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. In addition to basic material for a first course, the text contains advanced material that can be used for course supplements, or as introductory material for an advanced course.
The authors assume only a familiarity with basic data structures, computer organization, and a high-level programming language such as Java, C, or Pascal. Concepts are presented as intuitive descriptions, and many are based on the running example of a bank enterprise. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.
The fundamental concepts and algorithms covered in the book are often based on those used in existing commercial or experimental database systems. The aim is to present these concepts and algorithms in a general setting that is not tied to one particular database system. Details of particular commercial database systems are discussed in the case studies which constitute Part 8 of the book.
The fifth edition of Database System Concepts retains the overall style of prior editions while evolving the content and organization to reflect the changes that are occurring in the way databases are designed, managed, and used.
|
| Key features |
Earlier coverage of SQL
Two early chapters are devoted to SQL. This allows students to begin SQL query writing early in the course, gain familiarity with the use of database systems, and develop an intuition about database design that facilitates the teaching of design methodology in Part 2 of the text. Extended coverage of SQL includes SQL:2003.
A new Part devoted to database design
Part 2 of the text opens with a chapter that presents an overview of the process of database design, administration, and maintenance. This chapter is followed by a chapter on the entity-relationship model and one on relational design. Part 2 concludes with a chapter that describes the design and development of database applications, including web applications, servlets, JSP, and security issues.
Increased coverage of XML
Part 3 includes a chapter on the design and querying of XML data. In the fifth edition, an increased emphasis has been placed on real-life applications of XML.
Expanded treatment of data mining and data analysis
Part 3 includes a heavily revised chapter on object-oriented and object-relational databases that emphasizes SQL object-relational features.
New case study covering PostgresQL
Coverage of data mining and online analytic processing have been moved earlier in the book to reflect their increasingly significant role as cenrally important uses of databases. The topics are now presented less as "advanced topics" and more in a manner suitable for students in a first course in databases.
Increased emphasis on practical applications and implementation in both the examples and the assignments
PostgresSQL is an open source database system that has gained enormously in popularity in the past few years. In addition to being a good platform to build database applications, the source code can be studied and extended in courses that emphasize database internals. A case study is therefore added to Part 8 where it joins updated versions of the three case studies that appeared in the Fourth Edition.
Enhanced pedagogy
Many detailed examples of database implementations are included throughout the text, with practical applications of database theory being linked to real world applications whenever possible. Examples of commercial systems are frequently used in the text.
Web page and teaching supplements
Each chapter has a list of review terms that can help readers review key topics covered in the chapter. Most chapters also have a tools section at the end of the chapter that provides information on software tools related to the topic of the chapter. The authors have also added a host of new exercises and updated all references.
Online appendices
The book website contains slides covering all of the chapters of the book, answers to selected exercises, an up-to-date errata list, and supplementary material contributed by users of the book. In addition, instructors also have access to a manual containing solutions to all of the exercises in the book, a question bank containing extra exercises, and lab material including data sets for queries.
Thoroughly revised and updated coverage of object-relational databases
Online appendices covering the network and hierarchical data models are available for the benefit of readers who wish to learn about these data models. In addition, for readers who wish to cover the theory of relational database design in more detail, there is an online appendix that describes advanced relational database design, including the theory of multivalued dependencies, joint dependencies, and the project-join and domain-key formulas
|
| Table of contents |
Chapter 1 Introduction
Part 1: Relational Databases
Chapter 2 Relational Model
Chapter 3 SQL
Chapter 4 Advanced SQL
Chapter 5 Other Relational Languages
Part 2: Database Design
Chapter 6 The Database Design Process
Chapter 7 Design Using the Entity-Relationship Approach
Chapter 8 Relational-Database Design
Chapter 9 Application Design and Development
Part 3: ObjectBased and Semi-Structured Databases
Chapter 10 Object-Relational Databases
Chapter 11 XML
Part 4: Data Storage and Querying
Chapter 12 Storage and File Structures
Chapter 13 Indexing and Hashing
Chapter 14 Query Processing
Chapter 15 Query Optimization
Chapter 16 Data Mining
Chapter 17 Data Analysis and Information Retrieval
Part 5: Transaction Management
Chapter 18 Transactions
Chapter 19 Concurrency Control
Chapter 20 Recovery System
Part6: Parallel and Distributed Database Systems
Chapter 21 Database System Architectures
Chapter 22 Distributed Databases
Chapter 23 Parallel Databases
Part 7: Other Topics
Chapter 24 Performance Benchmarks and Tuning
Chapter 25 Advanced Data Types and Applications
Chapter 26 Advanced Transaction Processing
Part 8: Case Studies
Chapter 27 Oracle
Chapter 28 SQL Server
Chapter 29 DB2
Chapter 30 PostgresSQL
Appendix A Network Model
Appendix B Hierarchical Model
Appendix C Advanced Normalization
|
|
|
|
.gif){kind=spacer}
