本書概括介紹了資料庫系統的基本原理、基本概念以及資料庫技術的最新研究動態，重點以進銷存管理系統為例詳細闡述了資料庫設計的過程，較詳細地介紹了Oracel、SQL Server 等主流資料庫和PowerDesigner 建模工具的相關知識和具體操作。全書分為四部分：(1)基礎篇，包括資料庫系統概述、關係理論、關係查詢語言三章。
基本介紹
- 書名：現代資料庫技術
- 作者：趙正文
- 頁數：384
- 出版社：電子科技大學出版社
- 出版時間：13-01-04
- 開本：16開
書籍信息,內容簡介,圖書目錄,
書籍信息
作 者：趙正文 ISBN: 978–7–5647–1432–1
出版時間：13-01-04
出版時間：13-01-04
- 版 次：第一版
- 頁 數：384
- 字 數：493千字
- 印刷時間：13-01-04
- 開 本：16開
- 紙 張：書寫紙
- 印 次：1
- 包 裝：平裝
內容簡介
本書概括介紹了資料庫系統的基本原理、基本概念以及資料庫技術的最新研究動態，重點以進銷存管理系統為例詳細闡述了資料庫設計的過程，較詳細地介紹了Oracel、SQL Server 等主流資料庫和PowerDesigner 建模工具的相關知識和具體操作。全書分為四部分：(1)基礎篇，包括資料庫系統概述、關係理論、關係查詢語言三章。
圖書目錄
第一部分 基礎篇
第1 章 資料庫系統概述······················································································· 2
1.1 資料庫技術的發展.............................................................................................2
1.2 資料庫的基本概念.............................................................................................5
1.3 數據抽象.............................................................................................................6
1.4 資料庫管理系統...............................................................................................15
1.5 資料庫系統.......................................................................................................33
1.6 小結...................................................................................................................36
第2 章 關係理論································································································· 37
2.1 關係模型概述...................................................................................................37
2.2 關係代數...........................................................................................................38
2.3 關係演算...........................................................................................................44
2.4 關係資料庫設計...............................................................................................47
2.5 小結...................................................................................................................55
第3 章 關係查詢語言························································································· 56
3.1 SQL 簡述..........................................................................................................56
3.2 數據定義...........................................................................................................58
3.3 數據更新...........................................................................................................61
3.4 數據查詢...........................................................................................................65
3.5 數據控制...........................................................................................................80
3.6 視圖...................................................................................................................82
3.7 嵌入式SQL ......................................................................................................84
3.8 資料庫查詢最佳化...............................................................................................86
3.9 Oracle 和SQL Server 對標準SQL 的擴充.....................................................91
3.10 小結.................................................................................................................94
第二部分 套用篇
第4 章 資料庫套用概述····················································································· 97
4.1 資料庫在套用系統中的重要地位...................................................................97
4.2 資料庫設計.......................................................................................................98
4.3 實例介紹.........................................................................................................101
4.4 小 結.........................................................................................................102
第5 章 需求分析······························································································· 103
5.1 需求分析的任務.............................................................................................103
5.2 需求分析的過程.............................................................................................104
5.3 數據流圖和數據字典.....................................................................................105
5.4 獲取需求的重要方法——調研.....................................................................107
5.5 需求分析實例.................................................................................................108
5.6 小結.................................................................................................................121
第6 章 資料庫概念設計··················································································· 123
6.1 概念設計的任務.............................................................................................123
6.2 E-R 模型.........................................................................................................123
6.3 概念設計的方法和步驟.................................................................................129
6.4 概念設計實例.................................................................................................133
6.5 小結.................................................................................................................147
第7 章 資料庫邏輯設計··················································································· 148
7.1 邏輯設計的基本概念.....................................................................................148
7.2 邏輯設計的任務.............................................................................................150
7.3 邏輯設計的步驟.............................................................................................150
7.4 邏輯設計實例.................................................................................................153
7.5 小結.................................................................................................................157
第8 章 資料庫用戶事務綜合設計··································································· 158
8.1 概述.................................................................................................................158
8.2 用戶事務綜合設計實例.................................................................................165
8.3 創建資料庫設計文檔.....................................................................................178
8.4 生成SQL 腳本...............................................................................................181
8.5 小結.................................................................................................................188
第9 章 資料庫物理設計及實現······································································· 190
9.1 概述.................................................................................................................190
9.2 創建ERM 系統資料庫..................................................................................191
9.3 小結.................................................................................................................199
第三部分 專題篇
第10 章 資料庫技術的研究發展····································································· 201
10.1 概述...............................................................................................................201
10.2 面向對象資料庫系統...................................................................................204
10.3 分散式資料庫...............................................................................................217
10.4 數據倉庫.......................................................................................................235
10.5 在線上分析處理技術.......................................................................................245
10.6 數據挖掘.......................................................................................................253
10.7 其他資料庫技術...........................................................................................259
第11 章 XML 技術··························································································· 277
11.1 XML 概述.....................................................................................................277
11.2 XML 文檔.....................................................................................................280
11.3 在.NET 中使用XML ...................................................................................289
11.4 小結...............................................................................................................293
第12 章 主流DBMS························································································· 294
12.1 SQL Server ....................................................................................................294
12.2 Oracle ............................................................................................................321
12.3 DB2 ...............................................................................................................343
12.4 Informix.........................................................................................................348
12.5 Sybase............................................................................................................352
12.6 MySQL..........................................................................................................357
12.7 Access............................................................................................................362
12.8 小結...............................................................................................................364
附錄A UML 類圖····························································································· 368
附錄B PowerDesigner······················································································· 369
B.1 PowerDesigner 概述.......................................................................................369
B.2 建立概念數據模型........................................................................................371
B.3 建立物理數據模型........................................................................................375
B.4 創建報告文檔................................................................................................380
B.5 小結................................................................................................................383
