Database management systems : designing and building business applications = 数据库管理系统 / 3rd...
副标题：无
作 者：Gerald V. Post著.
分类号：
ISBN：9787111178521
微信扫一扫,移动浏览光盘
简介
对于管理和信息技术的专业人员来说，数据库是最重要和最实用的工具之一。数据库为在机构内集成、组织和共享数据提供了基础。数据库管理方法提供了很多传统编程技术无法比拟的优势，主要包括更短的开发时间、更容易修改、更好的数据完整性与安全性以及更强的数据共享和集成。而dbms是最复杂的实用技术工具之一。
本书涵盖了构建数据库前的两个关键主题：数据库设计 (规范化) 和sql (查询)。所有主要的数据库系统都涉及这两个主题。规范化说明了如何细致设计数据库以获得dbms能力。sql是一种标准查询语言，事实上用于应用程序开发的每一步。
本书特色
1. 侧重于现代业务应用程序开发。
●根据业务模型来阐述数据库设计。
●通过很多示例和练习强调动手实践应用。
●侧重于新型图形用户界面应用程序。
●包含数据库编程和应用程序开发的内容。
●关于编程和开发细节内容的附录。
2. 热点主题。
●介绍并使用统一建模语言 (uml) 来建模和绘制系统图表。
●关于数据库环境下安全主题的深入讨论。
●因特网和内联网的数据库开发。
●强调sql 92，同时介绍sql 99和sql 200x的xml特性。
●数据库中完整的应用程序和对象。
3. 实用的业务练习和案例。
●很多数据库设计问题。
●涵盖应用程序开发所有方面的练习。
●适用于期末实践项目的案例。
.
4. 一个完整的示例数据库应用程序 (滚雷自行车)。
●功能完善的业务数据库。
●示例数据和数据产生例程。
●一般数据库操作的示例程序代码。
5. 用于比较和附加任务的第二个数据库 (sally的宠物商店)。
6. powerpoint幻灯片形式的讲课记录。
7. 为特定数据库技术编制的工作手册。
目录
chapter 1 introduction . 1
a developer's view 2
introduction 2
databases and application development 2
components of a database management system 4
database engine 4
data dictionary 5
query processor 6
report writer 6
forms generator 8
application generator 9
communication and integration 9
security and other utilities 10
advantages of the database management system approach 10
focus on data 11
data independence 12
data independence and client/server systems 13
leading commercial databases 13
brief history of database management systems 14
hierarchical databases 14
.network databases 14
relational databases 16
object-oriented databases 16
application development 20
sally's pet store 21
rolling thunder bicycles 22
the feasibility study 22
costs 23
benefits 24
summary 25
key terms 26
review questions 26
exercises 26
website references 28
additional reading 28
part one systems design 29
chapter 2 database design 30
a developer's view 31
introduction 31
getting started 32
designing databases 33
identifying user requirements 33
business objects 34
tables and relationships 35
definitions 35
primary key 36
class diagrams 37
classes and entities 37
associations and relationships 38
class diagram details 39
sally's pet store class diagram 47
data types (domains) 49
text 50
numbers 50
dates and times 51
binary objects 52
computed values 52
user-defined types
(domains/objects) 53
events 53
large projects 55
rolling thunder bicycles 56
application design 61
summary 62
key terms 63
review questions 63
exercises 64
website references 69
additional reading 69
appendix: database design system 70
sample problem: customer orders 70
getting started: ldentifying columns 70
creating a table and adding
columns 71
relationships: connecting tables 73
grading: detecting and solving
problems 73
specifying data types 76
chapter 3 data normalization 77
a developer's view 78
introduction 78
tables, classes, and keys 79
composite keys 79
surrogate keys 80
notation 81
sample database for a video store 83
initial objects 84
initial form evaluation 85
problems with repeating sections 87
first normal form 89
repeating groups 89
nested repeating groups 90
second normal form 91
problems with first normal form 91
second normal form definition 92
dependence 93
third normal form 94
problems with second normal form 94
third normal form definition 95
checking your work 97
beyond third normal form 98
boyce-codd normal form 98
fourth normal form 99
domain-key normal form 100
data rules and integrity 102
the effects of business rules 104
converting a class diagram to normalized tables 106
one-to-many relationships 106
many-to-many relationships 108
n-ary associations 108
generalization or subtypes 108
composition 110
reflexive associations 111
summary 112
sally's pet store example 112
view integration 115
sally's pet store example 115
rolling thunder sample integration problem 117
data dictionary 123
dbms table definition 123
data volume and usage 127
summary 129
key terms 130
review questions 130
exercises 131
website references 138
additional reading 138
appendix: formal definitions of normalization 139
initial definitions 139
normal form definitions 140
part two queries 143
chapter 4 data queries 144
a developer's view 145
introduction 145
three tasks of a query language 146
four questions to retrieve data 146
what output do you want to see? 147
what do you already know? 147
what tables are involved? 147
how are the tables joined? 147
sally's pet store 148
vendor differences 149
query basics 149
single tables 149
introduction to sql 151
sorting the output 151
distinct 152
criteria 153
boolean algebra 154
demorgan's law 155
useful where clauses 158
computations 159
basic arithmetic operators 159
aggregation 159
functions 162
subtotals and group by 163
conditions on totals (having) 164
where versus having 165
the best and the worst 166
multiple tables 166
joining tables 167
identifying columns in different tables 168
joining many tables 169
hints on joining tables 170
table alias 172
create view 172
summary 174
key terms 175
review questions 175
exercises 175
website references 178
additional reading 178
appendix: sql syntax 179
altertable 179
commit work 179
create index 179
create table 179
create trigger 179
create view 180
delete 180
drop 180
insert 180
grant 180
revoke 180
rollback 181
select 181
select into 181
update 181
chapter 5 advanced queries and subqueries 182
a developer's view 183
introduction .. 183
sally's pet store 184
subqueries 184
calculations or simple lookup 184
subqueries and sets of data 185
subquery with any and all 185
subtraction: not in 187
outer joins 188
correlated subqueries are dangerous 190
more features and tricks with sqlselect 193
union, intersect, except 193
multiple join columns 194
reflexive join 195
case function 196
inequality joins 197
questions with "every" need the exists clause i97
sql select summary 199
sql data definition commands 199
sql data manipulation commands 201
insert and delete 201
update 202
quality: testing queries 203
summary 205
key terms 206
review questions 206
exercises 206
website references 210
additional reading 210
appendix: introduction to programming 211
variables and data 211
variable scope 212
computations 213
standard internal functions 214
input and output 215
conditions 216
loops 217
subroutines 218
summary 220
part three applications 221
chapter 6 forms, reports, and applications 222
a developer's view 223
introduction 223
effective design of reports and forms 224
human factors design 224
window controls 226
user interface--web notes 228
user interface--accessibility issues 229
form layout 230
tabular forms 230
single-row or columnar-forms 231
subform forms 232
switchboard forms 233
creating forms 235
updateable queries 235
linked forms 236
properties and controls 236
controls on forms 237
multiple forms 241
international attributes 243
direct manipulation of graphical objects 245
sally's pet store example 245
the internet 246
complications and limitations of a graphical approach 247
reports 247
report design 248
terminology 248
basic report types 250
graphs 254
application features 255
menus and toolbars 255
custom help 257
summary 261
key terms 262
review questions 262
exercises 262
website references 264
additional reading 264
chapter 7 database integrity and transactions 265
a developer's view 266
introduction 266
procedural languages 266
where should code be located? 267
user-defined functions 268
looking up data 269
data triggers 269
statement versus row triggers 270
canceling data changes in triggers 271
cascading triggers 272
instead of triggers 273
transactions 274
a transaction example 274
starting and ending transactions 274
savepoint 276
multiple users and concurrent access 276
pessimistic locks: serialization 277
multiuser databases: concurrent access and deadlock 278
optimistic locks 280
acid transactions 281
key generation 283
database cursors 285
cursor basics 285
scrollable cursors 286
changing or deleting data with cursors 287
cursors with parameters 288
merchandise inventory at sally's pet
store 289
summary 293
key terms 294
review questions 294
exercises 294
website references 296
additional reading 297
chapter 8 data warehouses and data mining 298
a developer's view 299
introduction 299
indexes 300
binary search 300
pointers and indexes 301
bitmap index and statistics 301
problems with'indexes 302
data warehouses and online analytical processing 303
data warehouse goals 303
data warehouse issues 305
olap concepts 306
olap database design 308
olap data analysis 310
olapin sql 312
sql analytic functions 316
sql olap windows 316
data mining 318
classification 320
association rules/market basket analysis 321
cluster analysis 323
geographic analysis 324
summary 325
key terms 326
review questions 326
exercises 326
website references 327
additional reading 328
part four database administration 329
chapter 9 database administration 330
a developer's view 331
introduction 331
data administrator 332
database administrator 333
database structure 334
metadata 335
database tasks by development stages 336
database planning 336
database design 337
database implementation 338
database operation and maintenance 338
backup and recovery 339
security and privacy 341
data privacy 341
threats 342
physical security 342
managerial controls 344
logical security 344
division of duties 349
software updates 350
encryption 351
sally's pet store 353
summary 355
key terms 356
review questions 356
exercises 357
website references 359
additional reading 359
chapter 10
distributed databases and the internet 360
a developer's view 361
introduction 361
sally's pet store 361
distributed databases 362
goals and rules 363
advantages and applications 364
creating a distributed database system 366
distributed query processing 367
data replication 369
concurrency, locks, and transactions 370
independent transaction managers 372
distributed design questions 372
client/server databases 373
client/server versus file server 374
three-tier client/server model 375
the back end: server databases 377
the front end: windows clients 377
maintaining database independence in the client 378
electronic commerce databases 380
the web as a client/server system 381
htmi,-limited clients 381
web server database fundamentals 383
data transmission issues in applications 385
xml: transferring data to diverse
systems 387
java and jdbc 391
summary 392
key terms 393
review questions 393
exercises 394
website references 395
additional reading ...396
a developer's view 2
introduction 2
databases and application development 2
components of a database management system 4
database engine 4
data dictionary 5
query processor 6
report writer 6
forms generator 8
application generator 9
communication and integration 9
security and other utilities 10
advantages of the database management system approach 10
focus on data 11
data independence 12
data independence and client/server systems 13
leading commercial databases 13
brief history of database management systems 14
hierarchical databases 14
.network databases 14
relational databases 16
object-oriented databases 16
application development 20
sally's pet store 21
rolling thunder bicycles 22
the feasibility study 22
costs 23
benefits 24
summary 25
key terms 26
review questions 26
exercises 26
website references 28
additional reading 28
part one systems design 29
chapter 2 database design 30
a developer's view 31
introduction 31
getting started 32
designing databases 33
identifying user requirements 33
business objects 34
tables and relationships 35
definitions 35
primary key 36
class diagrams 37
classes and entities 37
associations and relationships 38
class diagram details 39
sally's pet store class diagram 47
data types (domains) 49
text 50
numbers 50
dates and times 51
binary objects 52
computed values 52
user-defined types
(domains/objects) 53
events 53
large projects 55
rolling thunder bicycles 56
application design 61
summary 62
key terms 63
review questions 63
exercises 64
website references 69
additional reading 69
appendix: database design system 70
sample problem: customer orders 70
getting started: ldentifying columns 70
creating a table and adding
columns 71
relationships: connecting tables 73
grading: detecting and solving
problems 73
specifying data types 76
chapter 3 data normalization 77
a developer's view 78
introduction 78
tables, classes, and keys 79
composite keys 79
surrogate keys 80
notation 81
sample database for a video store 83
initial objects 84
initial form evaluation 85
problems with repeating sections 87
first normal form 89
repeating groups 89
nested repeating groups 90
second normal form 91
problems with first normal form 91
second normal form definition 92
dependence 93
third normal form 94
problems with second normal form 94
third normal form definition 95
checking your work 97
beyond third normal form 98
boyce-codd normal form 98
fourth normal form 99
domain-key normal form 100
data rules and integrity 102
the effects of business rules 104
converting a class diagram to normalized tables 106
one-to-many relationships 106
many-to-many relationships 108
n-ary associations 108
generalization or subtypes 108
composition 110
reflexive associations 111
summary 112
sally's pet store example 112
view integration 115
sally's pet store example 115
rolling thunder sample integration problem 117
data dictionary 123
dbms table definition 123
data volume and usage 127
summary 129
key terms 130
review questions 130
exercises 131
website references 138
additional reading 138
appendix: formal definitions of normalization 139
initial definitions 139
normal form definitions 140
part two queries 143
chapter 4 data queries 144
a developer's view 145
introduction 145
three tasks of a query language 146
four questions to retrieve data 146
what output do you want to see? 147
what do you already know? 147
what tables are involved? 147
how are the tables joined? 147
sally's pet store 148
vendor differences 149
query basics 149
single tables 149
introduction to sql 151
sorting the output 151
distinct 152
criteria 153
boolean algebra 154
demorgan's law 155
useful where clauses 158
computations 159
basic arithmetic operators 159
aggregation 159
functions 162
subtotals and group by 163
conditions on totals (having) 164
where versus having 165
the best and the worst 166
multiple tables 166
joining tables 167
identifying columns in different tables 168
joining many tables 169
hints on joining tables 170
table alias 172
create view 172
summary 174
key terms 175
review questions 175
exercises 175
website references 178
additional reading 178
appendix: sql syntax 179
altertable 179
commit work 179
create index 179
create table 179
create trigger 179
create view 180
delete 180
drop 180
insert 180
grant 180
revoke 180
rollback 181
select 181
select into 181
update 181
chapter 5 advanced queries and subqueries 182
a developer's view 183
introduction .. 183
sally's pet store 184
subqueries 184
calculations or simple lookup 184
subqueries and sets of data 185
subquery with any and all 185
subtraction: not in 187
outer joins 188
correlated subqueries are dangerous 190
more features and tricks with sqlselect 193
union, intersect, except 193
multiple join columns 194
reflexive join 195
case function 196
inequality joins 197
questions with "every" need the exists clause i97
sql select summary 199
sql data definition commands 199
sql data manipulation commands 201
insert and delete 201
update 202
quality: testing queries 203
summary 205
key terms 206
review questions 206
exercises 206
website references 210
additional reading 210
appendix: introduction to programming 211
variables and data 211
variable scope 212
computations 213
standard internal functions 214
input and output 215
conditions 216
loops 217
subroutines 218
summary 220
part three applications 221
chapter 6 forms, reports, and applications 222
a developer's view 223
introduction 223
effective design of reports and forms 224
human factors design 224
window controls 226
user interface--web notes 228
user interface--accessibility issues 229
form layout 230
tabular forms 230
single-row or columnar-forms 231
subform forms 232
switchboard forms 233
creating forms 235
updateable queries 235
linked forms 236
properties and controls 236
controls on forms 237
multiple forms 241
international attributes 243
direct manipulation of graphical objects 245
sally's pet store example 245
the internet 246
complications and limitations of a graphical approach 247
reports 247
report design 248
terminology 248
basic report types 250
graphs 254
application features 255
menus and toolbars 255
custom help 257
summary 261
key terms 262
review questions 262
exercises 262
website references 264
additional reading 264
chapter 7 database integrity and transactions 265
a developer's view 266
introduction 266
procedural languages 266
where should code be located? 267
user-defined functions 268
looking up data 269
data triggers 269
statement versus row triggers 270
canceling data changes in triggers 271
cascading triggers 272
instead of triggers 273
transactions 274
a transaction example 274
starting and ending transactions 274
savepoint 276
multiple users and concurrent access 276
pessimistic locks: serialization 277
multiuser databases: concurrent access and deadlock 278
optimistic locks 280
acid transactions 281
key generation 283
database cursors 285
cursor basics 285
scrollable cursors 286
changing or deleting data with cursors 287
cursors with parameters 288
merchandise inventory at sally's pet
store 289
summary 293
key terms 294
review questions 294
exercises 294
website references 296
additional reading 297
chapter 8 data warehouses and data mining 298
a developer's view 299
introduction 299
indexes 300
binary search 300
pointers and indexes 301
bitmap index and statistics 301
problems with'indexes 302
data warehouses and online analytical processing 303
data warehouse goals 303
data warehouse issues 305
olap concepts 306
olap database design 308
olap data analysis 310
olapin sql 312
sql analytic functions 316
sql olap windows 316
data mining 318
classification 320
association rules/market basket analysis 321
cluster analysis 323
geographic analysis 324
summary 325
key terms 326
review questions 326
exercises 326
website references 327
additional reading 328
part four database administration 329
chapter 9 database administration 330
a developer's view 331
introduction 331
data administrator 332
database administrator 333
database structure 334
metadata 335
database tasks by development stages 336
database planning 336
database design 337
database implementation 338
database operation and maintenance 338
backup and recovery 339
security and privacy 341
data privacy 341
threats 342
physical security 342
managerial controls 344
logical security 344
division of duties 349
software updates 350
encryption 351
sally's pet store 353
summary 355
key terms 356
review questions 356
exercises 357
website references 359
additional reading 359
chapter 10
distributed databases and the internet 360
a developer's view 361
introduction 361
sally's pet store 361
distributed databases 362
goals and rules 363
advantages and applications 364
creating a distributed database system 366
distributed query processing 367
data replication 369
concurrency, locks, and transactions 370
independent transaction managers 372
distributed design questions 372
client/server databases 373
client/server versus file server 374
three-tier client/server model 375
the back end: server databases 377
the front end: windows clients 377
maintaining database independence in the client 378
electronic commerce databases 380
the web as a client/server system 381
htmi,-limited clients 381
web server database fundamentals 383
data transmission issues in applications 385
xml: transferring data to diverse
systems 387
java and jdbc 391
summary 392
key terms 393
review questions 393
exercises 394
website references 395
additional reading ...396
Database management systems : designing and building business applications = 数据库管理系统 / 3rd...
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
