数据库系统概念

出版时间：2012-12  出版社：机械工业出版社  作者：（美）西尔伯莎　等著，杨冬青　改编  页数：760  
Tag标签：无  

前言

　　数据库系统是对数据进行存储、管理、处理和维护的软件系统，是现代计算环境中的一个核心成分。随着计算机硬件、软件技术的飞速发展和计算机系统在各行各业的广泛应用，数据库技术的发展尤其迅速，引人注目。有关数据库系统的理论和技术是计算机科学技术教育中必不可少的部分。《数据库系统概念》是一本经典的、备受赞扬的数据库系统教科书，其内容由浅入深，既包含数据库系统的基本概念，又反映数据库技术新进展。本书被国际上许多著名大学采用，并多次再版。　　我们先后将本书的第3版、第4版、第5版和第6版译成中文，由机械工业出版社分别于2000年、2003年、2006年和2012年出版发行。国内许多大学采用《数据库系统概念》作为本科生和研究生数据库课程的教材或主要教学参考书，收到了良好的效果。　　我们基于《数据库系统概念》第5版进行了改编，保留其中的基本内容，压缩或删除了一些高级内容，形成了该书的本科教学版，其目的是使它更适合本科生的数据库课程使用。该本科教学版由机械工业出版社于2008年出版发行，被国内许多高校采用作为本科生数据库课程的教材或主要教学参考书。　　现在我们又基于《数据库系统概念》第6版进行了改编工作，希望它能够成为一本效果更好、更实用的本科生数据库课程的教材。　　……

内容概要

　　《数据库系统概念》是数据库系统方面的经典教材之一，其内容由浅入深，既包含数据库系统基本概念，又反映数据库技术新进展。它被国际上许多著名大学所采用，包括斯坦福大学、耶鲁大学、得克萨斯大学、康奈尔大学、伊利诺伊大学等。我国也有多所大学采用《数据库系统概念(英文精编版.第6版)》作为本科生和研究生数据库课程的教材和主要教学参考书，收到了良好的效果。本书基于该书第6版进行改编，保留其中的基本内容，压缩或删除了一些高级内容，更加适合作为国内高校计算机及相关专业本科生数据库课程教材。

作者简介

　　Abraham Silberchatz于纽约州立大学石溪分校获得博士学位，现为耶鲁大学计算机科学Sidney
J．Weinberg教授，计算机科学系主任，曾任贝尔实验室信息科学研究中心副主任、、
　　Henry
F．Korth于普林斯顿大学获得博士学位，现为利哈伊大学计算机科学与工程系Weiserman教授，曾任贝尔实验室数据库原理研究中心主任。他是ACM
Fellow和IEEE Fellow，是VLDB 10年贡献奖的获得者。
　　S．Sudarshan于威斯康星大学麦迪逊分校获得博士学位，现为印度理工学院计算机科学与工程系教授，曾为贝尔实验室数据库研究组技术人员。
点击查看更多内容

书籍目录

chapter 1 introduction
1.1 database-system applications
1.2 purpose of database systems
1.3 view of data
1.4 database languages
1.5 relational databases
1.6 database design
1.7 data storage and querying
1.8 transaction management
1.9 database architecture
1.10 data mining and information retrieval
1.11 specialty databases
1.12 database users and administrators
1.13 history of database systems
1.14 summary
review terms
practice exercises
exercises
tools
bibliographical notes
part one relational databases
chapter 2 introduction to the relational model
2.1 structure of relational databases
2.2 database schema
2.3 keys
2.4 schema diagrams
2.5 relational query languages
2.6 relational operations
2.7 summary
review terms
practice exercises
exercises
bibhographical notes
chapter 3 introduction to sql
3.1 overview of the sql query language
3.2 sql data definition
3.3 basic structure of sql queries
3.4 additional basic operations
3.5 set operations
3.6 null values
3.7 aggregate functions
3.8 nested subqueries
3.9 modification of the database
3.10 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 4 intermediate sql
4.1 join expressions
4.2 views
4.3 transactions
4.4 integrity constraints
4.5 sql data types and schemas
4.6 authorization
4.7 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 5 advanced sql
5.1 accessing sql from a programming language
5.2 functions and procedures
5.3 triggers
5.4 recursive queries**
5.5 advanced aggregation features**
5.60lap**
5.7 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 6 formal relational query languages
6.1 the relational algebra
6.2 the tuple relational calculus
6.3 the domain relational calculus
6.4 summary
review terms
practice exercises
exercises
bibliographical notes
part two database design
chapter 7 database design and the e-r model
7.1 overview of the design process
7.2 the entity-relationship model
7.3 constraints
7.4 removing redundant attributes in entity sets
7.5 entity-relationship diagrams
7.6 reduction to relational schemas
7.7 entity-relationship design issues
7.8 extended e-r features
7.9 alternative notations for modeling data
7.10 other aspects of database design
7.11 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 8 relational database design
8.1 features of good relational designs
8.2 atomic domains and first normal form
8.3 decomposition using functional dependencies
8.4 functional-dependency theory
8.5 algorithms for decomposition
8.6 decomposition using multivalued dependencies
8.7 more normal forms
8.8 database-design process
8.9 modeling temporal data
8.10 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 9 application design and development
9.1 application programs and user interfaces
9.2 web fundamentals
9.3 servlets and jsp
9.4 application architectures
9.5 rapid application development
9.6 application performance
9.7 application security
9.8 encryption and its applications
9.9 summary
review terms
practice exercises
exercises
project suggestions
tools
bibliographical notes
part three data storage,querying,and transaction management
chapter 10 data storage and data access
10.1 overview of physical storage media
10.2 magnetic disk and flash storage
10.3 organization of files and records
10.4 data-dictionary storage
10.5 database buffer
10.6 basic concepts of index
10.7 ordered indices
10.8 b+-tree index files
10.9 hash file organization and hash index
10.10 index definition in sql
10.11 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 11 query processing and query optimization
11.1 overview
11.2 measures of query cost
11.3 implementation of relational algebra operation
11.4 evaluation of expressions
11.5 query optimization
11.6 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 12 transaction management
12.1 transaction concept
12.2 transaction atomicity and durability
12.3 transaction isolation
12.4 serializability
12.5 recoverability
12.6 concurrency control
12.7 recovery system
12.8 summary
review terms
practice exercises
exercises
bibliographical notes
part four advanced topics
chapter 13 data warehousing and mining
13.1 decision-support systems
13.2 data warehousing
13.3 data mining
13.4 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 14 object-based databases
14.1 overview
14.2 complex data types
14.3 structured types and inheritance in sql
14.4 table inheritance
14.5 array and multiset types in sql
14.6 object-identity and reference types in sql
14.7 implementing o-r features
14.8 persistent programming languages
14.9 object-relational mapping
14.10 object-oriented versus object-relational
14.11 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 15 xml
15.1 motivation
15.2 structure of xml data
15.3 xml document schema
15.4 querying and transformation
15.5 application program interfaces to xml
15.6 storage of xml data
15.7 xml applications
15.8 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 16 advanced application development
16.1 performance tuning
16.2 performance benchmarks
16.3 other issues in application development
16.4 standardization
16.5 summary
review terms
practice exercises
exercises
bibliographical notes
bibliography

章节摘录

　　Atomicity： Suppose that， just before the execution of transaction Ti， the values of accounts A and B are $1000 and $2000， respectively. Now suppose that， during the execution of transaction Ti， a failure occurs that prevents Ti from completing its execution successfully. Further， suppose that the failure happened after the write（A） operation but before the write（B） operation. In this case， the values of accounts A and B reflected in the database are $950 and $2000. The system destroyed $50 as a result of this failure. In particular， we note that the sum A + B is no longer preserved.　　Thus， because of the failure， the state of the system no longer reflects a real state of the world that the database is supposed to capture. We term such a state an inconsistent state. We must ensure that such inconsistencies are not visible in a database system. Note， however， that the system must at some point be in an inconsistent state. Even if transaction Ti is executed to completion， there exists a point at which the value of account A is $950 and the value of account B is $2000， which is clearly an inconsistent state. This state， however， is eventually replaced by the consistent state where the value of account A is $950， and the value of account B is $2050.Thus， if the transaction never started or was guaranteed to complete， such an inconsistent state would not be visible except during the execution of the transaction. That is the reason for the atomicity requirement： If the atomicity property is present， all actions of the transaction are reflected in the database， or none are.　　The basic idea behind ensuring atomicity is this： The database system keeps track （on disk） of the old values of any data on which a transaction performs a write. This information is written to a file called the log. If the transaction does not complete its execution， the database system restores the old values from the log to make it appear as though the transaction never executed. Ensuring atomicity is the responsibility of the database system; specifically， it is handled by a component of the database called the recovery system， which we describe in detail in Section 12.7.　　Durability： Once the execution of the transaction completes successfully， and the user who initiated the transaction has been notified that the transfer of funds has taken place， it must be the case that no system failure can result in a loss of data corresponding to this transfer of funds. The durability property guarantees that， once a transaction completes successfully， all the updates that it carried out on the database persist， even if there is a system failure　　after the transaction completes execution.　　We assume for now that a failure of the computer system may result in loss of data in main memory， but data written to disk are never lost. We can guarantee durability by ensuring that either：　　1. The updates carried out by the transaction have been written to disk before the transaction completes.　　2. Information about the updates carried out by the transaction is written to disk， and such information is sufficient to enable the database to reconstruct the updates when the database system is restarted after the failure.　　……

编辑推荐

(美)Abraham Silberschatz、Henry F. Korth、(印)S. Sudarshan编著的《数据库系统概念》前9章是最基本的内容，讲述数据库系统的基本概念，包括对数据库系统的性质和目标的综述，对关系数据模型和关系语言的介绍，对数据库设计过程、关系数据库理论以及数据库应用设计和开发的详细讨论。第10至12章介绍了数据库系统实现的核心技术，包括数据存储管理、查询处理和事务管理。第13至16章是高级话题，介绍了数据仓库和数据挖掘，新型的数据库系统——基于对象的数据库和XML数据库t以及与高级应用开发相关的性能调整、性能基准程序、标准化等内容。

用户评论 (总计26条)

•   书中的内容虽然是英文，但读起来也不太费力，如果之前对数据库有一点点了解的话，很适合去看
•   数据库很好的一本教材
•   书不如第五版，更像中国的教材了。适应中国国情？
•   英文看不懂 看着没有感觉
•   价钱合适，发货速度够快。不过，对于书的内容还没有细读，不敢妄论，作为教材还算不错
•   去英国留学，不过英国教材超贵，这个是原版的，而且实惠。内容感觉挺有条理的
•   经典的外国教材，很满意
•   当教材用，就是经典！！！！
•   不是完整版，不过好好学习还是受益匪浅。
•   相对比较便宜 不过这教材看不懂
•   快递送到很快，很满意。书的内容也很好，深入浅出。
•   正品书籍，，，，，
•   质量还行，英文版的要很有耐心去读才行
•   书号 价钱也好 非常好的快递
•   快递挺快的，书也挺好的！
•   英文版，挺不错的，给力，物流速度也挺快！
•   书不错，值得买，物流也很给力！
•   全英的，学校用这个 值得购买
•   印刷质量挺不错的，有防伪标识，是正品。
•   现在学习使用，相信以后工作也会用到
•   一开始有点难，过一段时间之后适应了之后就比较好了，对提高英语也有很多帮助
•   快递很快，书也不错！！！
•   不是原版！！！！！是被阉割的本科教学版！！！！！！！！！！
•   第一次狠下心给自己买了一本英文原著，并且用它上了一学期的数据库课，最后感觉成功了，学到了很多东西。这本书是本科精编版，因此不会像其他书的英文版一样版面既小，页数又多，很适合作为计算机类学生第一本英文教材，狠下心看就能学到东西。
•   排版太密了，字太小，书的两边没有空余的地方可以记笔记，如果能把纸张换大一点，我愿意花多点钱。内容到无特别之处，但是作为教材，这本精简的还是适合教学的。
•   就喜欢英文版的，书的内容虽然有压缩，但够用了