This acclaimed revision of a classic database systems text offers a complete background in the basics of database design, languages, and system implementation. It provides the latest information combined with real-world examples to help readers master concepts. All concepts are presented in a technically complete yet easy-to-understand style with notations kept to a minimum. A running example of a bank enterprise illustrates concepts at work. To further optimize comprehension, figures and examples, rather than proofs, portray concepts and anticipate results\r\n
\r\n
CONTENTS\r\nPreface\r\n1 Introduction\r\n1.1 Purpose of Database Systems\r\n1.2 View of Data\r\n1.3 Data Models\r\n1.4 Database Languages\r\n1.5 Transaction Management\r\n1.6 Storage Management\r\n1.7 Database Administrator\r\n1.8 Database Users\r\n1.9 Overall System Structure\r\n1.10 Summary\r\nExercises\r\nBibliographic Notes\r\n2 Entity-Relationship Model\r\n2.1 Basic Concepts\r\n2.2 Design Issues\r\n2.3 Mapping Constraints\r\n2.4 Keys\r\n2.5 Entity-Relationship Diagram\r\n2.6 Weak Entity Sets\r\n2.7 Extended E-R Features\r\n2.8 Design of an E-R Database Schema\r\n2.9 Reduction of an E-R Schema to Tables\r\n2. 10 Summary\r\nExercises\r\nBibliographic Notes\r\n3 Relational Model\r\n3.1 Structure of Relational Databases\r\n3.2 The Relational Algebra\r\n3.3 The Tuple Relational Calculus\r\n3.4 The Domain Relational Calculus\r\n3.5 Extended Relational-Algebra Operations\r\n3.6 Modification of the Database\r\n3.7 Views\r\n3.8 Summary\r\nExercises\r\nBibliographic Notes\r\n4 SQL\r\n4.1 Background\r\n4.2 Basic Structure\r\n4.3 Set Operations\r\n4.4 Aggregate Functions\r\n4.5 Null Values\r\n4.6 Nested Subqueries\r\n4.7 Derived Relations\r\n4.8 Views\r\n4.9 Modification Of the Database\r\n4.10 Joined Relations\r\n4.11 Data-Definition Language\r\n4.12 Embedded SQL\r\n4.13 Other SQL Features\r\n4.14 Summary\r\nExercises\r\nBibliog raphic Notes\r\n5 Other Relational Languages\r\n5.1 Query-by -Example\r\n5.2 Quel\r\n5.3 Datalog\r\n5.4 Summary\r\nExercises\r\nBibliog raphic Notes\r\n6 Integrity Constraints\r\n6.1 Domain Constraints\r\n6.2 Referential Integrity\r\n6 . 3 Assertions\r\n6 . 4 Triggers\r\n6.5 Functional Dependencies\r\n6.6 Summary\r\nExercises\r\nBibliographic Notes\r\n7 Relational Database Design\r\n7.1 Pitfalls in Relational -Database Design\r\n7.2 Decomposition\r\n7.3 Normalization Using Functional Dependencies\r\n7.4 Normalization Using Multivalued Dependencies\r\n7.5 Normalization Using Join Dependencies\r\n7.6 Domain-Key Normal Form\r\n7.7 Alternative Approaches to Database Design\r\n7.8 Summary\r\nExercises\r\nBibliographic Notes\r\n8 Object-Oriented Databases\r\n8.1 New Database Applications\r\n8.2 The Object-Oriented Data Model\r\n8.3 Object-Oriented Languages\r\n8.4 Persistent Programming Languages\r\n8.5 Persistent C++ Systems\r\n8.6 Summary\r\nExercises\r\nBibliographic Notes\r\n9 Object-Relational Databases\r\n9.1 Nested Relations\r\n9.2 Complex Types and Object Orientation\r\n.9.3 Querying with Complex Types\r\n9.4 Creation of Complex Values and Objects\r\n9.5 Comparison of Object-Oriented and Object-Relational Databases\r\n9.6 Summary\r\nExercises\r\nBibliographic Notes\r\n10 Storage and File Structure\r\n10.1 Overview of Physical Storage Media\r\n10.2 Magnetic Disks\r\n10.3 RAID\r\n10.4 Tertiary Storage\r\n10.5 Storage Access\r\n10.6 File Organization\r\n10.7 Organization of Records in Files\r\n10.8 Data-Dictionary Storage\r\n10.9 Storage Structures for Object-Oriented Databases\r\n10.10 Summary\r\nExercises\r\nBibliographic Notes\r\n11 Indexing and Hashing\r\n11. 1 Basic Concepts\r\n11.2 Ordered Indices\r\n11.3 B+-Tree Index Files\r\n11.4 B-Tree Index Files\r\n11.5 Static Hashing\r\n11.6 Dynamic Hashing\r\n11.7 Comparison of Ordered Indexing and Hashing\r\n11.8 Index Definition in SQL\r\n11.9 Multiple-Key Access\r\n11.10 Summary\r\nExercises\r\nBibliographic Notes\r\n12 Query Processing\r\n12.1 Overview\r\n12.2 Catalog Information for Cost Estimation\r\n12.3 Measures of Query Cost\r\n12.4 Selection Operation\r\n12.5 Sorting\r\n12.6 Join Operation\r\n12.7 Other Operations\r\n12.8 Evaluation of Expressions\r\n12.9 Transformation of Relational Expressions\r\n12.10 Choice of Evaluation Plans\r\n12.11 Summary\r\nExercises\r\nBibliographic Notes\r\n13 Transactions\r\n13.1 Transaction Concept\r\n13.2 Transaction State\r\n13.3 Implementation of Atomicity and Durability\r\n13.4 Concurrent Executions\r\n13.5 Serializability\r\n13.6 Recoverability\r\n13.7 Implementation of Isolation\r\n13.8 Transaction Definition in SQL\r\n13.9 Testing for Serializability\r\n13.10 Summary\r\nExercises\r\nBibliographic Notes\r\n14 Concurrencv Control\r\n14.1 Lock-Based Protocols\r\n14.2 Timestamp-Based Protocols\r\n14.3 Validation-Based Protocols\r\n14.4 Multiple Granularity\r\n14.5 Multiversion Schemes\r\n14.6 Deadlock Handling\r\n14.7 Insert and Delete Operations\r\n14.8 Concurrency in Index Structures\r\n14.9 Summary\r\nExercises\r\nBibliographic Notes\r\n15 Recovery System\r\n15.1 Failure Classification\r\n15.2 Storage Structure\r\n15.3 Recovery and Atomicity\r\n15.4 Log-Based Recovery\r\n15.5 Shadow Paging\r\n15.6 Recovery with Concurrent Transactions\r\n15.7 Buffer Management\r\n15.8 Failure with Loss of Nonvolatile Storage\r\n15.9 Advanced Recovery Techniques\r\n15.10 Summary\r\nExercises\r\nBibliographic Notes\r\n16 Database System Architectures\r\n16.1 Centralized Systems\r\n16.2 Client-Server Systems\r\n16.3 Parallel Systems\r\n16.4 Distributed Systems\r\n16.5 Network Types\r\n16.6 Summary\r\nExercises\r\nBibliographic Notes\r\n17 Parallel Databases\r\n17.1 Introduction\r\n17.2 I/O Parallelism\r\n17.3 Interquery Parallelism\r\n17.4 Intraquery Parallelism\r\n17.5 Intraoperation Parallelism\r\n17.6 Interoperation Parallelism\r\n17.7 Design of Parallel Systems\r\n17.8 Summary\r\nExercises\r\nBibliographic Notes\r\n18 Distributed Databases\r\n18.1 Distributed Data Storage\r\n18.2 Network Transparency\r\n18.3 Distributed Query Processing\r\n18.4 Distributed Transaction Model\r\n18.5 Commit Protocols\r\n18.6 Coordinator Selection\r\n18.7 Concurrency Control\r\n18.8 Deadlock Handling\r\n18.9 Multidatabase Systems\r\n18.10 Summary\r\nExercises\r\nBibliographic Notes\r\n19 Special Topics\r\n19.1 Security and Integrity\r\n19.2 Standardization\r\n19.3 Performance Benchmarks\r\n19.4 Performance Tuning\r\n19.5 Time in Databases\r\n19.6 User Interfaces\r\n19.7 Active Databases\r\n19.8 Summary\r\nExercises\r\nBibliographic Notes\r\n20 Advanced Transaction Processing\r\n20.1 Remote Backup Systems\r\n20.2 Transaction-Processing Monitors\r\n20.3 High -Performance Transaction Systems\r\n20.4 Long-Duration Transactions\r\n20.5 Real-Time Transaction Systems\r\n20.6 Weak Levels of Consistency\r\n20.7 Transactional Workflows\r\n20.8 Summary\r\nExercises\r\nBibliographic Notes\r\n21 New Applications\r\n21.1 Decision-Support Systems\r\n21.2 Data Analysis\r\n21.3 Data Mining\r\n21.4 Data Warehousing\r\n21.5 Spatial and Geographic Databases\r\n21.6 Multimedia Databases\r\n21.7 Mobility and Personal Databases\r\n21.8 Information-Retrieval Systems\r\n21.9 Distributed Information Systems\r\n21.10 The World Wide Web\r\n21.11 Summary\r\nExercises\r\nBibliographic Notes\r\nA Network Model\r\nA. I Basic Concepts\r\nA.2 Data-Structure Diagrams\r\nA.3 The DBTG CO DASYL Model\r\nA.4 Implementation Techniques\r\nA.5 Discussion\r\nB Hierarchical Model\r\nB.1 Basic Concepts\r\nB.2 Tree-Structure Diagrams\r\nB.3 Implementation Techniques\r\nB.4 The IMS Database System\r\nB.5 Discussion\r\nBibliography\r\nIndex\r\n\r\n \r\n
\r\n
Abraham Silberschatz,纽约州立大学石溪分校博士. 现任朗讯公司贝尔实验室信息科学研究中心主任. 他曾任德克萨斯大学奥斯汀分校计算机科学系教授. Silberschatz博士是一位一流的研究者. 教育者和著作者. 他的研究方向包括数据库系统. 操作系统和分布式系统. . 他还是《操作系统概念》教科书的作者之一. Siberschatz博士是ACM会员. Henry F. Korth,普林斯顿大学博士, 现为朗讯公司贝尔实验室的技术人员.