数据库系统原理教程 / “十四五”普通高等教育系列教材
￥50.00定价
作者： 葛洪伟
出版时间：2021-11
出版社：中国电力出版社有限公司
- 中国电力出版社有限公司
- 9787519846794
- 1版
- 421750
- 48248571-1
- 平装
- 16开
- 2021-11
- 268
- 工学
- 电子科学与技术
- 电子信息、计算机
- 本科
内容简介
本书为“十四五”普通高等教育系列教材。
本书较全面地介绍了数据库系统的基本原理和应用。全书共8 章，主要内容包括数据库系统概述、关系数据模
型、关系数据库语言SQL、关系的规范化理论、关系数据库设计、数据库安全保护、网络数据库系统和数据仓库。
本书内容全面、实例丰富，即注重基本概念、基本原理的讲解，也注重数据库新技术、新应用的介绍。每章后面都
配有小结并附有适量的习题，便于读者巩固所学知识。为方便教学，本书配有用PowerPoint 制作的电子教案。
本书可作为高等院校计算机、信息管理、电子商务及相关专业的数据库课程教材，也可供从事计算机软件工作
的科技人员和工程技术人员及其他有关部门人员的参考书。
本书较全面地介绍了数据库系统的基本原理和应用。全书共8 章，主要内容包括数据库系统概述、关系数据模
型、关系数据库语言SQL、关系的规范化理论、关系数据库设计、数据库安全保护、网络数据库系统和数据仓库。
本书内容全面、实例丰富，即注重基本概念、基本原理的讲解，也注重数据库新技术、新应用的介绍。每章后面都
配有小结并附有适量的习题，便于读者巩固所学知识。为方便教学，本书配有用PowerPoint 制作的电子教案。
本书可作为高等院校计算机、信息管理、电子商务及相关专业的数据库课程教材，也可供从事计算机软件工作
的科技人员和工程技术人员及其他有关部门人员的参考书。
目录
前言
第1 章 数据库系统概述··············································································································1
1.1 数据管理技术的演变·····································································································1
1.2 数据库系统的组成·········································································································3
1.3 数据库系统的三级模式结构··························································································4
1.4 数据模型·························································································································6
1.5 数据库管理系统···········································································································13
1.6 数据库的其他新技术···································································································15
1.7 小结·······························································································································21
习题·······································································································································21
第2 章 关系数据模型················································································································22
2.1 关系模型概述···············································································································22
2.2 关系代数·······················································································································28
2.3 关系演算·······················································································································34
2.4 查询优化·······················································································································43
2.5 小结·······························································································································47
习题·······································································································································48
第3 章 关系数据库语言SQL ···································································································50
3.1 SQL 概述······················································································································50
3.2 SQL 的数据定义···········································································································55
3.3 SQL 的数据查询···········································································································63
3.4 SQL 的数据更新···········································································································80
3.5 视图·······························································································································83
3.6 SQL 的数据控制···········································································································88
3.7 嵌入式SQL ··················································································································90
3.8 小结·····························································································································100
习题·····································································································································100
第4 章 关系的规范化理论······································································································102
4.1 关系模型的冗余和异常问题······················································································102
4.2 规范化理论的主要内容······························································································103
4.3 数据依赖·····················································································································104
4.4 范式·····························································································································109
4.5 函数依赖的公理系统·································································································113
4.6 关系模式的规范化····································································································· 114
4.7 小结···························································································································· 127
习题····································································································································· 127
第5 章 关系数据库设计·········································································································· 128
5.1 数据库设计概述········································································································· 128
5.2 需求分析···················································································································· 130
5.3 概念结构设计············································································································· 134
5.4 逻辑结构设计············································································································· 139
5.5 物理结构设计············································································································· 144
5.6 数据库的实施和维护································································································· 146
5.7 数据库设计实例解析································································································· 147
5.8 小结···························································································································· 154
习题····································································································································· 154
第6 章 数据库安全保护·········································································································· 155
6.1 数据库的安全性········································································································· 155
6.2 数据库的完整性········································································································· 162
6.3 并发控制技术············································································································· 164
6.4 数据库恢复技术········································································································· 174
6.5 小结···························································································································· 179
习题····································································································································· 179
第7 章 网络数据库系统·········································································································· 181
7.1 网络数据库················································································································· 181
7.2 常用网络数据库管理系统························································································· 188
7.3 网络数据库管理系统SQL Server 2014····································································· 190
7.4 SQL Server 程序设计································································································· 219
7.5 SQL Server 2017 系统································································································ 234
7.6 小结···························································································································· 239
习题····································································································································· 240
第8 章 数据仓库····················································································································· 241
8.1 数据仓库概述············································································································· 241
8.2 数据仓库的数据组织································································································· 243
8.3 数据仓库系统的体系结构························································································· 244
8.4 联机分析处理OLAP·································································································· 246
8.5 如何建立数据仓库····································································································· 253
8.6 数据挖掘（Data Mining）························································································· 256
8.7 小结···························································································································· 261
习题····································································································································· 261
参考文献····································································································································· 262
第1 章 数据库系统概述··············································································································1
1.1 数据管理技术的演变·····································································································1
1.2 数据库系统的组成·········································································································3
1.3 数据库系统的三级模式结构··························································································4
1.4 数据模型·························································································································6
1.5 数据库管理系统···········································································································13
1.6 数据库的其他新技术···································································································15
1.7 小结·······························································································································21
习题·······································································································································21
第2 章 关系数据模型················································································································22
2.1 关系模型概述···············································································································22
2.2 关系代数·······················································································································28
2.3 关系演算·······················································································································34
2.4 查询优化·······················································································································43
2.5 小结·······························································································································47
习题·······································································································································48
第3 章 关系数据库语言SQL ···································································································50
3.1 SQL 概述······················································································································50
3.2 SQL 的数据定义···········································································································55
3.3 SQL 的数据查询···········································································································63
3.4 SQL 的数据更新···········································································································80
3.5 视图·······························································································································83
3.6 SQL 的数据控制···········································································································88
3.7 嵌入式SQL ··················································································································90
3.8 小结·····························································································································100
习题·····································································································································100
第4 章 关系的规范化理论······································································································102
4.1 关系模型的冗余和异常问题······················································································102
4.2 规范化理论的主要内容······························································································103
4.3 数据依赖·····················································································································104
4.4 范式·····························································································································109
4.5 函数依赖的公理系统·································································································113
4.6 关系模式的规范化····································································································· 114
4.7 小结···························································································································· 127
习题····································································································································· 127
第5 章 关系数据库设计·········································································································· 128
5.1 数据库设计概述········································································································· 128
5.2 需求分析···················································································································· 130
5.3 概念结构设计············································································································· 134
5.4 逻辑结构设计············································································································· 139
5.5 物理结构设计············································································································· 144
5.6 数据库的实施和维护································································································· 146
5.7 数据库设计实例解析································································································· 147
5.8 小结···························································································································· 154
习题····································································································································· 154
第6 章 数据库安全保护·········································································································· 155
6.1 数据库的安全性········································································································· 155
6.2 数据库的完整性········································································································· 162
6.3 并发控制技术············································································································· 164
6.4 数据库恢复技术········································································································· 174
6.5 小结···························································································································· 179
习题····································································································································· 179
第7 章 网络数据库系统·········································································································· 181
7.1 网络数据库················································································································· 181
7.2 常用网络数据库管理系统························································································· 188
7.3 网络数据库管理系统SQL Server 2014····································································· 190
7.4 SQL Server 程序设计································································································· 219
7.5 SQL Server 2017 系统································································································ 234
7.6 小结···························································································································· 239
习题····································································································································· 240
第8 章 数据仓库····················································································································· 241
8.1 数据仓库概述············································································································· 241
8.2 数据仓库的数据组织································································································· 243
8.3 数据仓库系统的体系结构························································································· 244
8.4 联机分析处理OLAP·································································································· 246
8.5 如何建立数据仓库····································································································· 253
8.6 数据挖掘（Data Mining）························································································· 256
8.7 小结···························································································································· 261
习题····································································································································· 261
参考文献····································································································································· 262
