| Gerald V. Post 1983年子艾奥瓦州立大学获得博士学位，现为太平洋大学管理信息系统教授，讲授管理信息系统、数据库管理、系统开发、网站开发等课程。其网站http：／／jerrypost．com／DBBook／／index．html提供本书相关资源下载。... .. << 查看详细 |
| 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 |
内容加载中，请稍后...
商品评论（0条）